Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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À´½øÐÐɾ³ý.


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log 
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ