ÍÆ¼öЩORACLE·½ÃæµÄÊé - Oracle / »ù´¡ºÍ¹ÜÀí
×îºÃÊÇÓеç×Ó°æµÄ ¿ÉÒÔ´ÓÈëÃÅ¿ªÊ¼ ÎÒµÄÄ¿µÄ²»ÊÇÓÃORACLE×öÔöɾ¸Ä²é»òÕßдʲô´æ´¢¹ý³Ì Ö»ÊÇÏ£Íû´ÓÒ»¸ö±È½ÏµÍµÄÆðµãÈ¥Á˽âÕâ¸öÊý¾Ý¿â~ лл(ÎÒÕâÀàÎÊÌâ¸Ã·¢µ½Äĸö°æ?)
ÓиöpptµÄ½Ìѧ£¬¿ÉÒÔ¸øÄãÒýÓà Oracle 11g »ù´¡ÓëÌá¸ß ¾«Í¨Oracle 10g PL/SQL±à³Ì »ù´¡µÄÊé²»¹ó£¬¿ÉÖ§³ÖÒ»ÏÂ×÷Õß ¾«Í¨Oracle 10g PL/SQL±à³Ì ÎÒºÃÏóÓÐÕâһϵÁÐµÄÆäÖÐÒ»±¾Êé (¾«Í¨Oracle 10g SQLºÍPL/SQL±à³Ì) Ë®ÀûË®µç³ö°æÉçµÄ? ÎÒÊÖÍ·Õâ±¾ ¸øÎҸоõ½Ú×àÌ«¿ì ²»ÊÇ˵Ëû²»ºÃ(ÊÇÎÒ¼ûµ½¹ý×î²»·Ï»°µÄÒ»±¾Êé..) µ«ÊÇÎÒÏëÈ¥Á˽âÕâ¸öÊý¾Ý¿â Á˽âÈ»ºóȥʹÓà ÏÖÔÚÎÒÊÖÍ·Óб¾ÀàËÆÎÒ˵µÄÊé µ«ÊÇÎÒ¿´²»Ì«¶®°¡.. ÄúÍÆ¼öµÄÊéÎÒÔÚÏ ÏÈ¿´¿´¿© 153996072@qq.com ÎÒµÄÓÊÏä ¸÷λ´ó¸çÒ²¿ÉÒÔ¼ÓÏÂÎÒµÄQQ ÎÒѧϰѧϰ »ù´¡µÄÄǾÍÊÇÊý¾Ý¿âÔÀíÁË· Íõº£ÁÁºÍ¸Ç¹úÇ¿µÄÊé²»´í£¬Â¥Ö÷¿ÉÒÔ°Ù¶ÈÒ»ÏÂËûÃǵÄÊé ²»´íµÄ£¬Ð»Ð»¡£ ·¢ÁË£¬¼ÇµÃ¸øÎÒ¼Ó·Ö!!!ºÙºÙ!!!!ÒýÓà ¾«Í¨Oracle 10g PL/SQL±à³Ì ÊǵÚÒ»°æ ÎÒ¿´ÁËÕâ±¾µç×Ó°æµÄ ¾«Í¨Oracle 10g SQLºÍPL/SQL±à³Ì Êǵڶþ°æ,ÎÒÅóÓÑÄÇÓÐÊé,Ò²¿´ÁËÏÂ.Ôö¼ÓÁËЩÄÚÈÝ 2±¾¶¼²»´í ÔõôÐÎÈݵڶþ±¾ÄØ ¿ÉÒÔÕâô˵ ÎÒÊÇ´Ó»ù´¡¿ªÊ¼¿´µÄ Ê×ÏÈ´ò¿ªÊé È»ºó¿´ ´ÓµÚÒ»Ò³¿´µ½50Ò³ È»ºóºÏÉÏÊé ûÓÐÈκβ»ÊÊ.. ËٶȾÍÊÇÕâô¿ì... ÎÒÒ²Ïëѧoracle£¬µ«ÊÇÊéÉÏдµÄÓеIJ»Ì«ºÃÀí½â¡£²»ÖªµÀ¿ÉÓÐÕâ·½ÃæµÄÅàѵ ÎÒ¿´oRACLEµÄÊéµÄʱºò¾Í¸Ð¾õ ¿ªÍ·¶®µÄ ºóÀ´¾Í²»´ó¶® Ò²Ðíû×Ðϸ¿´ ºÇºÇ ºÍÂ¥Ö÷¹²Í¬Ñ§Ï° °ï¶¥¸ö Oracle 11g »ù´¡ÓëÌá¸ß ¾«Í¨Oracle 10g PL/SQL±à³
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......