oracleµÄ·ÖºÅºÍб¸Ü/ - Oracle / »ù´¡ºÍ¹ÜÀí
ÎÒµÄÀí½âÊÇ£¬¶ÔһЩblock£¬±ÈÈçdeclare, begin end £¬create procedureÖ®ÀàµÄ£¬'/'ÊDZØÐëµÄ£¬ÓÃÀ´run
¶øÒ»Ð©¼òµ¥statement£¬¡®/ '»áµ¼ÖÂÔËÐÐÁ½´Î
ÎÊÌâÊÇ£¬Ö±½ÓÓÃÒ»¸ö'/'¾Í»áÔËÐÐÁ½´Î£¬»¹ÊÇÔÚ·ÖºÅÖ®ºó»¹ÔÚÏÂÐиú×Å / ²Å»áÖ´ÐÐÁ½´Î£¿
ÁíÍ⣬Èç¹ûÒª±ÜÃâÖØ¸´Ö´Ðеϰ£¬·ÖºÅºÍб¸ÜÊDz»ÊǶþѡһ¾Í¿ÉÒÔÁË£¬Ò»°ãÑ¡ÄĸöÓÐɶϰ¹ß£¿
лл¡£
ÔÙÎÊÒ»ÏÂ
Ïñcreate procedure£¬µ½×îºóÒ²Ó¦¸ÃÓиö·ÖºÅ½áÊø£¬È»ºóÔÙ¸úÒ»¸öб¸Ü
¶ÔÕâÖÖblockµÄÕâÑùûÎÊÌâÂð£¿
Èç¹ûÊÇÓï¾äµÄ»°£¬;±íʾ½áÊø²¢ÇÒÔËÐÐ
Èç¹ûÊdzÌÐò¿é»òÕßpl¿é£¬£»±íʾ½áÊø²»ÔÊÐí£¬±ØÐë/±íʾÔËÐÐ
Â¥ÉϵÄÒѾ˵µÄºÜÇå³þÁË£¡
;ÊÇÖ´ÐÐÓï¾ä±ØÐëµÄ
/ÊÇÖ´ÐÐÓï¾ä¿é±ØÐëµÄ
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£»
......
1.ÏÖÔÚϵͳÊÇ64λµÄserver2003£¨web·þÎñÆ÷IIS6.0£©×°µÄÊÇ10gµÄoracle¿Í»§¶Ë¡£
2.Êý¾Ý¿â·þÎñÆ÷ͬÑùÊÇ32λµÄserver2003µÄoracle10g¡£
3.web·þÎñÆ÷ÉÏÓÃsqlplus·ÃÎÊÊý¾Ý¿â-Õý³££»
vs2008ÄÚ²¿½¨Á¢Êý¾ÝÔ´£¬·ÃÎÊ ......
OracleÖÐÓû§ÃûÊÇʲô£¿
ÃèÊöÇå³þÒ»µã£¡
ORACLEÊý¾Ý¿âÖÐÓкܶàÄÚÖõÄÓû§Ãû£¬sys¾Í²»ËµÁË£¬»¹ÓÐscottÃÜÂëÊÇtiger.³ýÁËsys,ÆäËûÓû§¶¼ÊÇËù¶¨µÄ£¬½â³ýËø¶¨ºó²ÅÄÜʹÓá£ÔÚ±¾»úµÇ½Êý¾Ý¿âʱ£¬sysµÄÃÜÂë¿ÉÒÔËæÒâÊäÈë¡£
......