[B! Oracle] Yuhtoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚ªãƒ©ã‚¯ãƒ«ã®ã‚µãƒ³è²·åŽ--äºˆæ¸¬ã•ã‚Œã‚‹ã€Œçµ±åˆã€ã¨ã„ã†èª²é¡Œ

æ–‡ï¼šStephen Shanklandï¼ˆCNET News.comï¼‰Â ç¿»è¨³æ ¡æ£ï¼šå·æ‘ã‚¤ãƒ³ã‚¿ãƒ¼ãƒŠã‚·ãƒ§ãƒŠãƒ« 2009-04-23 07:45 Oracleã¯ã€ã‚³ãƒ¼ãƒãƒ¬ãƒ¼ãƒˆã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ç”¨èªžã®é‡è¦ãªä¸€èªžã§ã‚ã‚‹ã€Œçµ±åˆã€ã«ã‚ˆã£ã¦ã€Sun Microsystemsã‚’74å„„ãƒ‰ãƒ«ã§è²·åŽã™ã‚‹ã“ã¨ã‚’æ£å½“åŒ–ã™ã‚‹ç†ç”±ã‚’è¦‹ã„ã ã—ãŸã€‚æ˜”ã‹ã‚‰æ‡ç–‘çš„ã ã£ãŸé¡§å®¢ã«ã‚‚ã€ãã®è€ƒãˆãŒé“ç†ã«ã‹ãªã£ã¦ã„ã‚‹ã“ã¨ã‚’ã“ã‚Œã‹ã‚‰ç´å¾—ã•ã›ãªã‘ã‚Œã°ãªã‚‰ãªã„ã€‚ ã“ã®å…¨é¡ç¾é‡‘ã«ã‚ˆã‚‹è²·åŽã®åˆæ„ã¯ç±³å›½æ™‚é–“4æœˆ20æ—¥ã«ç™ºè¡¨ã•ã‚Œã€Sunã®ä¿æœ‰ã™ã‚‹ç¾é‡‘ã‚’ç¹”ã‚Šè¾¼ã‚€ã¨Oracleã®è² æ‹…ã¯56å„„ãƒ‰ãƒ«ã¨ãªã‚Šã€2009å¹´å¤ã«å®Œäº†ã™ã‚‹è¦‹è¾¼ã¿ã ã€‚é©æ–°çš„ã ãŒçµŒæ¸ˆçš„ã«è‹¦å¢ƒã«ã‚ã‚‹Sun Microsystemsã¯ã€ã“ã®è²·åŽã§çª®çŠ¶ã‹ã‚‰æ•‘ã„å‡ºã•ã‚Œã‚‹ã€‚Sunã¯IBMãŒè²·åŽã«å‹•ã„ã¦ã„ãŸãŒã€4æœˆã«å…¥ã£ã¦ã‹ã‚‰äº¤æ¸‰ãŒæ±ºè£‚ã—ã¦ã„ãŸã€‚Sunã®ãƒ†ã‚¯ãƒŽãƒã‚¸ã‚’Oracleã®ãƒ“ã‚¸ãƒã‚¹ãƒ¢ãƒ‡ãƒ«ã«é©åˆã•ã›ã‚‹

Yuhto 2009/04/24

ãƒªãƒ³ã‚¯

Oracleã¯Sunã®è¼ãã‚’æ°¸ä¹…ã«å¥ªã†

Oracleã«ã‚ˆã‚‹Sunã®è²·åŽã¯ã€ã¨ã‚Šã‚ã‘ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã«ã¨ã£ã¦æ‚²ã—ã„å‡ºæ¥äº‹ã ã€‚OracleãŒã†ã‚‹ã•ã„ç«¶åˆè£½å“ã®MySQLã‚’ç”Ÿã‹ã—ç¶šã‘ã‚‹ç†ç”±ã¯ãªã„ã€‚ Oracleã¯Sun Microsystemsã‚’æ®ºãã†ã¨ã—ã¦ã„ã‚‹ã€‚ ä¸¡ç¤¾ã¯4æœˆ20æ—¥æœã€74å„„ãƒ‰ãƒ«ã®å–å¼•ã‚’ç™ºè¡¨ã—ãŸã€‚ä¸¡ç¤¾ã‚’é™¤ãITæ¥ç•Œå…¨ä½“ã«ã¨ã£ã¦ã€ã“ã‚Œã¯æ‚²ã—ã‚€ã¹ãå‡ºæ¥äº‹ã§ã‚ã‚‹ã€‚å–ªæœã‚’ç€ã¦ã€å“€æ‚¼ã®æ„ã‚’è¡¨ãã†ã§ã¯ãªã„ã‹ã€‚ã‚·ãƒªã‚³ãƒ³ãƒãƒ¬ãƒ¼ã§æœ€ã‚‚å„ªç§€ãªä¼æ¥ã®1ç¤¾ãŒæ¶ˆãˆãŸã®ã ã€‚ã‚·ãƒªã‚³ãƒ³ãƒãƒ¬ãƒ¼ãŒ1æœ¬ã®æœ¨ã ã¨ã™ã‚Œã°ã€Sunã¯ãã®å¤ªã„æ ¹ã®1æœ¬ã§ã‚ã‚‹ã€‚Sunã®å…±åŒå‰µæ¥è€…ã®ã‚¹ã‚³ãƒƒãƒˆãƒ»ãƒžã‚¯ãƒ‹ãƒ¼ãƒªãƒ¼æ°ã¯ã€åŒæ°ã‚’è¦‹ç¿’ã£ãŸå¤šãã®ã‚·ãƒªã‚³ãƒ³ãƒãƒ¬ãƒ¼ã®èµ·æ¥å®¶ã¨åŒã˜ãã‚¹ã‚¿ãƒ³ãƒ•ã‚©ãƒ¼ãƒ‰å¤§å¦å‡ºèº«ã§ã‚ã‚‹ã€‚ãƒžã‚¯ãƒ‹ãƒ¼ãƒªãƒ¼æ°ã‚’ã¯ã˜ã‚ã¨ã™ã‚‹ã‚¹ã‚¿ãƒ³ãƒ•ã‚©ãƒ¼ãƒ‰å¤§å‡ºèº«ã®èµ·æ¥å®¶ãŸã¡ã¯ã€ã‚·ãƒªã‚³ãƒ³ãƒãƒ¬ãƒ¼ã®æ–°èˆˆä¼æ¥ã«ã‚¤ãƒ³ãƒ†ãƒªã‚¸ã‚§ãƒ³ã‚¹ã¨ã‚¹ã‚¿ã‚¤ãƒ«ã‚’æŒã¡è¾¼ã‚“ã ã€‚1990å¹´ä»£ã‹ã‚‰2000å¹´ä»£åˆé ã«ã‹ã‘ã¦ã€

Yuhto 2009/04/22

Oracle
Sun

ãƒªãƒ³ã‚¯

ã‚ªãƒ©ã‚¯ãƒ«ã€ã‚µãƒ³è²·åŽã«åˆæ„--ç¾åœ°é›»è©±ä¼šè°é€Ÿå ±

Sun Microsystemsã®è²·åŽã‚’æ±ºã‚ãŸã®ã¯ã€IBMã§ã¯ãªãOracleã ã£ãŸã€‚ Oracleã¨Sunã®ä¸¡ç¤¾ã¯ç±³å›½æ™‚é–“4æœˆ20æ—¥ã€OracleãŒSunã®æ™®é€šæ ªã‚’1æ ªã‚ãŸã‚Š9.50ãƒ‰ãƒ«ã®ç¾é‡‘ã§è²·åŽã™ã‚‹ã“ã¨ã«ã¤ã„ã¦æœ€çµ‚åˆæ„ã—ãŸã¨æ˜Žã‚‰ã‹ã«ã—ãŸã€‚è²·åŽç·é¡ã¯74å„„ãƒ‰ãƒ«ï¼ˆSunã®ä¿æœ‰ç¾é‡‘ã‚„è² å‚µã‚’è€ƒæ…®ã—ãŸå ´åˆã®å®Ÿè³ªçš„ãªè²·åŽé¡ã¯56å„„ãƒ‰ãƒ«ï¼‰ã€‚ Oracleã®ç¤¾é•·Safra Catzæ°ã¯å£°æ˜Žã§æ¬¡ã®ã‚ˆã†ã«è¿°ã¹ã¦ã„ã‚‹ã€‚ ã“ã®è²·åŽã«ã‚ˆã‚Šã€æœ€åˆã®é€šæœŸä¼šè¨ˆå¹´åº¦ã«éžGAAPãƒ™ãƒ¼ã‚¹ã§åˆ©ç›ŠãŒå°‘ãªãã¨ã‚‚1æ ªã‚ãŸã‚Š15ã‚»ãƒ³ãƒˆå¢—ãˆã‚‹ã‚‚ã®ã¨æœŸå¾…ã—ã¦ã„ã‚‹ã€‚ã‚ã‚Œã‚ã‚Œã®æŽ¨è¨ˆã«ã‚ˆã‚‹ã¨ã€è²·åŽã—ãŸäº‹æ¥ã¯æœ€åˆã®1å¹´ã§15å„„ãƒ‰ãƒ«ã€2å¹´ç›®ã§20å„„ãƒ‰ãƒ«ã®å–¶æ¥åˆ©ç›Šã‚’Oracleã«ã‚‚ãŸã‚‰ã™ã“ã¨ã«ãªã‚‹ã€‚ Sunã¯ãƒ‰ãƒƒãƒˆã‚³ãƒ ãƒãƒ–ãƒ«ã®æ™‚ä»£ã«ã‚µãƒ¼ãƒç”¨ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã®ä¾›çµ¦æ¥è€…ã¨ã—ã¦æœ‰åã«ãªã£ãŸãŒã€åŒç¤¾ã‚’ã•ã‚‰ã«æœ‰åã«ã—ãŸæŠ€è¡“ã¯ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–¢é€£ã®ã‚‚ã®--ãƒ—ãƒã‚°ãƒ©ãƒŸ

Yuhto 2009/04/22

ãƒªãƒ³ã‚¯

SYS_CONTEXTã€USERENV - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracle SQL é–¢æ•°ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹

ãƒãƒ¼ãƒ ã‚¹ãƒšãƒ¼ã‚¹ äº‹å‰å®šç¾©ã•ã‚Œã¦ã„ã‚‹çµ„è¾¼ã¿ãƒãƒ¼ãƒ ã‚¹ãƒšãƒ¼ã‚¹å USERENV ï¼ˆé–¢æ•°åã§ã¯ãªã„ï¼‰ ã¾ãŸã¯ã€ã€Œãƒ¦ãƒ¼ã‚¶ãƒ¼å®šç¾©ã®ã‚³ãƒ³ãƒ†ã‚ã‚¹ãƒˆãƒ»ãƒãƒ¼ãƒ ã‚¹ãƒšãƒ¼ã‚¹ã€ ãƒãƒ¼ãƒ ã‚¹ãƒšãƒ¼ã‚¹ã®ã‚³ãƒ³ãƒ†ã‚ã‚¹ãƒˆå USERENV ãƒãƒ¼ãƒ ã‚¹ãƒšãƒ¼ã‚¹ã®ã‚³ãƒ³ãƒ†ã‚ã‚¹ãƒˆå ã€ã¾ãŸã¯ã€ã€Œãƒ¦ãƒ¼ã‚¶ãƒ¼å®šç¾©ã®ã‚³ãƒ³ãƒ†ã‚ã‚¹ãƒˆãƒ»ãƒãƒ¼ãƒ ã‚¹ãƒšãƒ¼ã‚¹ã€ã®ã‚³ãƒ³ãƒ†ã‚ã‚¹ãƒˆå SYS_CONTEXT é–¢æ•°ã®å†…å®¹ çµ„ã¿è¾¼ã¿ã•ã‚ŒãŸ USERENV ãƒãƒ¼ãƒ ã‚¹ãƒšãƒ¼ã‚¹ã€ã¾ãŸã¯ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼å®šç¾©ã® namespace ã«é–¢é€£ä»˜ã‘ã‚‰ã‚ŒãŸ ã‚³ãƒ³ãƒ†ã‚ã‚¹ãƒˆå param ã®å€¤ã‚’ VARCHAR2 åž‹ã§æˆ»ã™ã€‚ æˆ»ã™æ–‡å—åˆ—ã®é•·ã•ãŒ max_len ã‚’è¶…ãˆã‚‹å ´åˆã«ã¯åˆ‡ã‚Šæ¨ã¦ã‚‰ã‚Œã‚‹ã€‚ ç¾è¡Œã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼æƒ…å ±ã‚’ã‚‚ã¤ USERENV ã¨ã„ã†çµ„è¾¼ã¿ãƒãƒ¼ãƒ ã‚¹ãƒšãƒ¼ã‚¹ãŒç”¨æ„ã•ã‚Œã¦ã„ã‚‹ã€‚ç›®çš„ã«å¿œã˜ãŸã‚³ãƒ³ãƒ†ã‚ã‚¹ãƒˆã‚’è‡ªå‰ã§ä½œæˆã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã€‚ USETENV é–¢æ•°ã®å†…å®¹ ä¸‹ä½äº’æ›ç”¨ã ãŒ SYS_CONTE

Yuhto 2008/03/10

IPã‚¢ãƒ‰ãƒ¬ã‚¹å–å¾—

Oracle
Tips

ãƒªãƒ³ã‚¯

Works - ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã‚ã‚Œã“ã‚Œ

ãƒ¯ãƒ¼ã‚¯ã‚¹INDEXã¸ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã‚ã‚Œã“ã‚Œ [Â æŽ¥ç¶šæ–‡å—åˆ—ä¸€è¦§Â ]Â Â [Â VBScriptÂ ]Â Â [Â JavaScriptÂ ]Â Â [Â VC++Â ]Â Â [Â JavaÂ ]Â Â Last Updated. 12-Nov-2006 â– ã¯ã˜ã‚ã« ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã™ã‚‹ã‚µãƒ³ãƒ—ãƒ«ã‚½ãƒ¼ã‚¹é›†ã§ã™ã€‚ ä¾‹ã¨ã—ã¦æŒ™ã’ã¦ã„ã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã€WSHï¼ˆWindows Script Hostï¼‰ã€VC++ã€Java ã§ã™ã€‚ ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã¯ODBCã¨ã€oo4oï¼ˆOracle Objects for OLEï¼‰ã‚’ä¸å¿ƒã«æ›¸ã„ã¦ã„ã¾ã™ã€‚ â– æŽ¥ç¶šæ–‡å—åˆ—ä¸€è¦§Â 2006/11/12Â Â NEWÂ ! OLE DBãƒ—ãƒãƒã‚¤ãƒ€ã€ODBCãƒ‰ãƒ©ã‚¤ãƒã®æŽ¥ç¶šè¨˜è¿°åã®æ›¸ãæ–¹ã€‚ å¯¾è±¡ã¯ã€ORACLEã€MS SQL Serverã€PostgreSQLã€MySQLã€ Accessã€Excelã€CSVã€Outlook

Yuhto 2008/03/05

ãƒªãƒ³ã‚¯

Oracleãƒ»Tipsé›†

â—è¡¨ã®ä¸€è¦§ SQL# select * from tab; â—è¡¨ã®é …ç›®ä¸€è¦§ SQL# desc è¡¨å;ï¼ˆ;ã¯çœç•¥å¯ï¼‰ â—ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä¸€è¦§ SQL# select * from user_ind_columns; â€»æŒ‡å®šã—ãŸè¡¨ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ã¿ã€è¡¨ç¤ºã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ SQL# select column_name from user_ind_columns where table_name = 'è¡¨å'; â—ãƒ¦ãƒ¼ã‚¶ä¸€è¦§ SQL# select username from user_users; â—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ SQL# select * from NLS_DATABASE_PARAMETERS where PARAMETER = 'NLS_NCHAR_CHARACTERSET'; è¡¨ã®ã‚³ãƒ”ãƒ¼æ–¹æ³• create tableã‚³ãƒžãƒ³ãƒ‰ã§è¡¨ã®ã‚³ãƒ”ãƒ¼ãŒã§ãã¾ã™ã€‚ ãŸã ã—ã€åˆ¶ç´„æ¡ä»¶ã¯ã€

Yuhto 2008/03/05

ãƒªãƒ³ã‚¯

DBMS_OUTPUT ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracleã‚’ãƒžã‚¹ã‚¿ãƒ¼ã™ã‚‹ãŸã‚ã®åŸºæœ¬ã¨ä»•çµ„ã¿

DBMS_OUTPUT ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®ä½¿ç”¨ PL/SQL ã«ãŠã„ã¦ DBMS_OUTPUT ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã¯ãƒ‡ãƒãƒƒã‚°ç›®çš„ãªã©ã§æ¨™æº–å‡ºåŠ›ã«ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚’è¡¨ç¤ºã™ã‚‹ãŸã‚ã®ãŠãã‚‰ãå”¯ä¸€ã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã§é–‹ç™ºä½œæ¥ä¸ã«ã¯åˆ©ç”¨çŽ‡ãƒŠãƒ³ãƒãƒ¼ãƒ¯ãƒ³ã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã§ã‚ã‚‹ã€‚ãã®å¤šãã¯é–‹ç™ºãƒ•ã‚§ãƒ¼ã‚ºãŒçµ‚äº†ã™ã‚‹ã¨å‘¼ã³å‡ºã—ã®ã‚ªãƒ¼ãƒãƒ˜ãƒƒãƒ‰ã‚’ãªãã™ç‚ºã«ã‚³ãƒ¡ãƒ³ãƒˆåŒ–ã•ã‚Œã‚‹ã‹ç„¡åŠ¹åŒ–ã•ã‚Œã‚‹ã€‚ ä½¿ç”¨æ–¹æ³•ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ç°¡å˜ã§ã‚ã‚‹ã€‚ BEGIN FOR i in 1..7 LOOP FOR j IN 1..9 LOOP DBMS_OUTPUT.PUT('-'); END LOOP; DBMS_OUTPUT.PUT('+'); END LOOP; DBMS_OUTPUT.NEW_LINE; DBMS_OUTPUT.PUT_LINE('12345678901234567890'); END; / å®Ÿè¡Œçµæžœ ---------+---------+------

Yuhto 2008/02/19

[PL/SQL]ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã®ã™ã¹ã¦ã‚’ã‚ªãƒ©ã‚¯ãƒ«ã®ãƒ¡ãƒ¢ãƒªãƒãƒƒãƒ•ã‚¡ã«ä¸€æ™‚æ ¼ç´ã—ã¦ãŠããŸã‚ã€ç”¨é€”æ¬¡ç¬¬ã§ã¯ã€ã™ãã«ãƒãƒƒãƒ•ã‚¡ã‚µã‚¤ã‚ºã‚’è¶…éŽã—ã¦ ORA-20000: ORU-10027: buffer overflow, limit of 20000 bytes ã¨ã‚¨ãƒ©ãƒ¼ã¨ãªã‚‹

ãƒªãƒ³ã‚¯

Oracleã®åˆ©ç”¨

Oracleã®åˆ©ç”¨ Updated 1998/02/01 By PCDN ç¦å²¡å¯¿å’Œ Oracleç”¨ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã‚’é¸ã¶ Oracleã¨æŽ¥ç¶šã™ã‚‹ãŸã‚ã®ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã®å€™è£œã¨ã—ã¦ã¯ Oracle7.x/8.0---SQL*Net V2.x---ODBC---VB Oracle7.x/8.0---SQL*NET V2.x---ODBC---RDO---VB Oracle7.x/8.0---SQL*NET V2.x---ODBC---DAO---VB Oracle7.x/8.0---SQL*NET V2.x---OracleObjectForOLE---VB Oracle8.0--------Oracle NET8---ODBC---VB Oracle8.0--------Oracle NET8---ODBC---RDO---VB Oracle8.0--------Oracle NET8---ODBC

Yuhto 2008/02/14

ãƒªãƒ³ã‚¯

ã€ã‚³ãƒ©ãƒ ã€‘Yet Another ä»•äº‹ã®ãƒ„ãƒ¼ãƒ« (87) Oracle XE - HTML DBã§ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã¤ãã‚‹ | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«

Oracle XEã«ä»˜å±žã™ã‚‹HTML DBã®ã€ŒApplication Builderã€ã‚’ä½¿ã†ã¨ã€ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®çŸ¥è˜ãŒãªãã¦ã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨é€£æºã™ã‚‹Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ç°¡å˜ã«é–‹ç™ºã§ãã‚‹â€¦â€¦ã‚‰ã—ã„ã€‚ä»Šå›žã¯å®Ÿéš›ã«ã©ã‚“ãªæ‰‹é †ã§é–‹ç™ºä½œæ¥ã‚’è¡Œã†ã®ã‹ã€ã–ã£ã¨è¦‹ã¦ã¿ã‚‹ã“ã¨ã«ã—ã‚ˆã†ã€‚ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æ–°è¦ã«ä½œæˆã™ã‚‹ã«ã¯ã€ã¾ãšå‰å›žæœ‰åŠ¹ã«ã—ãŸã€ŒHRã€ãƒ¦ãƒ¼ã‚¶ã§HTML DBã«ãƒã‚°ã‚¤ãƒ³ã—ã€ã€ŒApplication Builderã€ã®ç”»é¢ã‹ã‚‰ã€ŒCreate >ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã€‚ç”»é¢ã«ã¯ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ä½œæˆã®3ã¤ã®æ‰‹é †ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã€‚ æ£ã—ãèªè¨¼ã‚’ãƒ‘ã‚¹ã§ãã‚Œã°ã€ä»¥ä¸‹ã®ãƒ¡ãƒ‹ãƒ¥ãƒ¼ç”»é¢ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã€‚ Create Application ãƒ•ãƒ«ã‚¹ã‚¯ãƒ©ãƒƒãƒã§ä¸€ã‹ã‚‰ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œæˆã™ã‚‹ã€‚ Create from Spreadsheet æ—¢å˜ã®Excelãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆã®ãƒ‡ãƒ¼ã‚¿ã‚’ã‚‚ã¨ã«ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œæˆã™ã‚‹ã€‚ D

Yuhto 2007/11/08

ã‚ã¨ã§

DB
Oracle

ãƒªãƒ³ã‚¯

æ¡ä»¶ä»˜ãã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã‚’ä½¿ã£ã¦Oracleã®é‹ç”¨ã‚³ãƒ¼ãƒ‰ã‚’åŠ¹çŽ‡åŒ–ã™ã‚‹ï¼šCodeZine

åŽ»ã‚‹8æœˆ30æ—¥ï¼ˆåœŸæ›œæ—¥ï¼‰ã€ãƒ©ã‚¤ãƒˆã‚¦ã‚§ã‚¤ãƒˆãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžï¼ˆLightweight programming Languageï¼‰ã®ç·åˆã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒLL Futureã€ãŒã€ãªã‹ã®ZEROï¼ˆä¸é‡ŽåŒºã‚‚ã¿ã˜å±±æ–‡åŒ–ã‚»ãƒ³ã‚¿ãƒ¼ï¼‰å¤§ãƒ›ãƒ¼ãƒ«ã§é–‹å‚¬ã•ã‚ŒãŸã€‚å½“æ—¥ã¯å‰ç·šã®å½±éŸ¿ã§æ™‚ãŠã‚Šè±ªé›¨ã«è¦‹èˆžã‚ã‚Œã‚‹ä¸ã€ã•ã¾ã–ã¾ãªè¨€èªžã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚„é–‹ç™ºè€…ãªã©åƒäººè¿‘ããŒé›†ã¾ã£ãŸã€‚

Yuhto 2006/10/27

ãƒªãƒ³ã‚¯

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºãƒ„ãƒ¼ãƒ« SI Object Browser

SI Object Browserã¯ã€Oracle Databaseã‚’ã¯ã˜ã‚ã¨ã™ã‚‹ä¸»è¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ©Ÿèƒ½ã‚’ã‚ªãƒ¼ãƒ«ã‚¤ãƒ³ãƒ¯ãƒ³ã§ã‚µãƒãƒ¼ãƒˆã—ãŸã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºãƒ„ãƒ¼ãƒ«ã€ã§ã™ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã®é–²è¦§ã€SQLã®ç·¨é›†/å®Ÿè¡Œã‚„å„ç¨®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆä½œæˆã€ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚°ãƒ©ãƒ ã®ãƒ‡ãƒãƒƒã‚°ã€Excelå½¢å¼ã§ã®ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸ã®å‡ºåŠ›ãªã©ã‚’GUIä¸Šã§ç°¡å˜ã«å®Ÿè¡Œã§ãã¾ã™ã€‚ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆæ©Ÿèƒ½ãªã©ã®å„ç¨®DBAæ©Ÿèƒ½ã«ã‚‚å¯¾å¿œã—ã¦ãŠã‚Šã€é–‹ç™ºã‹ã‚‰é‹ç”¨ã¾ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºè€…ã®ç”Ÿç”£æ€§å‘ä¸Šã«è²¢çŒ®ã—ã¾ã™ã€‚

Yuhto 2006/10/18

ãƒªãƒ³ã‚¯

CodeZineï¼šCASEå¼ã®ã‚¹ã‚¹ãƒ¡ï¼ˆå‰ç·¨ï¼‰

ã¯ã˜ã‚ã«ã€€CASEå¼ã¯ã€SQL-92ã§æ¨™æº–ã«å–ã‚Šå…¥ã‚Œã‚‰ã‚Œã¾ã—ãŸã€‚æ¯”è¼ƒçš„æ–°ã—ã„é“å…·ã§ã‚ã‚‹ãŸã‚ã‹ã€ä¾¿åˆ©ãªã‚ã‚Šã«ãã®çœŸä¾¡ãŒã‚ã¾ã‚ŠçŸ¥ã‚‰ã‚Œã¦ãŠã‚‰ãšã€åˆ©ç”¨ã•ã‚Œã¦ã„ãªã‹ã£ãŸã‚Šã€CASEå¼ã®ç°¡ç•¥ç‰ˆã§ã‚ã‚‹DECODEï¼ˆOracleï¼‰ã€IFï¼ˆMySQLï¼‰ãªã©ã®é–¢æ•°ã§ä»£ç”¨ã•ã‚Œã¦ã„ãŸã‚Šã—ã¾ã™ã€‚ã€€ã—ã‹ã—ã€ã‚¸ãƒ§ãƒ¼ãƒ»ã‚»ãƒ«ã‚³ãŒã€Žãƒ—ãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®SQL ç¬¬2ç‰ˆã€ã®ä¸ã§ã€SQL-92ã§è¿½åŠ ã•ã‚ŒãŸä¸ã§æœ€ã‚‚æœ‰ç”¨ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ ã€€ã¨è¨€ã†ã‚ˆã†ã«ï¼ˆæ³¨1ï¼‰ã€CASEå¼ã‚’æ´»ç”¨ã™ã‚‹ã¨SQLã§ã§ãã‚‹ã“ã¨ã®å¹…ãŒãã£ã¨åºƒãŒã‚Šã€æ›¸ãæ–¹ã‚‚ã‚¹ãƒžãƒ¼ãƒˆã«ãªã‚Šã¾ã™ã€‚ã—ã‹ã‚‚ã€å®Ÿè£…éžä¾å˜ã®æŠ€è¡“ãªã®ã§ã‚³ãƒ¼ãƒ‰ã®æ±Žç”¨æ€§ã‚‚é«˜ã¾ã‚Šã¾ã™ã€‚ç‰¹ã«DECODEé–¢æ•°ã‚’ä½¿ã£ã¦ã„ã‚‹Oracleãƒ¦ãƒ¼ã‚¶ãƒ¼ã«ã¯ã€ãœã²CASEå¼ã¸ã®ä¹—ã‚Šæ›ãˆã‚’ãŠè–¦ã‚ã—ã¾ã™ã€‚ã€€ã“ã®ãƒ†ã‚ã‚¹ãƒˆã¯ã€ãã‚“ãªã„ã„ã“ã¨ã„ã£ã±ã„ã®CASEå¼ã®ä¾¿åˆ©ãªä½¿ã„æ–¹ã‚’ç´¹ä»‹ã™ã‚‹ã‚‚ã®ã§ã™ã€‚ ã“ã®è¨€è‘‰ã¯ã€ã€Žãƒ—ãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®SQL ç¬¬2ç‰ˆã€ï¼ˆ

Yuhto 2006/10/05

CHECKåˆ¶ç´„ã¨ã®çµ„ã¿åˆã‚ã›ã‚‚ã§ãã‚‹

ãƒªãƒ³ã‚¯

Oracleã€ã€ŒBerkeley DBã€ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³4.5ã‚’ãƒªãƒªãƒ¼ã‚¹ | OSDN Magazine

ç±³Oracleã¯9æœˆ27æ—¥ã€çµ„ã¿è¾¼ã¿ç”¨ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒBerkeley DBã€ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³4.5ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ãŸã€‚ä»Šå¹´2æœˆã®Sleepycat Softwareè²·åŽã«ã‚ˆã£ã¦ç²å¾—ã—ãŸè£½å“ã®æœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚Šã€å‰ãƒãƒ¼ã‚¸ãƒ§ãƒ³4.4ã‹ã‚‰ç´„1å¹´ã¶ã‚Šã®ãƒªãƒªãƒ¼ã‚¹ã¨ãªã‚‹ã€‚ Oracleã®çµ„ã¿è¾¼ã¿ã‚·ã‚¹ãƒ†ãƒ æ‹…å½“ãƒã‚¤ã‚¹ãƒ—ãƒ¬ã‚¸ãƒ‡ãƒ³ãƒˆï¼ˆå…ƒSleepycat Softwareã®ãƒžãƒ¼ã‚±ãƒ†ã‚£ãƒ³ã‚°æ‹…å½“ãƒã‚¤ã‚¹ãƒ—ãƒ¬ã‚¸ãƒ‡ãƒ³ãƒˆï¼‰ã®ãƒ¬ãƒƒã‚¯ã‚¹ãƒ»ãƒ¯ãƒ³ã‚°æ°ã«ã‚ˆã‚‹ã¨ã€Berkeley DB 4.5ã«ã¯æ¬¡ã®ã‚ˆã†ãªæ–°æ©Ÿèƒ½ãŒå«ã¾ã‚Œã¦ã„ã‚‹ã¨ã„ã†ã€‚ å¤šæ•°ã®åŒæ™‚ã‚¢ã‚¯ã‚»ã‚¹ãŒå¤šã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚·ã‚¹ãƒ†ãƒ ã®ãŸã‚ã®ã€Œãƒžãƒ«ãƒãƒãƒ¼ã‚¸ãƒ§ãƒ³ãƒ»ã‚³ãƒ³ã‚«ãƒ¬ãƒ³ã‚·ãƒ¼ãƒ»ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ã€æ©Ÿèƒ½ é‹ç”¨ä¸ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åœæ¢ã•ã›ãšã«ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å…ˆã®Berkeley DBç’°å¢ƒã‚’ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã—ãŸã‚Šã€ãƒ‘ãƒƒãƒã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã‚Šã§ãã‚‹æ©Ÿèƒ½ é«˜å¯ç”¨æ€§ã‚·ã‚¹ãƒ†ãƒ ã®é…å‚™ã‚’å®¹æ˜“ã«ã™ã‚‹ã€æ§‹

Yuhto 2006/10/01

ãƒªãƒ³ã‚¯

Oracleã€Berkeley DB 4.5ã‚’ãƒªãƒªãƒ¼ã‚¹ | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«

ç±³Oracleã¯27æ—¥(ç¾åœ°æ™‚é–“)ã€Oracle Berkeley DB Release 4.5ã‚’ç™ºè¡¨ã—ãŸã€‚ãƒ—ãƒãƒ—ãƒ©ã‚¤ã‚¨ã‚¿ãƒªã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¸ã®çµ„ã¿è¾¼ã¿å‘ã‘ã®å•†ç”¨ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¨ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¸ã®çµ„ã¿è¾¼ã¿å‘ã‘ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã®ãƒ‡ãƒ¥ã‚¢ãƒ«ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã§æä¾›ã•ã‚Œã‚‹ã€‚æ—¢ã«ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰æä¾›ãŒé–‹å§‹ã•ã‚Œã¦ã„ã‚‹ã€‚ Berkeley DBã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¸ã®çµ„ã¿è¾¼ã¿ã‚’ä¸»ãªç”¨é€”ã¨ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€‚Unixç³»OSã§ã¯æ¨™æº–çš„ã«æè¼‰ã•ã‚Œã‚‹ãªã©ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§ã®åˆ©ç”¨ã‚‚ç››ã‚“ã€‚Oracleã¯2æœˆã«Sleepycat Softwareã‚’è²·åŽã€ã“ã‚Œã«ä¼´ã„Berkeley DBã‚‚OracleãŒé–‹ç™ºãƒ»æä¾›ã‚’è¡Œã£ã¦ã„ã‚‹ã€‚Oracleã®è£½å“ãƒ©ã‚¤ãƒ³ãƒŠãƒƒãƒ—ã®ãªã‹ã§ã¯SQLã‚’åˆ©ç”¨ã—ãªã„è»½é‡ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ä½ç½®ã¥ã‘ã‚‰ã‚Œã‚‹ã€‚ Release 4.5ã§ã¯ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨å¯ç”¨æ€§ã®å‘ä¸ŠãŒå›³ã‚‰ã‚Œã¦ã„ã‚‹ã€‚è¤‡æ•°ãƒ¦ãƒ¼ã‚¶ãŒãƒ‡ãƒ¼ã‚¿ã‚’èªã¿ãƒ»

Yuhto 2006/10/01

ãƒªãƒ³ã‚¯

å‚æœ¬å¤šèžã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢æ¥ç•Œã‚¤ãƒ³ã‚µã‚¤ãƒ‰ã‚¢ã‚¦ãƒˆ GoogleãŒOracleã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é ˜åŸŸã§è¡çªã™ã‚‹æ—¥ï¼šBigtable vs Berkeley DB

CNET Japanèªè€…ãƒ–ãƒã‚¬ãƒ¼ sparklegateã•ã‚“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼RDBMSã¯æœ¬å½“ã«ä¾¿åˆ©ãªã®ã‹ã¯å•é¡Œæèµ·ã¨ã—ã¦ãã—ã¦ã€ã„ã‚ã„ã‚å¯„ã›ã‚‰ã‚ŒãŸã‚³ãƒ¡ãƒ³ãƒˆãŒéžå¸¸ã«èˆˆå‘³æ·±ãé¢ç™½ã‹ã£ãŸã€‚CPUãƒãƒƒã‚¯ã¨ãƒ‡ã‚£ã‚¹ã‚¯ãƒãƒƒã‚¯ã¨ã„ã†ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ã¤ã„ã¦å¯„ã›ã‚‰ã‚ŒãŸä¸¡æ–¹ã®æ„è¦‹ã¯RDBMSã‚’ã©ã†ä½¿ã£ã¦ã„ã‚‹ã‹ã¨ã„ã†ä½¿ã„æ–¹ã®å·®ã§ã‚‚ã‚ã‚Šã€ã€Œä½•ã§ã‚‚å…¥ã‚‹ä¾¿åˆ©ãªå…¥ã‚Œã‚‚ã®ã€ã§ã‚ã‚‹RDBMSã®ç‰¹é•·ãŒã‚ˆãç¾ã‚Œã¦ã„ã‚‹è¨¼å·¦ã ã‚ã†ã€‚ãã—ã¦ã€ã‚ã¾ã‚Šã«ä¾¿åˆ©ã™ãŽã‚‹ãŒã‚†ãˆã«ã€è‹¦æ‰‹ãªé ˜åŸŸã«ã‚‚ä½¿ã‚ã‚Œã¦ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ï¼ˆæ‹¡å¤§æ€§ï¼‰ã®å•é¡Œã«ã¶ã¤ã‹ã‚Šã€ã€Œæœ¬å½“ã«ä¾¿åˆ©ãªã®ã‹ã€ã¨ã„ã†ç´ æœ´ãªå˜†ãã«è‡³ã‚‹ã¨ã„ã†çŠ¶æ³ã¯ã€çš®è‚‰ãªã®ã‹æœ¬æ°—ãªã®ã‹ã€ã„ãšã‚Œã«ã—ã‚ã‚ã‚ŠãŒã¡ãªã“ã¨ã ã‚ã†ã€‚ ã²ã£ãã‚Šã¨è¡¨ã«å‡ºã¦ããŸGoogleã‚’æ”¯ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼šBigtable ãã‚“ãªãŠã‚Šã€steps to phantasienã®2006-9-11ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§Googleã®ã‚¤ãƒ³ãƒ•ãƒ©ã‚’æ”¯ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼

Yuhto 2006/10/01

ãƒªãƒ³ã‚¯

ã‚ªãƒ©ã‚¯ãƒ«ã€SaaSæœ¬æ ¼å‚å…¥ã€ä¸å …ä¼æ¥ã«ç…§æº– - ã¾ãšã¯Siebelã‹ã‚‰ | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«

æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã¨æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã‚¤ãƒ³ãƒ•ã‚©ãƒ¡ãƒ¼ã‚·ãƒ§ãƒ³ã‚·ã‚¹ãƒ†ãƒ ã‚ºã¯ã€ä»Šå¾Œã®CRM(Customer Relationship Management:é¡§å®¢ç®¡ç†)ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³äº‹æ¥ã«ãŠã‘ã‚‹åŸºæœ¬æˆ¦ç•¥ã‚’ç™ºè¡¨ã€ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‚’ä»‹ã—ã¦ã€ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚’ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦æä¾›ã™ã‚‹SaaS(Software as a Service)ã‚’å›½å†…ã§ã‚‚å±•é–‹ã™ã‚‹ã¨ã¨ã‚‚ã«ã€å„ç¨®æ¥ç•Œã®çŠ¶æ³ã«å¿œã˜ãŸè£½å“ãƒ»ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æŠ•å…¥ã™ã‚‹ã“ã¨ã«ã‚ã‚ã›ã€å–¶æ¥ä½“åˆ¶ã®çµ„ç¹”ã‚’æ”¹ç·¨ã€è¦å“¡ã‚‚å¢—ã‚„ã™ãªã©å¼·åŒ–ã™ã‚‹ã€‚ ä¼æ¥è²·åŽã«ã‚ˆã‚Šã€å¾“æ¥ä¸»åŠ›ã¨ã—ã¦ããŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä»¥å¤–ã«ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã®è£½å“ä½“ç³»ã‚’æ•´å‚™ã—ãŸåŒç¤¾ã¯ã€å¤§ä¼æ¥ã‹ã‚‰ä¸å …ãƒ»ä¸å°ã¾ã§ã®ä¼æ¥ã«å‘ã‘ã€çµ±åˆçš„ãªã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ææ¡ˆã—ã¦ã„ãæ–½ç–ã«ã•ã‚‰ã«æ³¨åŠ›ã™ã‚‹ã€‚ æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã‚¤ãƒ³ãƒ•ã‚©ãƒ¡ãƒ¼ã‚·ãƒ§ãƒ³ã‚·ã‚¹ãƒ†ãƒ ã‚ºã®æ‘ä¸Šæ™ºä»£è¡¨å–ç· å½¹(å·¦)ã¨ã€åŒç¤¾ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³äº‹æ¥çµ±æ‹¬ ãƒ•ãƒãƒ³ãƒˆã‚ªãƒ•ã‚£ã‚¹ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³å–¶æ¥çµ±æ‹¬æœ¬éƒ¨

Yuhto 2006/10/01

ãƒªãƒ³ã‚¯

æ ªå¼ä¼šç¤¾ã‚¢ã‚·ã‚¹ãƒˆã¯9æœˆ28æ—¥ã€ã€ŒOracle Databaseã€ã®ç¨¼åƒçŠ¶æ³ã‚’è‡ªå‹•çš„ã«è¨ºæ–ã—ãƒ¬ãƒãƒ¼ãƒˆã‚’å‡ºåŠ›ã™ã‚‹ä¼šå“¡åˆ¶æœ‰å„Ÿãƒãƒ¼ã‚¿ãƒ«ãƒ»ã‚µã‚¤ãƒˆã€Œãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ã‚»ãƒ©ãƒ”ãƒ¼ã€ã®é–‹è¨ã‚’ç™ºè¡¨ã—ãŸã€‚1å¹´å¥‘ç´„ã®æœ‰å„Ÿã‚µãƒ¼ãƒ“ã‚¹ã ãŒã€ä¼šå“¡ç™»éŒ²å¾Œ30æ—¥ä»¥å†…ã¯ç„¡å„Ÿã§åˆ©ç”¨ã§ãã‚‹ã€‚ ä»Šå›žã€é–‹è¨ã—ãŸã‚µã‚¤ãƒˆã¯ã€Oracleæ¨™æº–ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹åˆ†æžãƒ„ãƒ¼ãƒ«ã§ã‚ã‚‹ã€ŒStatspackãƒ¬ãƒãƒ¼ãƒˆã€ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹çµ±è¨ˆæƒ…å ±ã‹ã‚‰ã€è¨ºæ–é …ç›®å€¤æŽ¨ç§»ã®ã‚°ãƒ©ãƒ•åŒ–ã‚„ã€é›†ç©æƒ…å ±ã‹ã‚‰è¨ºæ–é …ç›®ã®æ¯”è¼ƒæƒ…å ±ã‚’æä¾›ã™ã‚‹ã‚‚ã®ã€‚å®šæœŸçš„ã«å–å¾—ã—ãŸè¨ºæ–é …ç›®å€¤ã®æŽ¨ç§»ã‚’è¦–è¦šçš„ã«ç¢ºèªã—ãŸã‚Šã€Oracleåˆå¿ƒè€…ãŒçŠ¶æ³æŠŠæ¡ã—ã«ãã„ãƒ†ã‚ã‚¹ãƒˆå½¢å¼ã§æä¾›ã•ã‚Œã‚‹ã€å„ç¨®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹é–¢é€£æƒ…å ±ãŒæ‰‹è»½ã«åˆ©ç”¨ã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã€‚ åˆ©ç”¨æ–¹æ³•ã¨ã—ã¦ã¯ã€åŒã‚µã‚¤ãƒˆä¸Šã§ä¼šå“¡ç™»éŒ²ã‚’è¡Œã„ã€ã€ŒStatspackãƒ¬ãƒãƒ¼ãƒˆã€ã‚’ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã™ã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç¨¼åƒçŠ¶æ³ã«é–¢ã™ã‚‹ãƒ¬ãƒãƒ¼ãƒˆã‚’å‚ç…§ã§ãã‚‹ã€‚ã¾ãŸåˆ©ç”¨è€…ã®ç™»éŒ²

Yuhto 2006/09/30

æœ‰å„Ÿã‹ãƒ»ãƒ»

ãƒªãƒ³ã‚¯

Oracle Japan

2025å¹´2æœˆ13æ—¥ã«æ±äº¬ã§é–‹å‚¬ã•ã‚Œã‚‹ã€ã‚ªãƒ©ã‚¯ãƒ«ã®ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ãŠã‚ˆã³ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚ãƒ³ã‚°ã‚¤ãƒ™ãƒ³ãƒˆã€ŒCloudWorld Tourã€ã«ãœã²ã”å‚åŠ ãã ã•ã„ã€‚ã‚ªãƒ©ã‚¯ãƒ«ã®ã‚¨ã‚°ã‚¼ã‚¯ãƒ†ã‚£ãƒ–ã‚„å°‚é–€å®¶ã€ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼ã€åŒæ¥ä»–ç¤¾ã¨äº¤æµã—ã€ã‚¯ãƒ©ã‚¦ãƒ‰ã‚„AIãªã©ã«ã¤ã„ã¦æ„è¦‹ã‚’äº¤ã‚ã—ã¾ã—ã‚‡ã†ã€‚

Yuhto 2006/09/12

DB
Oracle

ãƒªãƒ³ã‚¯

OTN Japanã‚µã‚¤ãƒˆä¸Šã§æŽ²è¼‰ã—ã¦ã„ã‚‹ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¨ãƒ©ãƒ¼ãƒ»ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã€ã®å†…å®¹ã‚’ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã§æ¤œç´¢ã§ãã¾ã™ã€‚æ³¨æ„äº‹é …ã«ã¤ã„ã¦ã¯ã€å„ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‚’ã”å‚ç…§ãã ã•ã„ã€‚ ãƒ»Oracle9i ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€€ã‚¨ãƒ©ãƒ¼ãƒ»ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸æ¤œç´¢ ã€ŒOracle9i ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¨ãƒ©ãƒ¼ãƒ»ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ ãƒªãƒªãƒ¼ã‚¹2(9.2)ã€ ãƒ»Oracle10g ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€€ã‚¨ãƒ©ãƒ¼ãƒ»ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸æ¤œç´¢ ã€ŒOracle Databaseã‚¨ãƒ©ãƒ¼ãƒ»ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸10g ãƒªãƒªãƒ¼ã‚¹2ï¼ˆ10.2ï¼‰ã€ ãƒ»Oracle11g ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€€ã‚¨ãƒ©ãƒ¼ãƒ»ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸æ¤œç´¢ ã€ŒOracle Database ã‚¨ãƒ©ãƒ¼ãƒ»ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸11g ãƒªãƒªãƒ¼ã‚¹1ï¼ˆ11.1ï¼‰ã€

Yuhto 2006/09/03

Oracle
DB

ãƒªãƒ³ã‚¯

2003å¹´7æœˆ11æ—¥ã«è¡Œã£ãŸåŒæ§˜ã®ã‚¿ã‚¤ãƒˆãƒ«ã®iSeminarãŒæ¯”è¼ƒçš„å¥½è©•ã ã£ãŸã“ã¨ã‹ã‚‰ã€éš”æœˆã§å…¨3å›žäºˆå®šã®iSeminarã®å†…å®¹ã‚’ã€å¹³è¡Œã—ã¦OTNã§ã¯æ¯Žæœˆå…¨6å›žã®å½¢ã§é€£è¼‰ã—ã¾ã™ã€‚ ç§ã¯æ™®æ®µã¯OracleDirectã«ã”ç›¸è«‡ã„ãŸã ã„ãŸãŠå®¢æ§˜ã®ã”å•†è«‡æˆç´„ã®ãŸã‚ã®æŠ€è¡“çš„ãªæ”¯æ´ã‚’æ‹…å½“ã—ã¦ãŠã‚Šã¾ã™ã€‚Oracleè£½å“ã®è³¼å…¥ã‚’ã”æ¤œè¨Žã•ã‚Œã‚‹éš›ã¯ã€æ˜¯éžOracleDirectã«ã”ç›¸è«‡ãã ã•ã„ã€‚ ãƒ–ãƒãƒƒã‚¯ã‚µã‚¤ã‚ºã‚’æ±ºã‚ã‚‹åŸºæœ¬çš„ãªæŒ‡é‡ ãƒ–ãƒãƒƒã‚¯ã‚µã‚¤ã‚ºã¯CREATE DATABASEã‚³ãƒžãƒ³ãƒ‰å®Ÿè¡Œæ™‚ã«åˆæœŸåŒ–ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿DB_BLOCK_SIZEã«è¨å®šã—ã¾ã™ã€‚åŸºæœ¬çš„ã«ã¯2,048ãƒ»4,096ãƒ»8,192ãƒ»16,384ãƒ»32,768ãƒã‚¤ãƒˆã®ã„ãšã‚Œã‹ã‹ã‚‰é¸æŠžã™ã‚‹ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ãŸã ã—32,768ãƒã‚¤ãƒˆã¯64bitç³»ã®ä¸€éƒ¨ã®OSç‰ˆã®Oracleã®ã¿ã§æŒ‡å®šã§ãã¾ã™ã€‚ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯OSã«ã‚‚ã‚ˆã‚Šã¾ã™ãŒã»ã¨ã‚“ã©ã®å ´åˆ2,048byteã§

Yuhto 2006/06/07

DB
Oracle

ãƒªãƒ³ã‚¯

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (20)

Oracleã«é–¢ã™ã‚‹Yuhtoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (20)

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬2é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (20)

Oracleã«é–¢ã™ã‚‹Yuhtoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (20)

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬2é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (20)

Oracleã«é–¢ã™ã‚‹Yuhtoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (20)

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬2é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹