ÍÆ¼öÒ»¿îÖ§³ÖOracleµÄsql±à¼Èí¼þ
Ö§³Ö´úÂë¸ßÁÁ¡¢ÖÇÄÜÌáʾ¡¢×Ô¶¯Íê³ÉµÈ»ù±¾¹¦ÄÜ¡£»¹ÓÐÐí¶àÆäËûÀ©Õ¹¹¦ÄÜ¡£
ºÍÔÚvs2008ÖÐд´úÂëÒ»ÑùÇáËÉ¡£
½ØÍ¼1
½ØÍ¼2
http://218.25.154.154:8081/images/2.gif
ÏÂÔØµØÖ·£º
http://218.25.154.154:8081/Software/SqlEditPlugs.rar
³£¼ûÎÊÌ⣺
http://218.25.154.154:8081/question.html
¸öÈ˹۵ã½ö×÷ÍÆ¼ö¡£5È˽áÌù¡£
Ò»»áÏÂÒ»¸ö¿´¿´
jf
ÏÂÔØÇÆÇÆ
ÎÒÀ´×öµÚËÄÈË
½Ó·Ö¡£¡£¡£¡£
¶÷£¬ÏÂÔØÁË£¬È¥ÓÃÓÿ´°É£¡
pl/sql devºÍtoad²»´íÁ˰¡
½áÌù¡£
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃ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 ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......