¼ÓÇ¿oracle²Ù×÷sql²éѯ
ÎÒÏë¼ÓÇ¿oracleµÄ²Ù×÷ÄÜÁ¦£¡Çë´óÏÀ°ïÖú
ʲô²Ù×÷ÄÜÁ¦£¿
oracle ¹ÜÀí »¹ÊÇoracle ¿ª·¢£¿
ÄǾÍÈÏÕæÑ§Ï°°¡
²»½â¡£¡£¡£¡£¡£
¶àÀ´ÂÛ̳¿´¿´,дд,´íÁËûÓйØÏµ,ÕâÀï´íÁË,¹¤×÷ÖоͲ»»áÔÚ´íÁË
×î½ü¹«Ë¾Ã»Ê²Ã´Ê ·· ÎÒÏëÕÒЩ×ÊÁÏѧϰѧϰoracle·Ð»Ð»¸÷λ¸øµã½¨ÒéºÍ×ÊÁÏ ÁªÏµ·½Ê½MSN£ºli_tiexin@live.cn QQ£º36278260 ÓÊÏ䣺litx@vizhuo.com лл¸÷λ¶à¶à°ïÖú
ÊDz»ÊÇÏëѧϰѽ ÏÂÔØ×ÊÁÏÈ¥csdn ÏÂÔØÇø
itpub.net ÉÏÒ²Óв»ÉÙ
ÊÕËõÒýÇæÄܽâ¾öµÄÎÊÌ⣬ÎÒÒ»°ã²»±ã»Ø´ð¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡
ÓÃһ̨»úÆ÷ȥʵÑé¡£
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃ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 ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......