Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracleµÄ·ÖºÅºÍб¸Ü/ - Oracle / »ù´¡ºÍ¹ÜÀí

ÒýÓÃ
1. Adding a slash to the end of each statement was a bad choice because sqlplus treats slash as a buffer flush. For procedure/triggers/functions it is a must: because content of if is stored in the buffer and is not executed. However, for all other statements it means executing the same statement twice because such statement is executed immediately and put into buffer and following slash just re-executes the same statement.


ÎÒµÄÀí½âÊÇ£¬¶ÔһЩblock£¬±ÈÈçdeclare, begin end £¬create procedureÖ®ÀàµÄ£¬'/'ÊDZØÐëµÄ£¬ÓÃÀ´run
¶øÒ»Ð©¼òµ¥statement£¬¡®/ '»áµ¼ÖÂÔËÐÐÁ½´Î

ÎÊÌâÊÇ£¬Ö±½ÓÓÃÒ»¸ö'/'¾Í»áÔËÐÐÁ½´Î£¬»¹ÊÇÔÚ·ÖºÅÖ®ºó»¹ÔÚÏÂÐиú×Å / ²Å»áÖ´ÐÐÁ½´Î£¿

ÁíÍ⣬Èç¹ûÒª±ÜÃâÖØ¸´Ö´Ðеϰ£¬·ÖºÅºÍб¸ÜÊDz»ÊǶþѡһ¾Í¿ÉÒÔÁË£¬Ò»°ãÑ¡ÄĸöÓÐɶϰ¹ß£¿

ÒýÓÃ

1¡¢·ÅÔڷֺźóÃæµÄ / »áµ¼ÖÂÁ½´Î£»sqlplusÈÏΪÊäÈë¡°;¡±±íʾһ¸öÓï¾ä½áÊø
2¡¢·ÖºÅ


лл¡£

ÔÙÎÊÒ»ÏÂ
Ïñcreate procedure£¬µ½×îºóÒ²Ó¦¸ÃÓиö·ÖºÅ½áÊø£¬È»ºóÔÙ¸úÒ»¸öб¸Ü
¶ÔÕâÖÖblockµÄÕâÑùûÎÊÌâÂð£¿




Èç¹ûÊÇÓï¾äµÄ»°£¬;±íʾ½áÊø²¢ÇÒÔËÐÐ
Èç¹ûÊdzÌÐò¿é»òÕßpl¿é£¬£»±íʾ½áÊø²»ÔÊÐí£¬±ØÐë/±íʾÔËÐÐ

Â¥ÉϵÄÒѾ­ËµµÄºÜÇå³þÁË£¡
;ÊÇÖ´ÐÐÓï¾ä±ØÐëµÄ
/ÊÇÖ´ÐÐÓï¾ä¿é±ØÐëµÄ


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

OracleÈÏÖ¤ - Oracle / ÈÏÖ¤Ó뿼ÊÔ

ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ 
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......

asp.net·¢²¼Ê±£¬Oracle±¨´í - .NET¼¼Êõ / ASP.NET

1.ÏÖÔÚϵͳÊÇ64λµÄserver2003£¨web·þÎñÆ÷IIS6.0£©×°µÄÊÇ10gµÄoracle¿Í»§¶Ë¡£
2.Êý¾Ý¿â·þÎñÆ÷ͬÑùÊÇ32λµÄserver2003µÄoracle10g¡£
3.web·þÎñÆ÷ÉÏÓÃsqlplus·ÃÎÊÊý¾Ý¿â-Õý³££»
  vs2008ÄÚ²¿½¨Á¢Êý¾ÝÔ´£¬·ÃÎÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ