Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹ØÓÚÔÚoracleÀïһЩ¹ØÁªµÄÊý¾Ý - Oracle / »ù´¡ºÍ¹ÜÀí

Ò³ÃæÉÏÓиöÊ÷×´½á¹¹Í¼£¬ÆäÊý¾ÝÔÚÊý¾Ý¿âÀï´æ´¢£¬ÓÐÁ½¸öÖØÒªµÄ×Ö¶Î code ºÍ parentCode£¬ÆäÖÐcodeΪ×Ô¼ºµÄ´úÂëºÅ£¬parentCodeÖ¸Ïò¸¸¼¶¡£
ÏÖÔÚÒªÇóÓÃsql½Å±¾£¬ÔÚÊý¾Ý¿âÀォÆäÖÐÒ»¸öÊý¾Ý¼°Æä×ÓËïÊý¾Ý¶¼É¾³ý£¬
Âé·³ÄÄλ¸ßÊÖ°ï¸öæ¡£¡£¡£¡£
´ó¼Ò¶¼À´¹Ø×¢Ï¡£¡£¡£¡£


ллÄãµÄ°ï棬ÄãÄܸæËßÎÒ start with code=? connect by parentCode=prior code µÄ¾ßÌ庬ÒåÂð£¬ÎÒÖ»ÊÇ´ó¸ÅÀí½â¡£¡£¡£¡£¡£Ð»Ð»¡£¡£

oracle²ã´Î»¯²éѯ:
http://blog.csdn.net/wh62592855/archive/2009/10/20/4704104.aspx
¸ù¾Ý²ã´Î»¯²éѯ³öÀ´µÄcodeÀ´½øÐÐɾ³ý.


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

ÅäÖû·¾³±äÁ¿oracleÔÚ XP - Oracle / »ù´¡ºÍ¹ÜÀí

ÅäÖû·¾³±äÁ¿oracleÔÚ XP
 ÐüÉÍ·Ö£º105 - ½â¾öʱ¼ä£º2008-9-23 23:39 
ÎÒÖ»°Ñoracle×°ÔÚÁËE:\oracleÖÐ
»·¾³±äÁ¿²»ÖªµÀÈçºÎÅäÖÃ.

XPϰ²×°ORACLE ûÓÐÐèÒªÅäÖõĻ·¾³±äÁ¿
¿ÉÒÔͨ¹ýEMÅäÖÃÏ·þÎñÃûº ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ