ÇóOracle SQL »òPL/SQL ÏîÄ¿ Á·Ï°
Èç±êÌ⣬±¾ÈËÒ»Ö±ÔÚ¿Ì¿àѧϰOracle£¬ÏÖÔÚÒÑ¾ÕÆÎÕÁËһЩ»ù±¾µÄ²Ù×÷ºÍSQLÓï·¨£¬Ïë½øÒ»²½Àí½â¡£ÎÒÏë×öÒ»ÏÂʵ¼ÊµÄÏîÄ¿»á½ø²½µÄ¸ü¿ì£¡£¡ ºÙºÙ...´ó¼ÒÓÐûÓÐһЩSQL»òPL/SQL ÏîÄ¿·½ÃæµÄÌâÄ¿£¬Èç¹û·½±ãÏ£Íû¸øÐ¡µÜÒ»µã£¡£¡£¡ ÏÈлл´ó¼ÒÀ²¡£¡£¡£¡£¡£o(¡É_¡É)o...
ÍøÉÏÓÐORACLE SQLÁ·Ï°Ì⼯½õ£¬¿ÉÒÔÏÂÔØÀ´ÅªÅª¡£ÒýÓÃ ÍøÉÏÓÐORACLE SQLÁ·Ï°Ì⼯½õ£¬¿ÉÒÔÏÂÔØÀ´ÅªÅª¡£ ÄǸö...ÎÒ¶¼×öÁ˺ÃЩÕâÑù×ÓµÄSQLÁ·Ï°ÁË£¬µ«ÕâЩÁ·Ï°Ö»ÊÇÁ·Ï°Ò»Ð¡²¿·Ö¡£ÎÒÏë×öÒ»¸ö×ܽáÁËËùÓÐPL/SQLµÄÏîÄ¿Á·Ï°£¡£¡ÕâÑùÎÒÏë»áÌá¸ßµÄ¸ü¿ì¡£¡£¡£¡£ÒýÓà Èç±êÌ⣬±¾ÈËÒ»Ö±ÔÚ¿Ì¿àѧϰOracle£¬ÏÖÔÚÒÑ¾ÕÆÎÕÁËһЩ»ù±¾µÄ²Ù×÷ºÍSQLÓï·¨ Óй¤×÷¾ÑéÂ𣿽¨ÒéȥӦƸ¸ãOracle¿ª·¢£¡ ³£À´CSDN¹ä¹ä д¸ö¿â´æÏµÍ³¡£ÒýÓà д¸ö¿â´æÏµÍ³¡£ ¿â´æÏµÍ³£¿£¿ÊÇÓÃÆäËûÓïÑÔ±àд½çÃæ£¬È»ºóÓÃOracle×öºǫ́Â𣿣¿ ÆäʵÄã¿ÉÒÔÈ¥ÏÂÔØÇøËæ±ãÕÒ¸öϵͳ¿´¿´£¬È»ºóÏë·½Éè·¨°Ñºǫ́¸Ä³ÉplsqlʵÏÖ²»¾ÍºÃÁË£¿ ¸çÃÇÄãÔÚʲôµØ·½ÎÒÓкöà¿âÄØ¡£8i£¬9iµÄ¶¼ÓС£¿ÉÒÔÁªÏµÎÒ¡£QQ:420750095 ûʹä¹äcsdnÓкܶàÎÊÌâÐèÒªÄãÀ´½â¾öµÄÒýÓà ÆäʵÄã¿ÉÒÔÈ¥ÏÂÔØÇøËæ±ãÕÒ¸öϵͳ¿´¿´£¬È»ºóÏë·½Éè·¨°Ñºǫ́¸Ä³ÉplsqlʵÏÖ²»¾ÍºÃÁË£¿ ºÃÖ÷Òâ¡£¡£¡£¡£¡£
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼: Àý£º
......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î 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 ......
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 / ......