[B! oracle] legnumã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

legnum id:legnum

oracleã«é–¢ã™ã‚‹legnumã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (38)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Oracle Databaseã‚’æ‰±ã†ä¸Šã§çŸ¥ã£ã¦ãŠããŸã„å¤‰æ•°10é¸
æœ¬è¨˜äº‹ã¯ JPOUG Advent Calendar 2013 ã®ï¼‘ï¼˜æ—¥ç›®ã§ã™ã€‚ï¼‘ï¼—æ—¥ç›®ã¯ mutatsu ã•ã‚“ã® å‚™å¿˜éŒ²ã¨ã‹ã€€12cã®PL/SQLæ–°æ©Ÿèƒ½ï¼šæš—é»™çš„çµæžœã‚»ãƒƒãƒˆ(dbms_sql.return_result) ã§ã—ãŸã€‚ ã“ã“ã§ã¯ Oracle Database ã‚’æ‰±ã†ä¸Šã§è¨å®šã—ã¦ãŠãã¨ä¾¿åˆ©ã ã¨æ€ã†å¤‰æ•°ã‚’ 10 å€‹ã»ã©ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ 1. SQLPATH ç’°å¢ƒå¤‰æ•° - SQL*Plus ã¾ãšã¯ DBA 1.0 ã®ç›¸æ£’ SQL*Plus ã‚’ä½¿ã†ä¸Šã§æ¬ ã‹ã›ãªã„ SQLPATH ç’°å¢ƒå¤‰æ•°ã€‚ SQL*Plus ã®ç’°å¢ƒå¤‰æ•° - SQL*Plusã®æ§‹æˆ - SQL*Plusãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚ºãƒ»ã‚¬ã‚¤ãƒ‰ãŠã‚ˆã³ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ ãƒªãƒªãƒ¼ã‚¹12.1 B71396-01 sqlplus ã‹ã‚‰å®Ÿè¡Œã™ã‚‹ SQL ã‚¹ã‚¯ãƒªãƒ—ãƒˆã®å ´æ‰€ã‚’æŒ‡å®šã™ã‚‹å€¤ã§ã™ã€‚ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã«ã‚ˆã‚‹ã¨æ¬¡ã®é †ç•ªã§ SQL ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’æ¤œç´¢ã™ã‚‹ã¨ã‚ã‚Šã¾
legnum 2014/01/10
db

oracle

knowledge
ãƒªãƒ³ã‚¯
ã‚³ãƒ¼ã‚½ãƒ«Databaseã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®Blog
ã‚³ãƒ¼ã‚½ãƒ« Database ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®Blog ã¸ã‚ˆã†ã“ã ã‚³ãƒ¼ã‚½ãƒ« Database ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®Blogã§ã¯ã€ ã‚³ãƒ¼ã‚½ãƒ«æ‰€å±žã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒOracle Databaseã‚’ä¸å¿ƒã¨ã—ãŸDatabaseã«é–¢ã‚ã‚‹æŠ€è¡“æƒ…å ±ã‚’ç™ºä¿¡ã—ã¦ã„ã¾ã™ã€‚ ã‚³ãƒ¼ã‚½ãƒ«ã§ã¯ã€Oracle Databaseã‚’ã¯ã˜ã‚ã¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å…¨èˆ¬ã«é–¢ã‚ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ï¼ˆã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ã€è¨è¨ˆã€æ§‹ç¯‰ãªã©ï¼‰ã€ã‚ªãƒ©ã‚¯ãƒ«è£½å“ã®ãƒ—ãƒãƒ€ã‚¯ãƒˆã‚µãƒãƒ¼ãƒˆã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã—ã¦ã„ã¾ã™ã€‚ ã¾ãŸã€ä¸å®šæœŸã§ç„¡å„Ÿã®æŠ€è¡“ã‚»ãƒŸãƒŠãƒ¼ã‚’é–‹å‚¬ã—ã¦ã„ã¾ã™ã€‚ æ ªå¼ä¼šç¤¾ã‚³ãƒ¼ã‚½ãƒ« - ã‚µãƒ¼ãƒ“ã‚¹æ¡ˆå†… æ ªå¼ä¼šç¤¾ã‚³ãƒ¼ã‚½ãƒ« - ã‚»ãƒŸãƒŠãƒ¼æƒ…å ± ã‚³ãƒ¼ã‚½ãƒ«ã§ã¯ã€Oracle Databaseã‚¹ãƒšã‚·ãƒ£ãƒªã‚¹ãƒˆã«ãªã‚ŠãŸã„ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã€ Oracle Database æŠ€è¡“ã‚’æ´»ã‹ã—ã¦åƒããŸã„ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚’çµ¶è³›å‹Ÿé›†ä¸ã§ã™ã€‚ ã‚³ãƒ¼ã‚½ãƒ«ã«ã¤ã„ã¦çŸ¥ã‚‹ãŸã‚ã«ã¯ãƒ»ãƒ»ãƒ» æ ªå¼ä¼šç¤¾ã‚³ãƒ¼ã‚½ãƒ« - ä¼šç¤¾æƒ…å ± äººäº‹ãƒ–ãƒã‚° - ã€Žã‚³ãƒ¼
legnum 2013/12/03
sql

oracle

mysql

db

programming
ãƒªãƒ³ã‚¯
ã€Œã‚°ãƒ¼ã‚°ãƒ«ã¯é‚ªæ‚ªã€ã€ã‚ªãƒ©ã‚¯ãƒ«ï¼£ï¼¥ï¼¯ãŒç‰¹è¨±è¨´è¨Ÿã‚ãã‚Šéžé›£
ï¼˜æœˆï¼‘ï¼“æ—¥ã€ç±³ã‚ªãƒ©ã‚¯ãƒ«ã®ãƒ©ãƒªãƒ¼ãƒ»ã‚¨ãƒªã‚½ãƒ³ï¼£ï¼¥ï¼¯ãŒãƒ†ãƒ¬ãƒ“ç•ªçµ„ã§ã€åŒç¤¾ã®ç‰¹è¨±ã‚’ã‚ãã‚Šè£åˆ¤ã§äº‰ã†ç±³ã‚°ãƒ¼ã‚°ãƒ«å´ã®å¯¾å¿œã«ã¤ã„ã¦ã€Œçµ¶å¯¾çš„ã«é‚ªæ‚ªã ã€ã¨åŽ³ã—ãæ‰¹åˆ¤ã—ãŸã€‚å†™çœŸã¯ï¼“æœˆæ’®å½±ï¼ˆï¼’ï¼ï¼‘ï¼“å¹´ã€€ãƒã‚¤ã‚¿ãƒ¼/Stephen Lamï¼‰ ï¼»ï¼‘ï¼“æ—¥ã€€ãƒã‚¤ã‚¿ãƒ¼ï¼½ - ç±³ã‚ªãƒ©ã‚¯ãƒ«ã®ãƒ©ãƒªãƒ¼ãƒ»ã‚¨ãƒªã‚½ãƒ³æœ€é«˜çµŒå–¶è²¬ä»»è€…ï¼ˆï¼£ï¼¥ï¼¯ï¼‰ãŒï¼‘ï¼“æ—¥æ”¾æ˜ ã•ã‚ŒãŸãƒ†ãƒ¬ãƒ“ç•ªçµ„ã§ã€åŒç¤¾ã®ç‰¹è¨±ã‚’ã‚ãã‚Šè£åˆ¤ã§äº‰ã†ç±³ã‚°ãƒ¼ã‚°ãƒ«å´ã®å¯¾å¿œã«ã¤ã„ã¦ã€Œçµ¶å¯¾çš„ã«é‚ªæ‚ªã ã€ã¨åŽ³ã—ãæ‰¹åˆ¤ã—ãŸã€‚ ã‚°ãƒ¼ã‚°ãƒ«ã¯ã€ŒDon't Be Evilï¼ˆé‚ªæ‚ªã«ãªã‚‰ãªã„ï¼‰ã€ã‚’ãƒ¢ãƒƒãƒˆãƒ¼ã®ï¼‘ã¤ã¨ã—ã¦ã„ã‚‹ãŒã€ã‚¨ãƒªã‚½ãƒ³ï¼£ï¼¥ï¼¯ã®ç™ºè¨€ã¯ã“ã‚Œã‚’çš®è‚‰ã£ãŸã‚‚ã®ã€‚åŒï¼£ï¼¥ï¼¯ã¯ã€ãƒ©ã‚¤ãƒãƒ«ä¼æ¥ã®å¹¹éƒ¨ã«å¯¾ã™ã‚‹è¾›è¾£ãªç™ºè¨€ã§çŸ¥ã‚‰ã‚Œã¦ã„ã‚‹ã€‚
legnum 2013/08/15
ã‚¿ã‚¤ãƒˆãƒ«ã§ã‚ªãƒã¦ã‚‹

oracle

db

copyright

law

judge

google
ãƒªãƒ³ã‚¯
Oracleã¨å¯Œå£«é€šã®å”æ¥é–¢ä¿‚ã«ç•°å¤‰ï¼Ÿ
UNIXã‚µãƒ¼ãƒåˆ†é‡Žã«ãŠã„ã¦ç·Šå¯†ãªå”æ¥ã‚’è¡Œã£ã¦ããŸOracleã¨å¯Œå£«é€šã®é–¢ä¿‚ãŒã€ã“ã“ã«ãã¦æ–°ãŸãªæ®µéšŽã‚’è¿Žãˆã¦ã„ã‚‹ã‚ˆã†ã ã€‚ã•ã‚‰ãªã‚‹ç™ºå±•ã¸ã¨å‘ã‹ã†ã®ã‹ã€ãã‚Œã¨ã‚‚â€¦â€¦ã€‚ Oracleã®æ–°è£½å“ç™ºè¡¨ã«æ²ˆé»™ã—ç¶šã‘ã‚‹å¯Œå£«é€š ã€Œæœ¬æ—¥ã€ä¸–ç•Œæœ€é€Ÿã®SPARCãƒ—ãƒã‚»ãƒƒã‚µã‚’æè¼‰ã—ãŸUNIXã‚µãƒ¼ãƒè£½å“ç¾¤ã‚’æ—¥æœ¬ã§æŠ«éœ²ã™ã‚‹ã“ã¨ãŒã§ãã€ãŸã„ã¸ã‚“å¬‰ã—ãæ€ã£ã¦ã„ã‚‹ã€ ç±³Oracleã§æ—¥æœ¬ã¨ã‚¢ã‚¸ã‚¢å¤ªå¹³æ´‹åœ°åŸŸã®ã‚·ã‚¹ãƒ†ãƒ å–¶æ¥ã‚’æ‹…å½“ã™ã‚‹ã‚¨ã‚¤ãƒ‰ãƒªã‚¢ãƒ³ãƒ»ã‚¸ãƒ§ãƒ¼ãƒ³ã‚º ã‚·ãƒ‹ã‚¢ãƒã‚¤ã‚¹ãƒ—ãƒ¬ã‚¸ãƒ‡ãƒ³ãƒˆã¯4æœˆ16æ—¥ã€æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ãŒé–‹ã„ãŸæ–°è£½å“ç™ºè¡¨ä¼šã§ã“ã†åˆ‡ã‚Šå‡ºã—ãŸã€‚ æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ãŒã“ã®æ—¥ç™ºè¡¨ã—ãŸã®ã¯ã€UNIX OSã€ŒOracle Solarisã€ãŒç¨¼åƒã™ã‚‹ã€ŒSPARCã€ãƒ—ãƒã‚»ãƒƒã‚µæè¼‰ã‚µãƒ¼ãƒè£½å“ç¾¤ã®æ–°ãƒ¢ãƒ‡ãƒ«ã§ã€ãƒŸãƒƒãƒ‰ãƒ¬ãƒ³ã‚¸å‘ã‘ã®ã€ŒSPARC T5ã€ã‚µãƒ¼ãƒ4æ©Ÿç¨®ã€ãŠã‚ˆã³ãƒã‚¤ã‚¨ãƒ³ãƒ‰å‘ã‘ã®ã€ŒSPARC M5ã€ã‚µãƒ¼ãƒ1æ©Ÿç¨®ã€‚ç±³å›½ã§ã¯3æœˆ26æ—¥ã«ç™ºè¡¨ã•ã‚ŒãŸã‚‚ã®ã ã€‚
legnum 2013/04/23
server

db

oracle

biz

cooperation
ãƒªãƒ³ã‚¯
æœæ—¥æ–°èžãƒ‡ã‚¸ã‚¿ãƒ«ï¼šã‚ªãƒ©ã‚¯ãƒ«ã€æ—¥æœ¬ã«ï¼¤ï¼£é–‹è¨âˆ’é¡§å®¢ç®¡ç†ã‚¯ãƒ©ã‚¦ãƒ‰æä¾› - ãƒ‡ã‚¸ã‚¿ãƒ«
æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã¯ä»Šå¹´æ˜¥ã‚’ã‚ã©ã«å›½å†…ã«ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ï¼ˆï¼¤ï¼£ï¼‰ã‚’é–‹è¨ã™ã‚‹ã€‚å”åŠ›ä¼šç¤¾ã®ï¼¤ï¼£å†…ã«ã‚¯ãƒ©ã‚¦ãƒ‰åŸºç›¤ã‚’æ§‹ç¯‰ã€‚ã‚³ãƒ¼ãƒ«ã‚»ãƒ³ã‚¿ãƒ¼ï¼ˆé¡§å®¢å¯¾å¿œçª“å£ï¼‰ã‚„ãƒ˜ãƒ«ãƒ—ãƒ‡ã‚¹ã‚¯æ¥å‹™ã‚’æ”¯ãˆã‚‹çµ±åˆã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ã‚’æœˆæ¬¡ã§ã‚µãƒ¼ãƒ“ã‚¹æä¾›ã™ã‚‹ã€‚åŒäº‹æ¥ã§ã¯é¡§å®¢æƒ…å ±ç®¡ç†ï¼ˆï¼£ï¼²ï¼ï¼‰ã§å®Ÿç¸¾ã‚’æŒã¤ãŒã€ã“ã‚Œã¾ã§ã¯ç±³ã‚ªãƒ©ã‚¯ãƒ«ãŒé‹å–¶ã™ã‚‹æµ·å¤–ï¼¤ï¼£ã‚’ã‚µãƒ¼ãƒ“ã‚¹æ‹ ç‚¹ã¨ã—ã¦ã„ãŸã€‚æ—¥æœ¬ç‹¬è‡ªã«ã‚µãƒ¼ãƒ“ã‚¹æ‹ ç‚¹ã‚’æŒã¤ã®ã¯åˆã‚ã¦ã€‚ ã€€ï¼³ï½ï½ï¼³ï¼ˆã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢æ©Ÿèƒ½ã®ã‚µãƒ¼ãƒ“ã‚¹æä¾›ï¼‰åž‹ã§æä¾›ã™ã‚‹ã®ã¯ã€Œãƒ©ã‚¤ãƒˆãƒŠã‚¦ï¼£ï¼¸ã‚¯ãƒ©ã‚¦ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã€ã€‚ç±³ã‚ªãƒ©ã‚¯ãƒ«ãŒè²·åŽã—ãŸç±³ãƒ©ã‚¤ãƒˆãƒŠã‚¦ãƒ»ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã‚ºãŒä¸»åŠ›ã¨ã—ã¦ã„ãŸå£²ã‚Œç‹ã®è£½å“ã€‚é¡§å®¢ã‹ã‚‰ã®å•ã„åˆã‚ã›ã‚’ä¸€å…ƒç®¡ç†ã—ã€ã‚³ãƒ¼ãƒ«ã‚»ãƒ³ã‚¿ãƒ¼ã‚„ãƒ˜ãƒ«ãƒ—ãƒ‡ã‚¹ã‚¯æ”¯æ´ã‚„å‚åŠ äº¤æµåž‹ã®ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒ¡ãƒ‡ã‚£ã‚¢ã¨é€£å‹•ã—ãŸé¡§å®¢ã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã™ã‚‹ã€‚ ã€€ã‚³ãƒ¼ãƒ«ã‚»ãƒ³ã‚¿ãƒ¼ã‚„é›»åå•†å–å¼•ï¼ˆï¼¥ï¼£ï¼‰ã‚µã‚¤ãƒˆå‘ã‘ã«ã™ã§ã«ãƒ©ã‚¤ãƒˆãƒŠã‚¦ï¼£ï¼¸ã‚’è²©å£²ã—ã¦ã„ã‚‹ãŒã€å¸‚å ´ã®ã™ãé‡Žã‚’åºƒã’ã‚‹ãŸã‚ã€ï¼³ï½ï½ï¼³å¯¾å¿œã«è¸ã¿åˆ‡ã‚‹
legnum 2013/01/18
oracle

db

cloud

biz
ãƒªãƒ³ã‚¯
Javaã«æ–°ãŸãªè„†å¼±æ€§ã€ã™ã§ã«ã‚¼ãƒãƒ‡ã‚¤æ”»æ’ƒãŒç™ºç”Ÿ
ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ç ”ç©¶è€…ã‚‰ã¯ã€åºƒãæ™®åŠã—ã¦ã„ã‚‹Javaã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã«æ–°ãŸãªè„†å¼±æ€§ã‚’ç™ºè¦‹ã—ãŸã€‚æ‚ªç”¨ã•ã‚Œã‚Œã°ã€æ”»æ’ƒè€…ã«ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚’è¨±ã—ã¦ã—ã¾ã†ãŠãã‚ŒãŒã‚ã‚‹ã€‚ ç±³ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ç·Šæ€¥äº‹æ…‹å¯¾ç–ãƒãƒ¼ãƒ ï¼ˆUS-CERTï¼‰ã¯ç±³å›½æ™‚é–“1æœˆ10æ—¥ã«è¦å‘Šã‚’ç™ºã—ã€ã€ŒJava 7 Update 10ã€ãŠã‚ˆã³ãã‚Œä»¥å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã«ã‚ã‚‹ç¨®ã®è„†å¼±æ€§ãŒå«ã¾ã‚Œã¦ãŠã‚Šã€æ‚ªç”¨ã•ã‚Œã‚Œã°èªè¨¼ã•ã‚Œã¦ã„ãªã„ãƒªãƒ¢ãƒ¼ãƒˆæ”»æ’ƒè€…ã«ä»»æ„ã®ã‚³ãƒ¼ãƒ‰ã‚’å®Ÿè¡Œã•ã‚Œã¦ã—ã¾ã†ãŠãã‚ŒãŒã‚ã‚‹ã¨è¿°ã¹ãŸã€‚ã“ã®æ”»æ’ƒã¯ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ›ãƒ¼ãƒ«ã‚’åˆ©ç”¨ã™ã‚‹æ‚ªæ„ã®ã‚ã‚‹ã‚³ãƒ¼ãƒ‰ãŒä»•çµ„ã¾ã‚ŒãŸã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã‚’ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒè¨ªå•ã—ãŸå ´åˆã«è¡Œã‚ã‚Œã‚‹å¯èƒ½æ€§ãŒã‚ã‚‹ã€‚ ã“ã®è„†å¼±æ€§ã¯ã™ã§ã«ã€Œå®Ÿéš›ã«ã€æ”»æ’ƒã‚’å—ã‘ã¦ãŠã‚Šï¼ˆã¤ã¾ã‚Šç¾å®Ÿä¸–ç•Œã®è„…å¨ãªã®ã ï¼‰ã€æ‚ªæ„ã®ã‚ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒç°¡å˜ã«æ”»æ’ƒã‚’å®Ÿè¡Œã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ãŸã‚ã®ã‚¨ã‚¯ã‚¹ãƒ—ãƒã‚¤ãƒˆã‚ãƒƒãƒˆã«çµ„ã¿è¾¼ã¾ã‚Œã¦ã„ã‚‹ã€‚ Javaã‚’é–‹ç™ºã™ã‚‹Oracleã¯ã¾ã è„†å¼±æ€§ã¸
legnum 2013/01/11
java

security

oracle
ãƒªãƒ³ã‚¯
Oracleã§Twitterã®ã‚¿ã‚¤ãƒ ãƒ©ã‚¤ãƒ³ã‚’SELECTã™ã‚‹ - ser1zw's blog
FDWã£ã¦ãªã«ã‚ˆï¼Ÿ FDW(Foreign Data Wrappe),å¤–éƒ¨ãƒ‡ãƒ¼ã‚¿ãƒ©ãƒƒãƒ‘ã£ã¦ã„ã†ã‚„ã¤ã§ã€SQL/MED(Management of External Data)ã®è¦æ ¼ã®ä¸€ã¤ã§ç°¡å˜ã«ã„ã†ã¨ã€PostgreSQLã«QUERYã‚’ç™ºè¡Œã—ãŸã‚‰ã€ã‚ã‚‰ä¸æ€è°ã€å¤–éƒ¨ã®(ãŸã¨ãˆã°MySQLã¨ã‹CSV)ãƒ‡ãƒ¼ã‚¿ãŒå–å¾—ã§ãã‚‹ã¨ã„ã†å¤‰æ…‹æ©Ÿèƒ½ã€‚ twitter APIã«å¤‰æ›´ã‚ã‚‹ã‚‰ã—ã„ã‹ã‚‰ä»Šå¾Œã¯ã‚ã‹ã‚‰ã«ã‘ã©ã€twitterã®ãƒ‡ãƒ¼ã‚¿ã‚’å–ã£ã¦ãã‚‹ã¨ã‹ã‚‚ã§ãã‚‹ã€‚ã¨ã„ã†ã‹ãƒ©ãƒƒãƒ‘ãƒ¼ãŒç”¨æ„ã•ã‚Œã¦ã‚‹ã€‚(ã¡ãªã¿ã«ä½¿ã£ã¦ã¿ãŸã‚‰æ¥½ã—ã‹ã£ãŸï½—) PostgreSQLã«èˆˆå‘³ãŒã‚ã‚‹äººå‘ã‘ã«ã¾ã¨ã‚ã¦ã¿ãŸã€‚ï½œPostgreSQLï½œãŠä»•äº‹ãƒ¡ãƒ¢ï½œPictnotes ãã‚Œã¯ãƒ¯ã‚¯ãƒ†ã‚«éŽãŽã‚‹... ã ãŒã—ã‹ã— SQLite3 ã§ã‚‚å‡ºæ¥ã‚‹ï¼ãã£ã¨å‡ºæ¥ã‚‹ï¼ Big Sky :: SQLite ã§ twitter ã®ã‚¿ã‚¤ãƒ ãƒ©ã‚¤ãƒ³ã‚’ select ã™ã‚‹ã€‚
legnum 2013/01/08
twitter

oracle

db

programming

neta
ãƒªãƒ³ã‚¯
é‡è¦æ€§ã‚’å¢—ã™ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã€ã‚¯ãƒ©ã‚¦ãƒ‰ã®ã€Œãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ã‚·ãƒ¼ã€
ã‚¯ãƒ©ã‚¦ãƒ‰ã‚’ä½Žä¾¡æ ¼ã§æä¾›ã™ã‚‹ãŸã‚ã«ã¯ã€1ã¤ã®ã‚µãƒ¼ãƒã«ã„ã‹ã«å¤šãã®é¡§å®¢ã‚’è©°ã‚è¾¼ã‚ã‚‹ã‹ã¨ã„ã†ã€Œå¯†åº¦ã€ãŒé‡è¦ã«ãªã‚Šã¾ã™ã€‚å¯†åº¦ãŒé«˜ã‘ã‚Œã°é«˜ã„ã»ã©å®‰ã„å˜ä¾¡ã§é¡§å®¢ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã§ãã‚‹ã‹ã‚‰ã§ã™ã€‚ ITã‚¸ãƒ£ãƒ¼ãƒŠãƒªã‚¹ãƒˆï¼Publickeyãƒ–ãƒã‚¬ãƒ¼ã€‚å¤§å¦ã§UNIXã‚’å¦ã³ã€æ ªå¼ä¼šç¤¾ã‚¢ã‚¹ã‚ãƒ¼ã«å…¥ç¤¾ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ã‚¯ãƒ‹ã‚«ãƒ«ã‚µãƒãƒ¼ãƒˆã€æœˆåˆŠã‚¢ã‚¹ã‚ãƒ¼NTç·¨é›†éƒ¨ å‰¯ç·¨é›†é•·ãªã©ã‚’çµŒã¦1998å¹´é€€ç¤¾ã€ãƒ•ãƒªãƒ¼ãƒ©ãƒ³ã‚¹ãƒ©ã‚¤ã‚¿ãƒ¼ã«ã€‚2000å¹´ã€æ ªå¼ä¼šç¤¾ã‚¢ãƒƒãƒˆãƒžãƒ¼ã‚¯ãƒ»ã‚¢ã‚¤ãƒ†ã‚£è¨ç«‹ã«å‚ç”»ã€ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒ¡ãƒ‡ã‚£ã‚¢éƒ¨é–€ã®å½¹å“¡ã¨ã—ã¦2007å¹´ã«IPOã‚’å®Ÿç¾ã€2008å¹´ã«é€€ç¤¾ã€‚å†ã³ãƒ•ãƒªãƒ¼ãƒ©ãƒ³ã‚¹ã¨ã—ã¦ç‹¬ç«‹ã—ã€2009å¹´ã«ãƒ–ãƒã‚°ãƒ¡ãƒ‡ã‚£ã‚¢Publickeyã‚’é–‹å§‹ã€‚ç¾åœ¨ã«è‡³ã‚‹ã€‚ ã€Œãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ã‚·ãƒ¼ã€ã‚’å®Ÿç¾ã™ã‚‹Oracle Database 12c å…ˆé€±ã‚µãƒ³ãƒ•ãƒ©ãƒ³ã‚·ã‚¹ã‚³ã§é–‹å‚¬ã•ã‚ŒãŸOracle OpenWorld 2012ã§ç™ºè¡¨ã•ã‚ŒãŸã‚ªãƒ©ã‚¯ãƒ«ã®æ¬¡æœŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼
legnum 2012/10/17
oracle

storage

management
ãƒªãƒ³ã‚¯
Rails ã§ã€Controller ã«å®šç¾©ã•ã‚Œã¦ã„ã‚‹ action ã‚’ä¸€åº¦ã«å–å¾—ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ - QA@IT
å¹³ç´ ã‚ˆã‚ŠQAï¼ ITã‚’ã”åˆ©ç”¨ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ QAï¼ ITã¯ã€Œè³ªå•ã‚„å›žç”ã‚’ã€Žå…±æœ‰ã€ã—ã€Žç·¨é›†ã€ã—ã¦ã„ãã“ã¨ã§ãƒ™ã‚¹ãƒˆãªQAã‚’è“„ç©ã§ãã‚‹ã€IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å•é¡Œè§£æ±ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶šã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€QAï¼ ITã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªè³ªå•ã‚„å›žç”ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”æ”¯æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æƒ…å ±å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„QAã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’æ¤œè¨Žã—ãŸçµæžœã€2020å¹´2æœˆ28æ—¥ï¼ˆé‡‘ï¼‰15:00ã‚’ã‚‚ã¡ã¾ã—ã¦QAï¼ ITã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰ã›ã¨ãªã‚Šã€èª ã«å¿ƒè‹¦ã—ãæ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ä½•ã¨ãžã€ã”ç†è§£ã‚’ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ QAï¼ ITã®7å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
legnum 2012/09/13
db

sql

oracle

mysql

pstgresql
ãƒªãƒ³ã‚¯
ã€ŒCVE-2012-4681:Oracle Java7 ä»»æ„ã®OSã‚³ãƒžãƒ³ãƒ‰ãŒå®Ÿè¡Œå¯èƒ½ãªè„†å¼±æ€§ã€ã®æ”»æ’ƒæ‰‹æ³•è§£èª¬ - ( ê’ªâŒ“ê’ª) ã‚†ã‚‹ã‚ˆã‚æ—¥è¨˜
Ocacle Java7ã§ä»»æ„ã®OSã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œå¯èƒ½ãªè„†å¼±æ€§ãŒã‚ã‚‹ã€ã¨è©±é¡Œã«ãªã‚Šã¾ã—ãŸã€‚ JVNTA12-240A: Oracle Java 7 ã«è„†å¼±æ€§ æœ¬æ—¥ãƒ‘ãƒƒãƒãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ Oracleã€Javaã®æ·±åˆ»ãªè„†å¼±æ€§ã‚’å…¬è¡¨â€•æ”»æ’ƒè€…ã¯ãƒªãƒ¢ãƒ¼ãƒˆã§ã‚ã‚‰ã‚†ã‚‹æ“ä½œãŒå¯èƒ½ã€”ä»Šæœãƒ‘ãƒƒãƒç·Šæ€¥ãƒªãƒªãƒ¼ã‚¹ã€• Alert for CVE-2012-4681 PoCã‚³ãƒ¼ãƒ‰ã‚‚å…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ã“ã®è„†å¼±æ€§ã‚’çªãæ”»æ’ƒã¯ã©ã®ã‚ˆã†ãªã‚‚ã®ã‹èˆˆå‘³ãŒã‚ã£ãŸã®ã§ã€èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚ èª¿æŸ»çµæžœã¯ã€ä»Šé€±ã«è¡Œã‚ã‚ŒãŸ8æœˆ29æ—¥ JJUG Night Seminar ~ Java VM&LT&ç´æ¶¼ä¼š ~(æ±äº¬éƒ½) ã§è©±ã—ã¦ããŸã®ã§ã™ãŒã€ãƒ‘ãƒƒãƒã‚‚å‡ºãŸã“ã¨ã ã—ãƒ–ãƒã‚°ã«ã‚‚æ›¸ã„ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ Javaã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ¢ãƒ‡ãƒ«ã«ã¤ã„ã¦ Javaã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã¯ã€ã‚µãƒ³ãƒ‰ãƒœãƒƒã‚¯ã‚¹ãƒ¢ãƒ‡ãƒ«ã«ã‚ˆã£ã¦ç¢ºä¿ã•ã‚Œã¦ã„ã¾ã™ã€‚ã‚µãƒ³ãƒ‰ãƒœãƒƒã‚¯ã‚¹ã¯ã€JVMä¸Šã§å®Ÿè¡Œã•
legnum 2012/09/03
java

security

crackdown

programming

neta

oracle
ãƒªãƒ³ã‚¯
ã‚ªãƒ©ã‚¯ãƒ«ä¸€ç‹23å¹´ã€ãƒã‚§ãƒ†ã‚£ãƒ³ãƒ»ã‚ªã‚ºãƒ–ãƒˆãƒ³ã•ã‚“ã«è¨Šãã€ä¸–ç•Œä¸€ã‚ã‹ã‚Šã‚„ã™ã„ã€Œãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ã¨ã‚ªãƒ©ã‚¯ãƒ«ã€ã®è©±
ãã†ã§ã™ãã€‚å¤§å’ã§ã™ãå…¥ç¤¾ã—ã¦ã€ãã‚Œã‹ã‚‰ãšã£ã¨ã‚ªãƒ©ã‚¯ãƒ«ã«ã„ã¾ã™ã€‚ä»Šå¹´ã§23å¹´ç›®ã§ã™ãã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒãƒ¼ãƒ ã®é–‹ç™ºè€…ã¨ã—ã¦ç§ã®ã‚ãƒ£ãƒªã‚¢ã¯å§‹ã¾ã‚Šã¾ã—ãŸã€‚åˆã‚ã¦ã‹ã‹ã‚ã£ãŸãƒªãƒªãƒ¼ã‚¹ã¯Oracle 6.0ã€‚å½“æ™‚ã¯ã¾ã å°ã•ã„ä¼šç¤¾ã§ã—ãŸãã€‚æœ€åˆã®12å¹´é–“ã¯å€‹åˆ¥ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºã‚’ã—ã¦ã„ã¾ã—ãŸã€‚ãã®å¾Œã¯ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ã¨ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ã®ãƒãƒ¼ãƒ ã‚’çŽ‡ã„ã¦ã„ã¾ã™ã€‚ â€•ãã‚Œã§ã¯ã€ä»Šæ—¥ã¯ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ã«ã¤ã„ã¦ãŠèžãã‹ã›ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ã¾ãšã¯ãƒ‡ãƒ¼ã‚¿ã®ã€Œãƒ“ãƒƒã‚°ã€ãªéƒ¨åˆ†ã«ã¤ã„ã¦æ•™ãˆã¦ãã ã•ã„ã€‚ãŸã¨ãˆã°ã€ãƒ†ãƒ©ã€ãƒšã‚¿ã€ã¨ã„ã‚ã‚Œã¦ã‚‚ã€ã©ã‚Œãã‚‰ã„ã®é‡ãªã®ã‹ã€ã©ã‚Œãã‚‰ã„ã®é•ã„ãŒã‚ã‚‹ã®ã‹ã€ã„ã¾ã„ã¡å®Ÿæ„Ÿã¨ã—ã¦ã‚ã‹ã‚‰ãªã„ã®ã§ã™ãŒã€ã©ã‚“ãªé¢¨ã«ã¨ã‚‰ãˆã‚Œã°ã„ã„ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ã¨ã„ã†ã®ã¯ã€å®Ÿã¯ã‚µã‚¤ã‚ºã®è©±ã ã‘ã§ã¯ãªã„ã‚“ã§ã™ã€‚ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ã¨ã„ã†ã‚‚ã®ã‚’å®šç¾©ã™ã‚‹ã«ã‚ãŸã£ã¦ã¯ã€ã€Œå¯†åº¦ã®é«˜ã„ãƒ‡ãƒ¼ã‚¿ã€ã¨ã€Œå¯†åº¦ã®ä½Žã„ãƒ‡ãƒ¼ã‚¿ã€ã¨è€ƒãˆã‚‹ã¨ã„ã„ã§ã—ã‚‡
legnum 2012/04/12
db

oracle

solution

neta
ãƒªãƒ³ã‚¯
é–“é•ã£ã¦10ä¸‡äººã®é¡§å®¢DBæ¶ˆã—ã¡ã¾ã£ãŸï½—ï½—ï½—ï½—ï½—ï½—ï½—ï½— - MC)ã¾ã¨ã‚ã“ã‚€
1ï¼šä»¥ä¸‹ã€VIPãŒãŠé€ã‚Šã—ã¾ã™ï¼š2012/03/05(æœˆ) 23:05:21.43 ID:MYKH/EmU0 ç‰¹å®šã•ã‚Œãªã„ç¯„å›²ã§ 30åˆ†å‰ã®è©± 2ï¼šä»¥ä¸‹ã€VIPãŒãŠé€ã‚Šã—ã¾ã™ï¼š2012/03/05(æœˆ) 23:06:04.91 ID:b77m7UZ00 ï¼’ï½ƒï½ˆã‚„ã£ã¦ãªã„ã§ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯å¾©æ—§æ¥è€…ã«é ¼ã‚ 13ï¼šä»¥ä¸‹ã€VIPãŒãŠé€ã‚Šã—ã¾ã™ï¼š2012/03/05(æœˆ) 23:08:29.71 ID:MYKH/EmU0 >>2 ã¨ã‚Šã‚ãˆãšä»Šæ‹…å½“ã®äººå‘¼ã‚“ã§ã‚‹ï¼ˆä¿ºã‚‚æ‹…å½“ãªã‚“ã ã‘ã©ã•ï½—ï½—ï½— 3ï¼šä»¥ä¸‹ã€VIPãŒãŠé€ã‚Šã—ã¾ã™ï¼š2012/03/05(æœˆ) 23:06:05.57 ID:G+trElAB0 é¡§å®¢DBã£ã¦ä½•ï¼Ÿ 13ï¼šä»¥ä¸‹ã€VIPãŒãŠé€ã‚Šã—ã¾ã™ï¼š2012/03/05(æœˆ) 23:08:29.71 ID:MYKH/EmU0 >>3 é¡§å®¢æƒ…å ±ãŒè©°ã¾ã£ãŸå¤§åˆ‡ãªå¤§åˆ‡ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ 4ï¼š
legnum 2012/03/07
å†å°±è·ã«å½±éŸ¿ã™ã‚‹è©±ã™ã‚‹ã‹ãªãƒ¼ãƒã‚¬ã‚ãƒ£ãƒ³ãã•ã„ã€‚ç¢ºã‹ã«ãƒ—ãƒ©ãƒãƒŠãƒ›ãƒ«ãƒ€ãƒ¼ã£ã¦æ‚ªã„å™‚ã—ã‹èžã‹ãªã„ã‘ã©ã‚‚ã€‚ã‚ã¨ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã›ãšã«truncateã™ã‚‹é‹ç”¨ã‚’ã‚¹ãƒ«ãƒ¼ã—ãŸã¾ã¾åƒã„ã¦ã‚‹æ™‚ç‚¹ã§ãƒ—ãƒ©ãƒãƒŠä»¥å‰ã«DBæ‰±ã†ä»•äº‹å‘ã„ã¦ãªã„

2ch

db

trouble

accident

oracle

neta
ãƒªãƒ³ã‚¯
å•†ç”¨ã‚µã‚¤ãƒˆã§ã‚‚MySQLã®æŽ¡ç”¨ã¯ã‚ã‚Šã¨æ€ã£ã¦ã¾ã—ãŸãŒã€ä¸Šå¸ã«ã‚ˆã‚‹ã¨ã€MySQLã¯æ¤œç´¢ãŒé…ãã¦SQLæ–‡ã«ã‚‚åˆ¶é™ãŒã‚ã‚‹ã‹ã‚‰è‰¯ããªã„... - Y...
ã‚‚ã†ã“ã‚Œã¯æ–‡åŒ–ã®é•ã„ã§ã™ã€‚MySQL ãªã‚“ã¦ã‚ªãƒ¢ãƒãƒ£ã¯ãƒ€ãƒ¡ã¨ã„ã† äººã‚‚ã„ã‚Œã°ã€MySQL ã§ä½•åå„„ãƒ¬ã‚³ãƒ¼ãƒ‰ã§ã‚‚ã„ã‘ã‚‹ã‚ˆ! ã¨ã„ã†äººã‚‚ ã„ã¾ã™ã€‚ ä»¥ä¸‹ã€ãŠã‚‚ã†ã¨ã“ã‚ã‚’ã¤ã‚‰ã¤ã‚‰ã¨æ›¸ã„ã¦ã¿ã¾ã™ã€‚ â—æ©Ÿèƒ½ é•ã„ã¯å¤šã€…ã‚ã‚Šã¾ã™ãŒã€å€‹äººçš„ã«ã¯è¡¨å±¤çš„ãªå•é¡Œã¨æ€ã„ ã¾ã™ã®ã§ã€ã“ã“ã§ã¯è§¦ã‚Œã¾ã›ã‚“ã€‚ â—çµŒé¨“ã®æœ‰ç„¡ ã‚ãŸã—ã¯ Oracleãƒ»MySQL ä½¿ã„ã§ã™ãŒã€DB2 ã¨ã‹ SQLServer ã‚’ä½¿ã£ã¦ã¨è¨€ã‚ã‚Œã‚‹ã¨å°»è¾¼ã¿ã—ã¾ã™ã€‚DB2 ã‚„ SQLServer ãŒ æ‚ªã„ã¨è¨€ã£ã¦ã„ã‚‹ã‚ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã‚ˆãçŸ¥ã‚‰ãªã„ä¸–ç•Œ ã ã‹ã‚‰ã§ã™ã€‚ ä¸Šå¸ã®æ–¹ã‚‚çŸ¥ã‚‰ãªã„ä¸–ç•Œã«é£›ã³è¾¼ã‚€ã®ã¯æ€–ã„ã§ã—ã‚‡ã†ã€‚MySQL ã‚’ æŽ¨ã—ãŸã„ã®ã§ã‚ã‚Œã°ã€ãã®ä¸å®‰ã‚’è§£æ¶ˆã™ã‚‹ãŸã‚ã«ã€ ã€Œã‚ãŸã—ãŒè©³ã—ã„ã®ã§ç¤¾å†…æ•™è‚²ã—ã¾ã™ã‚ˆã€ ã€Œæœ‰å„Ÿã‚µãƒãƒ¼ãƒˆã‚ã‚Šã¾ã™ã‚ˆã€ ã€Œåœ§å€’çš„ã«ã‚³ã‚¹ãƒˆãŒé•ã„ã¾ã™ã‚ˆã€ ã€Œã¾ãšã¯ãƒ—ãƒãƒˆã‚¿ã‚¤ãƒ—é–‹ç™ºã§ MySQL ä½¿ã£ã¦ã¿ã¾ã›ã‚“ã‹?ã€ ãªã©ã€ä¸Š
legnum 2011/12/16
è³ªå•ã®1ç‚¹ã«é™ã‚Œã°ãã‚“ãªäº‹ãªã„ã‚ˆã€ã ã‘ã©ãã‚Œã ã‘ã˜ã‚ƒãªã„ã‹ã‚‰ãŠã‚Œã‚‚ã“ã®è€ƒãˆã ãªã‚ã€‚ã©ã‚Œé¸ã‚“ã§ã‚‚ãƒˆãƒ©ãƒ–ãƒ«ã¯ã‚ã‚‹ã‚ã‘ã§ãã†ãªã£ãŸæ™‚ãªã‚‹ã¹ãã‚ã‚“ã©ãã•ã„ã“ã¨è¨€ã‚ã‚Œãªã„é¸æŠžã‚’ã—ã¦ã¾ã†ã€‚ã‚´ãƒªæŠ¼ã—ã™ã‚‹æ™‚ã¯è…¹ããã‚‹

db

oracle

mysql

sql
ãƒªãƒ³ã‚¯
IBM Developer
IBM Developer is your one-stop location for getting hands-on training and learning in-demand skills on relevant techno logies such as generative AI, data science, AI, and open source.
legnum 2011/11/29
db

mysql

oracle
ãƒªãƒ³ã‚¯
Amazonã€ã‚¯ãƒ©ã‚¦ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã§Oracle Databaseã‚’æä¾›é–‹å§‹ - ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ»ãƒˆã‚¥ãƒ‡ã‚¤(Cloud Today)
ç±³Amazon.comï¼ˆã‚¢ãƒžã‚¾ãƒ³ï¼‰ã®ã‚¯ãƒ©ã‚¦ãƒ‰ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°äº‹æ¥Amazon Web Servicesï¼ˆAWSï¼‰ãŒæä¾›ã™ã‚‹ã‚¯ãƒ©ã‚¦ãƒ‰åž‹ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ“ã‚¹ã€ŒAmazon RDSã€ã§ã€ç±³Oracleï¼ˆã‚ªãƒ©ã‚¯ãƒ«ï¼‰ã®ã€ŒOracle Database 11g Release 2ï¼ˆã‚ªãƒ©ã‚¯ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹11gãƒªãƒªãƒ¼ã‚¹2ï¼‰ã€ãŒé¸æŠžè‚¢ã«åŠ ã‚ã£ãŸã€‚ä¼æ¥ã¯ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã§Oracle Databaseã‚’æ´»ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ Amazon RDSã¯ã€AWSã®ã‚¯ãƒ©ã‚¦ãƒ‰ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ç’°å¢ƒã«ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã—ã€å¿…è¦ãªåˆ†ã ã‘ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆDBï¼‰ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ä½¿ç”¨ã§ãã‚‹ã¨ã„ã†ã‚‚ã®ã€‚ãƒ—ãƒãƒ“ã‚¸ãƒ§ãƒ‹ãƒ³ã‚°ã€ãƒ‘ãƒƒãƒç®¡ç†ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãªã©ã€ä¸€èˆ¬çš„ãªç®¡ç†ã‚¿ã‚¹ã‚¯ã¯è‡ªå‹•çš„ã«å®Ÿè¡Œã•ã‚Œã‚‹ã€‚ã“ã‚Œã¾ã§ã¯ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒMySQLï¼ˆãƒžã‚¤ã‚¨ã‚¹ã‚ãƒ¥ãƒ¼ã‚¨ãƒ«ï¼‰ã€ã®ã¿é‹ç”¨
legnum 2011/06/17
amazon

db

oracle

SaaS
ãƒªãƒ³ã‚¯
ã€Œãƒ¦ãƒ¼ã‚¶ãƒ¼ã«å¯¾ã™ã‚‹æš´æŒ™ã‚’è¨±ã›ãªã„ã€ã€æ—¥æœ¬HPãŒOracleã‹ã‚‰ã®DBç§»è¡Œæˆ¦ç•¥ã‚’ç™ºè¡¨
æ—¥æœ¬ãƒ’ãƒ¥ãƒ¼ãƒ¬ãƒƒãƒˆãƒ»ãƒ‘ãƒƒã‚«ãƒ¼ãƒ‰ï¼ˆæ—¥æœ¬HPï¼‰ã¯2011å¹´4æœˆ26æ—¥ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹æ–°æˆ¦ç•¥ã®ç™ºè¡¨ä¼šã‚’é–‹å‚¬ã—ãŸã€‚æ–°æˆ¦ç•¥ã§ã¯ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ãƒãƒƒã‚¯ãƒªãƒªãƒ¼ã‚¹ã€ã‚’ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã«ã€ç‰¹å®šã®ãƒ™ãƒ³ãƒ€ãƒ¼ã®è£½å“ã«ãƒãƒƒã‚¯ã‚¤ãƒ³ã•ã‚ŒãŒã¡ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç’°å¢ƒã‚’ã€ä»–ã®ãƒ™ãƒ³ãƒ€ãƒ¼è£½å“ä¸Šã«ç§»è¡Œã—ã‚„ã™ãã™ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã™ã‚‹ã€‚ã“ã‚Œã«ã‚ˆã‚Šã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ™ãƒ³ãƒ€ãƒ¼ã«å¯¾ã™ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ä¾¡æ ¼äº¤æ¸‰åŠ›ã‚’é«˜ã‚ã‚‹ã“ã¨ã‚’ç‹™ã„ã¨ã™ã‚‹ã€‚ æ—¥æœ¬HP ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚µãƒ¼ãƒãƒ¼ãƒ»ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ»ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯äº‹æ¥çµ±æ‹¬ã®æ‰åŽŸåšèŒ‚åŸ·è¡Œå½¹å“¡ï¼ˆå†™çœŸ1ï¼‰ã¯ã€æ–°æˆ¦ç•¥ã‚’ç™ºè¡¨ã—ãŸèƒŒæ™¯ã¨ã—ã¦ã€Œãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ã‚³ã‚¹ãƒˆã‚’å‰Šæ¸›ã™ã‚‹ã«ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã«æ”¯æ‰•ã†ãƒ©ã‚¤ã‚»ãƒ³ã‚¹è²»ç”¨ã‚’è¦‹ç›´ã™ã“ã¨ãŒå¿…é ˆã«ãªã£ã¦ã„ã‚‹ã€ã“ã¨ã‚’æŒ‡æ‘˜ã™ã‚‹ã€‚æ—¥æœ¬HPã®è©¦ç®—ã§2005å¹´ã®åŒä¸€æ€§èƒ½ãƒ¢ãƒ‡ãƒ«ã¨ç¾åœ¨ã®ã‚³ã‚¹ãƒˆæ§‹æˆã‚’æ¯”ã¹ã¦ã¿ã‚‹ã¨ã€ãƒãƒ¼ãƒ‰ã‚¦ã‚¨ã‚¢è²»ç”¨ã¯20åˆ†ã®1ä»¥ä¸‹ã«ãªã£ã¦ã„ã‚‹ã®ã«å¯¾ã—ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯30ï¼…å¼·ã»ã©ä¸‹ãŒã£ã¦ã„ã‚‹ã«éŽãŽãªã„
legnum 2011/04/27
æœŸå¾…ã¯ã™ã‚‹ã‘ã©ã‚·ã‚§ã‚¢å¥ªã£ãŸã‚‰ã©ã†ã›åŒã˜äº‹ã™ã‚‹ã‚“ã ã‚ã£ã¦ç–‘å¿ƒãŒå¸¸ã«ã¤ãã¾ã¨ã†

db

oracle

solution

cost
ãƒªãƒ³ã‚¯
ã€ŽOracleã‚ˆã‚Šã‚‚MySQLã®æ–¹ãŒä¾¿åˆ©ã ã¨æ€ã†SQLæ§‹æ–‡æ¯”è¼ƒã€
mysql> select sysdate(); +---------------------+ | sysdate() | +---------------------+ | 2010-08-18 23:11:27 | +---------------------+ 1 row in set (0.00 sec) â– 2. ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ä½œã‚‰ãªãã¦ã„ã„ è¡¨ã®åˆ—ã«auto_incrementå±žæ€§ã‚’ã¤ã‘ã‚‹ã“ã¨ã§ã€insertæ™‚ã«å‹æ‰‹ã«æŽ¡ç•ªã—ã¦ãã‚Œã‚‹ã€‚å˜ã«å›ºæœ‰ã®IDç•ªå·ã‚’æŒ¯ã‚ŠãŸã„æ™‚ã¯ä¾¿åˆ©ã™ãŽã‚‹ã€‚ä½•ã§Oracleã«ã¯ãªã„ã‚“ã ï¼Ÿã£ã¦ãã‚‰ã„ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã”ã¨ã«ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ä½œã£ã¦ç®¡ç†ã™ã‚‹ã®ã£ã¦çµæ§‹ã‚ã‚“ã©ã†ãã•ã„ã€‚ ãŸã ã€æ€§èƒ½é¢ã§è¨€ã†ã¨ã€ä»•çµ„ã¿çš„ã«ç®¡ç†ãƒ†ãƒ¼ãƒ–ãƒ«ã®è¡Œãƒãƒƒã‚¯ã‚’å–ã£ã¦ã—ã¾ã†ã¯ãšãªã®ã§ã€Oracleã®SEQUENCEã«ã¯å…¨ãæ•µã‚ãªã„ã§ã—ã‚‡ã†ã€‚å¾Œã¯ã€è¤‡æ•°ãƒ†ãƒ¼ãƒ–ãƒ«ã«åŒã˜ç•ªå·ã‚’æŒ¯ã‚ŠãŸã„ã¨ãã‚‚å›°ã‚‹ã€‚ â– 3.ä¸€åˆ—
legnum 2011/03/04
å…¨éƒ¨ã‚ã‚‹ã‚ã‚‹ã™ãŽã‚‹ï¼group byã®ç•ªå·æŒ‡å®šã¯ã¾ã‚order byã§ã‚‚ã»ã¨ã‚“ã©ã‚„ã‚‰ãªã„ã‹ã‚‰ã„ã£ã‹ãª

oracle

mysql

sql

programming

comparison
ãƒªãƒ³ã‚¯
Yahoo! çŸ¥æµè¢‹ã®ã‚ªãƒ©ã‚¯ãƒ«ã‚«ãƒ†ã‚´ãƒªãƒ¼ã®ã‚«ãƒ†ã‚´ãƒªãƒžã‚¹ã‚¿ãƒ¼ãŒã™ã”ã„ä»¶ | è£è¡¨(Phinloda ã®ã‚‚ã†è£ã ã‹è¡¨ã ã‹åˆ†ã‹ã‚‰ãªã„ãƒšãƒ¼ã‚¸)
ä¸€å®šæœŸé–“æ›´æ–°ãŒãªã„ãŸã‚åºƒå‘Šã‚’è¡¨ç¤ºã—ã¦ã„ã¾ã™
legnum 2010/11/04
å¹ã„ãŸã€‚ãƒ—ãƒ©ãƒãƒŠä»¥ä¸Šã‚„ï¼ãªã®ã§é•ã†è‰²ã§ã‚ªãƒ©ã‚¯ãƒ«ã‚«ãƒ†ã‚´ãƒªãƒžã‚¹ã‚¿ãƒ¼ãƒ–ãƒ©ãƒƒã‚¯ãƒ›ãƒ¯ã‚¤ãƒˆã¨å‘¼ã¼ã†

db

oracle

knowledge

neta
ãƒªãƒ³ã‚¯
ãƒã‚¤ãƒ‘ãƒ¼ãƒã‚¤ã‚¶ä¸Šã§ç¨¼åƒã™ã‚‹JavaVMã€ã‚µãƒ¼ãƒOSä¸è¦ã®ã€ŒJRockit Virtual Editionã€ã€ã‚ªãƒ©ã‚¯ãƒ«ã‹ã‚‰
ãƒã‚¤ãƒ‘ãƒ¼ãƒã‚¤ã‚¶ä¸Šã§ç¨¼åƒã™ã‚‹JavaVMã€ã‚µãƒ¼ãƒOSä¸è¦ã®ã€ŒJRockit Virtual Editionã€ã€ã‚ªãƒ©ã‚¯ãƒ«ã‹ã‚‰ ç±³ã‚ªãƒ©ã‚¯ãƒ«ãŒ19æ—¥ã«ç™ºè¡¨ã—ãŸã€ŒJRockit Virtual Editionã€ã¯ã€ä»®æƒ³åŒ–ãƒã‚¤ãƒ‘ãƒ¼ãƒã‚¤ã‚¶ã®OracleVMä¸Šã§ç›´æŽ¥å‹•ä½œã™ã‚‹JavaVMã§ã™ã€‚OSãƒ¬ã‚¤ãƒ¤ã‚’çœç•¥ã™ã‚‹ã“ã¨ã«ã‚ˆã£ã¦ã€ãã®ä¸Šã§å‹•ä½œã™ã‚‹WebLogic Serverã®æ€§èƒ½ãŒæœ€å¤§ã§30ï¼…å‘ä¸Šã—ãŸã¨åŒç¤¾ã¯ç™ºè¡¨ã—ã¦ã„ã¾ã™ã€‚ OSä¸è¦ã§JavaVMã‚’ç¨¼åƒ ç±³ã‚ªãƒ©ã‚¯ãƒ«ãŒ19æ—¥ã«ç™ºè¡¨ã—ãŸã€ŒWebLogic Suite Virtualization Optionã€ã¯ã€OracleVMä¸Šã§å‹•ä½œã™ã‚‹JavaVMã®ã€ŒJRockit Virtual Editionã€ã¨ã€Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒã®ã€ŒOracle WebLogic Serverã€ã®2ã¤ã§æ§‹æˆã•ã‚ŒãŸè£½å“ã€‚ åå‰ã®é€šã‚Šä»®æƒ³ç’°å¢ƒã«æœ€é©åŒ–ã•ã‚Œã¦ãŠã‚Šã€ã‚µãƒ¼ãƒä¸Šã«ä»®æƒ³
legnum 2010/04/23
server

OS

virtualization

oracle
ãƒªãƒ³ã‚¯
https://blogs.oracle.com/jsecurityworld/2010/02/2010.html
legnum 2010/02/16
programming

security

cipher

oracle
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸