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

nnn3 id:nnn3

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

${{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ã®Sunè²·åŽã«é–¢ã—æ¬§å·žå§”å“¡ä¼šãŒã•ã‚‰ãªã‚‹èª¿æŸ»ã‚’é–‹å§‹
æ¬§å·žå§”å“¡ä¼šãŒOracleã®Sunè²·åŽã«é–¢ã—ã€90æ—¥é–“ã®èª¿æŸ»ã‚’å®Ÿæ–½ã™ã‚‹ã¨ç™ºè¡¨ã—ãŸã€‚ã€Œã“ã®å¤ã«ã‚‚å®Œäº†ã€ã¨ã—ã¦ã„ãŸåŒè²·åŽã«ã€Œå¾…ã£ãŸã€ãŒã‹ã‹ã£ãŸã“ã¨ã«ãªã‚‹ã€‚ æ¬§å·žé€£åˆï¼ˆEUï¼‰ã®æ¬§å·žå§”å“¡ä¼šã¯9æœˆ3æ—¥ã€ç±³Oracleã«ã‚ˆã‚‹ç±³Sun Microsystemsè²·åŽã«é–¢ã™ã‚‹ã•ã‚‰ã«è©³ç´°ãªèª¿æŸ»ã‚’é–‹å§‹ã™ã‚‹ã“ã¨ã‚’ç™ºè¡¨ã—ãŸã€‚å§”å“¡ä¼šã¯ã“ã‚Œã¾ã§è¡Œã£ãŸèª¿æŸ»ã«ã‚ˆã‚Šã€ã“ã®è²·åŽãŒæ¬§å·žã«ãŠã‘ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å¸‚å ´ã®ç«¶äº‰ã«åŠã¼ã™å½±éŸ¿ã«é‡å¤§ãªæ‡¸å¿µãŒæµ®ä¸Šã—ãŸã¨ã—ã¦ã„ã‚‹ã€‚90æ—¥ã®èª¿æŸ»æœŸé–“ã‚’è¨å®šã—ã€2010å¹´1æœˆ19æ—¥ã«ã“ã®è²·åŽã«å¯¾ã™ã‚‹EUã®æ±ºå®šã‚’ä¸‹ã™ã¨ã„ã†ã€‚ ã“ã‚Œã¾ã§ã®èª¿æŸ»ã®çµæžœã€Oracleã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è£½å“ã¨Sunã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®MySQLã¯ç›´æŽ¥ç«¶åˆã—ã¦ã„ã‚‹ã“ã¨ãŒæ˜Žã‚‰ã‹ã«ãªã£ãŸã¨ã—ã€ä»Šå¾Œã®èª¿æŸ»ã§OracleãŒè²·åŽå¾Œã€MySQLã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦å¼•ãç¶šãé–‹ç™ºã‚’é€²ã‚ã‚‹ã‹ã‚’å«ã‚€å¹¾ã¤ã‹ã®å•é¡Œã‚’è§£æ˜Žã™ã‚‹ã¨ã—ã¦ã„ã‚‹ã€‚
nnn3 2009/09/06
ã‚ã‚‰ã¾ã€‚é£¼ã„æ®ºã—æ‡¸å¿µã—ã¦ã‚“ã ã‚ã†ãªã‚„ã£ã±ã‚Šã€‚

itmedia

oracle
ãƒªãƒ³ã‚¯
Oracleé‹ç”¨ã®åŸºæœ¬ã€Œãƒã‚°ã€ã‚’ç†è§£ã—ã‚ˆã†
ã¨ã„ã†ãƒ•ã‚¡ã‚¤ãƒ«åã§ä½œæˆã•ã‚Œã€åˆæœŸåŒ–ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿background_dump_destã§æŒ‡å®šã•ã‚ŒãŸãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«å‡ºåŠ›ã•ã‚Œã‚‹è¿½è¨˜åž‹ã®ãƒ•ã‚¡ã‚¤ãƒ«ã§ã™ã€‚ ä»¥ä¸‹ãŒã€ã‚¢ãƒ©ãƒ¼ãƒˆãƒ»ãƒã‚°ã«å‡ºåŠ›ã•ã‚Œã‚‹ä¸»ãªå†…å®¹ã§ã™ã€‚ -Oracleã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ -OS ã¨ãã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³æƒ…å ±ï¼ˆæ³¨ï¼‰ -ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã®èµ·å‹•ãƒ»åœæ¢ã€ãã®ãƒ¢ãƒ¼ãƒ‰ -èµ·å‹•æ™‚ã«ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆä»¥å¤–ã®å€¤ãŒè¨å®šã•ã‚ŒãŸå ´åˆã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ -ãƒãƒƒã‚¯ã‚°ãƒ©ã‚¦ãƒ³ãƒ‰ãƒ—ãƒã‚»ã‚¹ã®PID -è¡¨é ˜åŸŸã®è¿½åŠ ãªã©ï¼ˆç‰©ç†æ§‹æˆã®å¤‰æ›´ï¼‰ -ãƒã‚°ã‚¹ã‚¤ãƒƒãƒã®ç™ºç”Ÿ -ã‚¨ãƒ©ãƒ¼ç•ªå·ã¨ãã®ã‚¨ãƒ©ãƒ¼åã€ãŠã‚ˆã³ãã®è©³ç´°ãŒè¨˜éŒ²ã•ã‚Œã¦ã„ã‚‹ãƒˆãƒ¬ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã®å‡ºåŠ›æƒ…å ± æ³¨ï¼‰ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ãŠã‚ˆã³ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã‚ˆã‚ŠOSå´ã®æƒ…å ±ã«ã¤ã„ã¦ã¯å‡ºåŠ›ã•ã‚Œãªã„å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ Thu Jun 12 14:47:07 2008 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 L
nnn3 2008/07/01
ãŒã‚“ã°ã£ã¦ãƒã‚°ã¨ã‹ãƒˆãƒ¬ãƒ¼ã‚¹ã®è¦‹æ–¹è¦šãˆã¦ã‚‚ã€çµå±€ã‚µãƒãƒ¼ãƒˆè¡Œãã«ãªã‚‹ã“ã¨ãŒå¤šã„ã®ãŒé›£ç‚¹

@IT

oracle

db
ãƒªãƒ³ã‚¯
ç„¡æ–™ã§ä½¿ãˆã‚‹ã€ŒOracle Database XEã€ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - builder by ZDNet Japan
1. ç„¡æ–™ã®Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ èªè€…ã®çš†ã•ã‚“ã¯Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ç„¡æ–™ç‰ˆãŒå˜åœ¨ã™ã‚‹ã“ã¨ã‚’ã”å˜çŸ¥ã§ã—ã‚‡ã†ã‹ï¼Ÿæ®‹å¿µãªãŒã‚‰æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã‹ã‚‰æƒ…å ±ãŒå‡ºã¦ãªã„ã®ã§ã€çŸ¥ã‚‰ãªã„æ–¹ã‚‚å¤šã„ã¨æ€ã„ã¾ã™ã€‚ ç„¡æ–™ç‰ˆã®Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯Oracle Database 10g Express Editionï¼ˆä»¥ä¸‹ã€ŒOracle XEã€ï¼‰ã§ã€å¤šå°‘ã®åˆ¶é™ã¯ã‚ã‚Šã¾ã™ãŒä¸èº«ã¯å®Œå…¨ãªOracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ï¼ˆåˆ¶é™ã«ã¤ã„ã¦ã¯å¾Œè¿°ï¼‰ã€‚ é‡‘é¡çš„ã«æ•·å±…ãŒé«˜ã„ã¨æ„Ÿã˜ã¦ã„ãŸæ–¹ã§ã‚ã£ã¦ã‚‚ã€ç„¡æ–™ã§Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç”¨æ„ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚é–‹ç™ºãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã¨ã—ã¦ã ã‘ã§ãªãã€å°è¦æ¨¡ã‚·ã‚¹ãƒ†ãƒ ã§ã‚ã‚Œã°é‹ç”¨ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã¨ã—ã¦ã‚‚ååˆ†ã«ä½¿ãˆã‚‹ã¨æ€ã„ã¾ã™ã€‚ã‚‚ã¡ã‚ã‚“ã€Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å‹‰å¼·ã«ã‚‚æœ‰ç”¨ã§ã—ã‚‡ã†ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†ã—ã€ç°¡å˜ã«æ¤œç´¢ãƒ»æŠ½å‡ºãªã©ã‚’ã™ã‚‹ãŸã‚ã«åˆ©ç”¨ã•ã‚Œã¾ã™ã€‚é€šå¸¸ã¯ãƒ‡ãƒ¼ã‚¿ã®ç®¡ç†ç‰ã«åˆ©ç”¨ã•ã‚Œ
nnn3 2008/06/26
ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã¯1ã¤ã®ã‚·ã‚¹ãƒ†ãƒ ä¸Šã§1ã¤ã ã‘ã§ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è˜åˆ¥ã§ä½¿ã‚ã‚Œã‚‹SIDãŒã€ŒXEã€ã«å›ºå®šã•ã‚Œã¦ã„ã¾ã™ã€‚ã€æ‰‹å‹•ã§CREATE DATABASEæ‰“ã¤ã¨ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ä½œã‚Œã¡ã‚ƒã£ãŸã‚Šã™ã‚‹ã‚“ã ã‘ã©ã“ã‚Œã¾ãšã„ã®ã‹ãª

db

oracle
ãƒªãƒ³ã‚¯
ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã¯å¤§è¦æ¨¡DBã®æ€§èƒ½å‘ä¸Šã«åŠ¹ãï¼ˆ1/3ï¼‰ â€• ï¼ IT
æœ¬é€£è¼‰ã§ã¯ã€å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®æ‰‹æ³•ã¨ã—ã¦ã€Oracleãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã‚’è§£èª¬ã™ã‚‹ã€‚å˜ãªã‚‹æ©Ÿèƒ½èª¬æ˜Žã«ã¨ã©ã¾ã‚‰ãšã€å®Ÿæ©Ÿã«ã‚ˆã‚‹æ¤œè¨¼çµæžœã‚’åŠ ãˆã¦ã€ã‚ˆã‚Šå®Ÿè·µçš„ãªå†…å®¹ã‚’ãŠå±Šã‘ã™ã‚‹ã€‚ï¼ˆç·¨é›†éƒ¨ï¼‰ ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã®å¿…è¦æ€§ ä»Šæ—¥ã€Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å–ã‚Šå·»ãç’°å¢ƒã¯ã€å¤šç¨®å¤šæ§˜ãªãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãƒ‹ãƒ¼ã‚ºã«å¿œãˆã‚‹ã¹ãé€²åŒ–ã—ã¦ã„ã¾ã™ã€‚ä¾‹ãˆã°ã€Webã‚µãƒ¼ãƒã®ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã¨ã—ã¦ä½¿ç”¨ã•ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯ã€é«˜ã„å¯ç”¨æ€§ã‚’å®Ÿç¾ã—ãªãŒã‚‰ã€æ—¥ã€…å¢—åŠ ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã—ã€å¤šæ•°ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‹ã‚‰ã®è¦æ±‚ã‚’ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã®é…å»¶ãªãå‡¦ç†ã—ã€ã•ã‚‰ã«ã€å„ªã‚ŒãŸãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹æ€§ã‚’æä¾›ã™ã‚‹ãªã©ã€ãƒãƒ¼ãƒ‰ãƒ«ã®é«˜ã„è¦ä»¶ãŒæ±‚ã‚ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã®ã‚ˆã†ãªè¦ä»¶ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚·ã‚¹ãƒ†ãƒ ã«å¯¾ã—ã€ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢é¢ã§ã¯ã“ã“æ•°å¹´ã€IAã‚µãƒ¼ãƒã‚’æŽ¡ç”¨ã™ã‚‹ã‚±ãƒ¼ã‚¹ãŒå¢—åŠ ã—ã¦ã„ã¾ã™ã€‚IAã‚µãƒ¼ãƒã®64bitåŒ–ã‚„CPUã®å‡¦ç†èƒ½åŠ›å¢—å¤§ï¼ˆãƒžãƒ«ãƒã‚³ã‚¢åŒ–ï¼‰ã«ä¼´ã„CPUå‡¦ç†
nnn3 2008/05/24
oracle

db

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
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; / å®Ÿè¡Œçµæžœ ---------+---------+------
nnn3 2007/03/24
[pl/sql]SET SERVEROUTPUT ON SIZE 1000000, ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§2000, æœ€å¤§ã§1000000

oracle
ãƒªãƒ³ã‚¯
OSã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ç”¨ã—ãŸãƒªã‚¹ãƒˆã‚¢ãƒ»ãƒªã‚«ãƒãƒªã®æ–¹æ³•
ä¸»ãªå†…å®¹ --Page 1-- â–¼ãƒªã‚¹ãƒˆã‚¢ãŠã‚ˆã³ãƒªã‚«ãƒãƒªã®æ¦‚ç•¥ --Page 2-- â–¼å®Œå…¨ãƒªã‚«ãƒãƒª â€•â€• ã‚ªãƒ•ãƒ©ã‚¤ãƒ³ãƒªã‚«ãƒãƒª --Page 3-- â–¼å®Œå…¨ãƒªã‚«ãƒãƒª â€•â€• ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒªã‚«ãƒãƒª --Page 4-- â–¼ä¸å®Œå…¨ãƒªã‚«ãƒãƒª â–¼ãƒŽãƒ¼ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ãƒã‚°é‹ç”¨ã§ã®ãƒªã‚«ãƒãƒª å‰å›žã¾ã§ã«OSã‚³ãƒžãƒ³ãƒ‰ã€Recovery Managerï¼ˆä»¥ä¸‹ã€RMANï¼‰ã€ãã‚Œãžã‚Œã‚’ä½¿ç”¨ã—ãŸãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ–¹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã—ã¦ãã¾ã—ãŸã€‚ä»Šå›žã¯ã€ãƒªã‚¹ãƒˆã‚¢ãƒ»ãƒªã‚«ãƒãƒªæ–¹æ³•ã®æ¦‚ç•¥ã‚’èª¬æ˜Žã—ãŸã†ãˆã§ã€å®Ÿéš›ã«OSã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ç”¨ã—ãŸãƒªã‚«ãƒãƒªæ–¹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ãªãŠã€ã‚³ãƒžãƒ³ãƒ‰ã®å®Ÿè¡Œçµæžœã¯ã€ã“ã‚Œã¾ã§ã¨åŒæ§˜ã«Linuxç’°å¢ƒã®Oracle 10g Release 2ã§å®Ÿè¡Œã—ãŸã‚‚ã®ã«ãªã‚Šã¾ã™ã€‚ ãƒªã‚¹ãƒˆã‚¢ãŠã‚ˆã³ãƒªã‚«ãƒãƒªã®æ¦‚ç•¥ ãƒªã‚¹ãƒˆã‚¢ãƒ»ãƒªã‚«ãƒãƒªã«OSã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ç”¨ã™ã‚‹ã‹ã€RMANã‚’ä½¿ç”¨ã™ã‚‹ã‹ã§ã€å…·ä½“çš„ãªæ‰‹é †ã‚„åˆ©ç”¨ã§ãã‚‹æ©Ÿèƒ½ã«ã¯é•ã„ãŒã‚ã‚Šã¾ã™ãŒã€åŸº
nnn3 2007/02/08
oracle

db

ã‚µãƒ¼ãƒç®¡ç†
ãƒªãƒ³ã‚¯
String Aggregation Techniques
On occasion it is necessary to aggregate data from a number of rows into a single row, giving a list of data associated with a specific value. Using the SCOTT.EMP table as an example, we might want to retrieve a list of employees for each department. Below is a list of the base data and the type of output we would like to return from an aggregate query. Base Data: DEPTNO ENAME ---------- ---------
nnn3 2007/02/04
sqlã§csv oracleé™å®š

oracle

tips

programming
ãƒªãƒ³ã‚¯
Oracle Inisialization Parameters
Index of Oracle INIT.ORA or SPFILE parameters
nnn3 2007/01/22
Oracleã®åˆæœŸåŒ–ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã¨éš ã—ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ä¸€è¦§

oracle

è¨å®š

db
ãƒªãƒ³ã‚¯
Oracleã¨J2SE5ã§è‡´å‘½çš„ãªãƒã‚°
minghaiã•ã‚“ã®ãƒ–ãƒã‚°ã§ã€Oracle JDBC Driverã®Bugã®è©±é¡ŒãŒå‡ºã¦ã„ãŸã®ã§ã€å°‘ã—æ•´ç†ã‚’ã€‚ JavaLobbyã«ã¦ä»¥ä¸‹ã®çµ„ã¿åˆã‚ã›ã§JDBCã‚’åˆ©ç”¨ã™ã‚‹ã¨ã€BigDecimalã®å€¤ãŒå¤‰ã‚ã£ã¦ã—ã¾ã†ã¨ã„ã†è‡´å‘½çš„ãªãƒã‚°ãŒå ±å‘Šã•ã‚Œã¦ã„ã‚‹ã€‚ ..... å•é¡Œã¯OracleãŒå¯¾å‡¦ã¨ã—ã¦ã€11gã®ä¿®æ£ã‚’å¾…ã¤ã‹ã€JDK1.4ã‚’åˆ©ç”¨ã›ã‚ˆã¨ã„ã£ã¦ã„ã‚‹ã‚‰ã—ã„ã€‚æŠ•ç¨¿è€…ã¯å½“ç„¶çŒ›åç™ºã—ã¦ã„ã‚‹ã€‚ ..... ã¾ã è½ã¨ã›ã¾ã›ã‚“ãŒã€è¿‘ã„ã†ã¡ã«OTNã«æŠ•ç¨¿ã•ã‚Œã‚‹ã§ã‚ã‚ã†ã€ãƒ‰ãƒ©ã‚¤ãƒ10.2.0.4ã«ã¦ä¿®æ£ã•ã‚Œã‚‹ãã†ã§ã™ã€‚ Oracleã®å ´åˆã€ãƒã‚°ãŒç™»éŒ²ã•ã‚Œã‚‹ã¨ã€ã¾ãšç¾åœ¨é–‹ç™ºä¸ã® (ã‚½ãƒ¼ã‚¹ãƒ»ã‚³ãƒ¼ãƒ‰ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã«ãŠã‘ã‚‹) trunk/ãƒ¡ã‚¤ãƒ³ãƒ»ãƒ©ã‚¤ãƒ³ã§ã€ãã®ãƒã‚°ä¿®æ£ãŒè¡Œã‚ã‚Œã¾ã™ã€‚ãƒ¡ã‚¤ãƒ³ãƒ»ãƒ©ã‚¤ãƒ³ã¯ã€ã„ãšã‚Œæ¬¡æœŸãƒªãƒªãƒ¼ã‚¹ã®ãƒ–ãƒ©ãƒ³ãƒã¨ãªã‚‹ã®ã§ã€ã¾ãšæ¬¡æœŸãƒªãƒªãƒ¼ã‚¹ã§ä¿®æ£ã•ã‚Œã‚‹ã¨è€ƒãˆã¦ã‚‚å•é¡Œã‚ã‚Šã¾ã›ã‚“ã€‚Oracle Databa
nnn3 2007/01/21
oracle

java
ãƒªãƒ³ã‚¯
PL/SQLã‹ã‚‰DLLã‚’å‘¼ã³å‡ºã™
çã—ãä»•äº‹é–¢é€£ãªè©±é¡Œã€‚PL/SQLã‹ã‚‰DLLã‚’å‘¼ã³å‡ºã™ã«ã¯ã©ã†ã™ã‚Œã°è‰¯ã„ã‹è³ªå•ã•ã‚ŒãŸã®ã§ã€ã¡ã‚‡ã£ã¨èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚ listener.oraã«ä»¥ä¸‹ã®è¨˜è¿°ã‚’è¿½åŠ ã€‚ LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) ... ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\Oracle\Ora92) (PROGRAM = extproc) ) ... ) ORACLE_HOMEã¯ç’°å¢ƒã«åˆã‚ã›ã‚‹ã€‚ tnsnames.oraã«ä»¥ä¸‹ã®è¨˜è¿°ã‚’è¿½åŠ ã€‚ EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRES
nnn3 2006/09/30
è³‡æ–™

programming

db

oracle
ãƒªãƒ³ã‚¯
1