oracleµÄ·ÖºÅºÍб¸Ü/ - Oracle / »ù´¡ºÍ¹ÜÀí
ÎÒµÄÀí½âÊÇ£¬¶ÔһЩblock£¬±ÈÈçdeclare, begin end £¬create procedureÖ®ÀàµÄ£¬'/'ÊDZØÐëµÄ£¬ÓÃÀ´run
¶øÒ»Ð©¼òµ¥statement£¬¡®/ '»áµ¼ÖÂÔËÐÐÁ½´Î
ÎÊÌâÊÇ£¬Ö±½ÓÓÃÒ»¸ö'/'¾Í»áÔËÐÐÁ½´Î£¬»¹ÊÇÔÚ·ÖºÅÖ®ºó»¹ÔÚÏÂÐиú×Å / ²Å»áÖ´ÐÐÁ½´Î£¿
ÁíÍ⣬Èç¹ûÒª±ÜÃâÖØ¸´Ö´Ðеϰ£¬·ÖºÅºÍб¸ÜÊDz»ÊǶþѡһ¾Í¿ÉÒÔÁË£¬Ò»°ãÑ¡ÄĸöÓÐɶϰ¹ß£¿
лл¡£
ÔÙÎÊÒ»ÏÂ
Ïñcreate procedure£¬µ½×îºóÒ²Ó¦¸ÃÓиö·ÖºÅ½áÊø£¬È»ºóÔÙ¸úÒ»¸öб¸Ü
¶ÔÕâÖÖblockµÄÕâÑùûÎÊÌâÂð£¿
Èç¹ûÊÇÓï¾äµÄ»°£¬;±íʾ½áÊø²¢ÇÒÔËÐÐ
Èç¹ûÊdzÌÐò¿é»òÕßpl¿é£¬£»±íʾ½áÊø²»ÔÊÐí£¬±ØÐë/±íʾÔËÐÐ
Â¥ÉϵÄÒѾ˵µÄºÜÇå³þÁË£¡
;ÊÇÖ´ÐÐÓï¾ä±ØÐëµÄ
/ÊÇÖ´ÐÐÓï¾ä¿é±ØÐëµÄ
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......