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

masakitk id:masakitk

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

${{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}}

ã‚ªãƒ©ã‚¯ãƒ«å¯¾ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ï¼š ä»Šåº¦ã¯Hudson - karasuyamatenguã®æ—¥è¨˜
æ—¥æœ¬äºº(http://twitter.com/kohsukekawa)ãŒãƒªãƒ¼ãƒ‰ã™ã‚‹ç¶™ç¶šçš„ã‚¤ãƒ³ãƒ†ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒ„ãƒ¼ãƒ«(http://ja.wikipedia.org/wiki/Hudson)ã®é–‹ç™ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã¨ã‚ªãƒ©ã‚¯ãƒ«ã®é–“ã«æ‘©æ“¦ãŒç”Ÿã˜ã¦ã„ã‚‹ã€‚ http://www.hudson-labs.org/content/whos-driving-thing ãƒãƒƒã‚¯ã‚°ãƒ©ã‚¦ãƒ³ãƒ‰ï¼š Hudsonã¯ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢(MIT License)ã ãŒã€Kohsuke Kawaguchiã•ã‚“ãŒSunã«ã„ãŸã“ã‚é–‹ç™ºã•ã‚ŒãŸãŸã‚ã€åŒç¤¾ãŒãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®ãƒˆãƒ¬ãƒ¼ãƒ‰ãƒžãƒ¼ã‚¯ã‚’æŒã£ã¦ã„ãŸã‚‰ã—ã„ã€‚ è²·åŽã«ã‚ˆã‚ŠSunã®Hudsonã«ãŸã„ã™ã‚‹æ¨©åˆ©ã‚‚ã‚ªãƒ©ã‚¯ãƒ«ã®ã‚‚ã®ã«ãªã£ãŸã€‚ å…ƒè¨˜äº‹ã«è©³ã—ã„ã‚¿ã‚¤ãƒ ãƒ©ã‚¤ãƒ³ãŒã‚ã‚‹ãŒã€è‚å¿ƒãªã¨ã“ã‚ã‚’æ‹¾ã†ã¨ï¼š é–‹ç™ºã¯java.netã§ãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ã•ã‚Œã¦ã„ãŸãŒä¿¡é ¼æ€§ã®å•é¡Œãªã©ã‹ã‚‰ãƒ¡ãƒ¼ãƒªãƒ³ã‚°ãƒªã‚¹ãƒˆã¯google gro
masakitk 2010/12/02
hudson

Oracle

ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹

Sun

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

oracle
ãƒªãƒ³ã‚¯
RHEL5/Oracle10gXE - ï¼ ã‚ã‚‚ã¦ã£ã
ç†è€…å®Ÿè¡Œä¾‹: Oracle Database 10g Express Edition Configuration ------------------------------------------------- This will configure on-boot properties of Oracle Database 10g Express Edition. The following questions will determine whether the database should be starting upon system boot, the ports it will use, and the passwords that will be used for database accounts. Press <Enter> to accept the default
masakitk 2010/05/18
oracle

linux

oraclexe
ãƒªãƒ³ã‚¯
OracleXE(10g)ã§JA16SJISã®åˆ©ç”¨ - ãªã‚“ã¨ãªã
Oracleã®ã€ç„¡å„Ÿç‰ˆã§ã‚ã‚‹ã€ Oracle Express Edition(ä»¥ä¸‹ã€OracleXE)ã¯ã€ä¾¿åˆ©ãã†ã§ã¯ã‚ã‚‹ã‚‚ã®ã®ã€æ—¥æœ¬èªžãƒ»ãƒ»ãƒ»ã¨ã„ã†ã‹ã€è‹±èªžä»¥å¤–ã§ã¯ã€NCHARã‚’é§†ä½¿ã™ã‚‹å¿…è¦ãŒã‚ã£ã¦å¤§å¤‰ã§ã™ã€‚ ã“ã‚Œã¯ã€ CHARACTER SET:ãƒ¨ãƒ¼ãƒãƒƒãƒ‘ã®ã©ã£ã‹ NATINAL CHARACTER SET:UTF8 ã¨ã‚†ãƒ¼å½¢ã§ã€å¤šè¨€èªžç”¨ã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ãŒç”¨æ„ã•ã‚Œã¦ã„ã‚‹ãŸã‚ã§ã™ã€‚ ãã“ã§ã€ã“ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ã™ã¦ã•ã£ã¦ã€æ–°ãŸã«ã€å¥½ããªè¨€èªžã§ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ä½œæˆã™ã‚Œã°ã€ãã“ãã“ä¾¿åˆ©ã«ãªã‚‹ã¯ãšãƒ»ãƒ»ãƒ»ãƒ»ã¨ã„ã†ã“ã¨ã§ã€æ‰‹é †ã‚’ãƒ¡ãƒ¢ä»£ã‚ã‚Šã«ãºãŸãºãŸã¨ã€‚ ãªãŠã€OracleXEã¯ã€å…¥å‡ºåŠ›ã®è¨€èªžã¨ã—ã¦ã¯å¤šæ•°ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã‚€ãã®è¨˜è¼‰ãŒã‚ã‚Šã¾ã™ãŒã€CHARACTER SETã¨ã—ã¦æŒ‡å®šã§ãã‚‹ã‹ã©ã†ã‹ã‚„ã€ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ä½œæˆã™ã‚‹ã“ã¨(CREATE DATABASE)ã‚’ã€ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã‹ã©ã†
masakitk 2010/03/22
oraclexe

oracle

æ–‡å—ã‚³ãƒ¼ãƒ‰
ãƒªãƒ³ã‚¯
https://www.atmarkit.co.jp/misc/search/marker.php?query=oracle&pg=www.atmarkit.co.jp/fdb/rensai/oraobstacle02/oraobstacle02_3.html
masakitk 2009/11/20
oracle

tips
ãƒªãƒ³ã‚¯
ãƒªã‚¹ãƒŠãƒ¼ã‚’åœæ¢ã›ãš listener.log ã‚’é€£ç¶šæ€§ã‚’ä¿ã£ãŸã¾ã¾æ–°ã—ãå‡ºåŠ›ã™ã‚‹ - é–“é•ã„ã ã‚‰ã‘ã®å‚™å¿˜éŒ²
http://www.h3.dion.ne.jp/~xosada/unix/oracle.html [å¯¾å‡¦] lsnrctl ãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ã® set log_file ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ã§å¯èƒ½ã§ã™ã€‚ ä»¥ä¸‹ã®æ‰‹é †ä¾‹ã‚’ã”å‚è€ƒä¸‹ã•ã„ã€‚ ä¾‹ï¼‰ ç¾åœ¨ã®ãƒ•ã‚¡ã‚¤ãƒ«åã‚’ listener.log ã¨ã—ã¾ã™ã€‚ 1. ä»¥ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ç”¨ã—ã€æ–°ãŸã« listener1.log ã‚’å‡ºåŠ›ã•ã›ã‚‹ã‚ˆã†ã«ã—ã¾ã™ã€‚ % lsnrctl LSNRCTL> set log_file listener1.log # ã“ã®æ™‚ç‚¹ã§ã€listener.log ãŒã‚ã‚‹ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã« # æ–°ãŸã« listener1.log ã¨ã„ã†ãƒ•ã‚¡ã‚¤ãƒ«ãŒä½œæˆã•ã‚Œã€ # ä»Šå¾Œã¯ã“ã®ãƒ•ã‚¡ã‚¤ãƒ«ä¸Šã«ãƒã‚®ãƒ³ã‚°ãŒè¡Œãªã‚ã‚Œã¾ã™ã€‚ 2. ç¾åœ¨ã® listener.log ã‚’ãƒªãƒãƒ¼ãƒ ã—ã¾ã™ã€‚ % mv listener.log listener.log.2003
masakitk 2009/08/10
oracle

listener.log
ãƒªãƒ³ã‚¯
ã‚ªãƒ©ã‚¯ãƒ«ç‰¹æ®ŠSQLãƒ¡ãƒ¢(Hishidama's Oracle SQL Memo)
Oracleç‰¹æ®ŠSQLãƒ¡ãƒ¢ æ›¸ã„ã¦ãŠã‹ãªã„ã¨å¿˜ã‚Œã¦ã—ã¾ã†ã‚ˆã†ãªã€Oracleã®ã¡ã‚‡ã£ã¨é¢å€’ãªSQLã‚„å‹•ä½œã®ãƒ¡ãƒ¢ã§ã™ã€‚
masakitk 2009/07/17
oracle

ãƒ¡ãƒ¢

tips
ãƒªãƒ³ã‚¯
ALTER TABLE MOVE or SHRINK - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracleã‚’ãƒžã‚¹ã‚¿ãƒ¼ã™ã‚‹ãŸã‚ã®åŸºæœ¬ã¨ä»•çµ„ã¿
ALTER TABLE MOVE or SHRINK Top ï½œ Knowledgeï½œ DBæ§‹ç¯‰ï½œ æ–‡å—åˆ—é–¢æ•°ï½œ æ—¥ä»˜é–¢æ•°ï½œ é›†è¨ˆé–¢æ•°ï½œ SQLé–¢æ•°ï¼ˆã‚¢ãƒ«ãƒ•ã‚¡ãƒ™ãƒƒãƒˆé †ï¼‰ SQLï¼ˆæŠ½å‡ºãƒ»æ›´æ–°ï¼‰ï½œ SQL*Plusï½œ PL/SQLï½œ Utilityï½œ Structureï½œ ã‚¹ã‚ãƒ¼ãƒžï½œ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï½œ ç”¨èªžï½œ å‚è€ƒæ›¸ ALTER TABLE MOVE ã¨ ALTER TABLE SHRINK ã®é•ã„ ALTER ã€œ SHRINK SPACE çµè«–ã‹ã‚‰è¨€ã†ã¨ã€ç¾åœ¨ã®ã‚ªãƒ©ã‚¯ãƒ«ã§ SHRINK æ“ä½œã«ã‚»ã‚°ãƒ¡ãƒ³ãƒˆã®ç¸®å°(HWM ã®ä½Žä¸‹)ã®åŠ¹æžœã‚’æœŸå¾…ã™ã‚‹ãªã‚‰ã° è¡Œç§»è¡Œãƒ»è¡Œé€£éŽ– ã‚’è§£æ¶ˆã—ã¦ã‹ã‚‰å®Ÿè¡Œã—ãŸã»ã†ãŒã‚ˆã„ã ã‚ã†ã€‚ï¼ˆè¡Œé€£éŽ–ã¯æ¶ˆã™ã“ã¨ãŒã§ããªã„ã®ã§ã€ASSM ã§ã¯ã©ã“ã«é€£éŽ–ã™ã‚‹ã‹ã¯é‹æ¬¡ç¬¬ï¼Ÿï¼‰ SHRINK æ“ä½œã¯ Oracle 10g ã‹ã‚‰ã®æ©Ÿèƒ½ã§ã‚ã‚Š ONLINE å®Ÿè¡Œã§ãã‚‹ãªã©ã®ç‰¹é•·ã‹ã‚‰éžå¸¸ã«æœ‰ç”¨ã§ã‚
masakitk 2009/05/13
oracle

shrink

ç©ºãé ˜åŸŸ
ãƒªãƒ³ã‚¯
Works - é€†å¼•ãSQLæ¯”è¼ƒ
ã‚µãƒ³ãƒ—ãƒ«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½¿ç”¨ã—ã€ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®ä¾‹ã‚’æŒ™ã’ã¦ã„ãã¾ã™ã€‚ ã“ã®ãƒšãƒ¼ã‚¸ã§ã¯ã€ORACLE ã«ã¤ã„ã¦è¿°ã¹ã¦ã„ã¾ã™ã€‚ ä»–ã® RDBMS ã«ã¤ã„ã¦è¦‹ãŸã„å ´åˆã¯ã€å„é …ã®ãƒªãƒ³ã‚¯ ï¼ˆ ORACLE MSSQL SSA MySQL ï¼‰ ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¦ãã ã•ã„ã€‚ ã¾ãŸã€ä½¿ã‚ã‚Œã¦ã„ã‚‹è¨€è‘‰ã®æ„å‘³ãŒã‚ã‹ã‚‰ãªã„å ´åˆã¯ã€å…±é€šäº‹é …ã‚’è¦‹ã¦ãã ã•ã„ã€‚ ã“ã®é …ã§ä½¿ç”¨ã™ã‚‹ã‚µãƒ³ãƒ—ãƒ«ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¤ã„ã¦ ORACLEã¨SQL Serverç³»ã®å¤§ããªé•ã„ã¨ã¯ï¼Ÿ æ‰‹ç¶šãåž‹è¨€èªžã®æ›¸ãæ–¹ã¯ï¼Ÿï¼ˆBEGINã€œENDãƒ–ãƒãƒƒã‚¯ï¼‰ ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®ã‚µãƒ³ãƒ—ãƒ«ï¼ˆã‚«ãƒ¼ã‚½ãƒ«ã‚’ä½¿ç”¨ã—ãŸLOOPå‡¦ç†ï¼‰ ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®ã‚µãƒ³ãƒ—ãƒ«ï¼ˆã‚¢ã‚¦ãƒˆãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ï¼‰ ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®ã‚µãƒ³ãƒ—ãƒ«ï¼ˆå‹•çš„SQLï¼‰ ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®ã‚µãƒ³ãƒ—ãƒ«ï¼ˆä¸€æ™‚ãƒ†ãƒ¼ãƒ–ãƒ«ï¼‰ ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®ã‚µãƒ³ãƒ—ãƒ«ï¼ˆå¤–éƒ¨ã‚³ãƒžãƒ³ãƒ‰ãƒ»ã‚¢ãƒ—ãƒªã‚’å®Ÿè¡Œï¼‰ ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·
masakitk 2009/04/16
[

oracle

tips
ãƒªãƒ³ã‚¯
http://634.ayumu-baby.com/oracle/oracle_tablespace4.html
masakitk 2009/04/15
oracle

tips
ãƒªãƒ³ã‚¯
ayumu-baby.com
This domain may be for sale!
masakitk 2009/03/16
oracle

é‹ç”¨

tips

ã‚»ãƒƒã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
Works - é€†å¼•ãSQLæ¯”è¼ƒ
Works > é€†å¼•ãSQLæ¯”è¼ƒ > ORACLE > ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æƒ…å ± ORACLE [Â SQLÂ ]Â [Â ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æƒ…å ±Â ]Â [Â æ‰‹ç¶šãåž‹è¨€èªžÂ ]Â [Â ãã®ä»–Â ]Â â– ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æƒ…å ±ï¼ˆDBAãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°é–¢é€£ï¼‰ å„ RDBMS ã«ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®çŠ¶æ…‹ã‚’è¡¨ç¤ºã™ã‚‹ãŸã‚ã®ã‚·ã‚¹ãƒ†ãƒ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚„å…±é€šè¡¨ãŒå˜åœ¨ã—ã¾ã™ã€‚ ãã‚Œã‚‰ã‚’ä½¿ã£ã¦ã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ä¸€è¦§ã‚’ä½œã£ãŸã‚Šã§ãã¾ã™ã€‚ã‚ˆãä½¿ã†ã§ã‚ã‚ã†ä»£è¡¨çš„ãªã‚‚ã®ã‚’æŒ™ã’ã¦ã„ãã¾ã™ã€‚ ã“ã®ãƒšãƒ¼ã‚¸ã§ã¯ã€ORACLE ã«ã¤ã„ã¦è¿°ã¹ã¦ã„ã¾ã™ã€‚ ä»–ã® RDBMS ã«ã¤ã„ã¦è¦‹ãŸã„å ´åˆã¯ã€å„é …ã®ãƒªãƒ³ã‚¯ ï¼ˆ ORACLE MSSQL SSA Postgres MySQL Jet ï¼‰ ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¦ãã ã•ã„ã€‚ ã¾ãŸã€ä½¿ã‚ã‚Œã¦ã„ã‚‹è¨€è‘‰ã®æ„å‘³ãŒã‚ã‹ã‚‰ãªã„å ´åˆã¯ã€å…±é€šäº‹é …ã‚’è¦‹ã¦ãã ã•ã„ã€‚ ã‚·ã‚¹ãƒ†ãƒ æ—¥ä»˜ã‚’è¡¨ç¤ºã™ã‚‹ã«ã¯ï¼Ÿ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’è¡¨ç¤ºã™ã‚‹ã«ã¯ï¼Ÿ
masakitk 2009/03/05
oracle

tips

lock
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã®ãƒŽã‚¦ãƒã‚¦ã¡ã‚‡ã„è¦‹ã› ç§ãŒä½¿ã†SQLæ–‡ã®æ•ã¾ãˆæ–¹ï¼†å®Ÿè¡Œè¨ˆç”»å–å¾—æ–¹æ³•(å‰ç·¨)
å„ç¨®ã‚¤ãƒ³ãƒ•ãƒ©æŠ€è¡“(OSã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯)ã‚„ã‚ªãƒ©ã‚¯ãƒ«è£½å“ã¨ã„ã£ãŸè©±é¡Œã‚’å–ã‚Šä¸Šã’ã¾ã™ã€‚è‘—è€…ã¯å°ç”°åœäºŒã€ã€Œé–€å¤–ä¸å‡ºã®Oracleç¾å ´ãƒ¯ã‚¶ã€ã€ã€Œçµµã§è¦‹ã¦ã‚ã‹ã‚‹Oracleã®ä»•çµ„ã¿ã€ã€ã€Œçµµã§è¦‹ã¦ã‚ã‹ã‚‹OS/ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸/ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã€ãªã©ã®è‘—ä½œã‚‚ã‚ã‚Šã¾ã™ â€»ã„ãŸã ã„ãŸã‚³ãƒ¡ãƒ³ãƒˆã‚’æŽ¡ç”¨ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ã€Œ and a.sql_child_number = b.child_numberã€ã‚’è¿½åŠ ã—ã¦ã„ã¾ã™ã€‚ ä»Šå›žã¯ã€ç§ãŒã‚ˆãä½¿ã†ã€å®Ÿè¡Œã•ã‚ŒãŸSQLæ–‡ã®æ•ã¾ãˆæ–¹ã€ãŠã‚ˆã³SQLæ–‡ã®å®Ÿè¡Œè¨ˆç”»å–å¾—æ–¹æ³•ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚é•·ã„ã®ã§å‰ç·¨ã¨å¾Œç·¨ã«åˆ†ã‘ã¾ã™ã€‚ä»Šå›žã¯å‰ç·¨ã§ã™ã€‚ ã¾ãšã€ã€Œv$sql_planã‹ã‚‰å®Ÿè¡Œè¨ˆç”»ã‚’è¡¨ç¤ºã™ã‚‹ã€æ–¹æ³•ã‚’ç°¡å˜ã«ç´¹ä»‹ã—ã€ãã®å¾Œã€ã€Œå®Ÿè¡Œã•ã‚ŒãŸSQLæ–‡ã®æ•ã¾ãˆæ–¹ã€ã‚’èª¬æ˜Žã—ã¾ã™ã€‚ â—ãã®ï¼ã€€v$sql_planã‹ã‚‰å®Ÿè¡Œè¨ˆç”»ã‚’è¡¨ç¤ºã™ã‚‹ã€‚ ã©ã®æ–¹æ³•ã§ã‚‚å¤§ä½“ä½¿ãˆã‚‹ã€v$ãƒ“ãƒ¥ãƒ¼ã‹ã‚‰ã®å®Ÿè¡Œè¨ˆç”»ã®è¡¨ç¤ºæ–¹æ³•ã§ã™
masakitk 2009/02/27
oracle

ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°
ãƒªãƒ³ã‚¯
1