Oracle°üÄÚ¹ý³ÌÖØÔØµÄÎÊÌâ - Oracle / ¿ª·¢
ÎÒµÄORACLEÒ»¸ö°üÄÚÓÐÁ½¸öÖØÔØµÄ¹ý³Ì·Ö±ðÊÇ£º procedure peoplegrade(use_sname char, use_cno char, use_grade smallint); procedure peoplegrade(use_sno number, use_cno char, use_grade smallint); ÏëʵÏÖÖØÔØ£¬ÒòΪÊäÈëµÄÊýÁ¿¶¼ÊÇÒ»ÑùµÄ£¬µÚÒ»¸öÊäÈë·Ö±ðÊÇcharºÍnumberÐÍ£¬ÎÒÈÏΪϵͳÄܹ»Ê¶±ð£¬µ«ÊDzâÊÔ´úÂë declare -- Local variables here i number; begin -- Test statements here student_yk.peoplegrade('0001','009','97'); end; ϵͳÌáʾÓÐÌ«¶àµÄ·½·¨·ûºÏ£¬¾ÍÊÇ˵ϵͳÊÇûÓÐÕýÈ·ÖØÔØ£¬ÇëÎÊÎÒÊÇÐèÒª¸Ä°üÄڵĹý³Ì»¹ÊÇÐ޸IJâÊÔ´úÂ룬Ôõô¸Ä£¬Ð»Ð»
ÀíÂÛÉϽ² ÕâÑùÐеÃͨѽ ·½·¨ÖвÎÊýÒ»Ñù¶à µ«ÊÇÀàÐͲ»Ò»Ö ¿ÉÒÔ×öµ½Ñ½ Ôڸ߼¶ÓïÑÔÖУ¨C# java£©¶¼ÊÇÕâÑùʵÏÖÖØÔØµÄ Ã÷ÌìÈ¥ÊÔÊÔ ÍíÉϻشðÖ®ÒýÓà ÀíÂÛÉϽ² ÕâÑùÐеÃͨѽ ·½·¨ÖвÎÊýÒ»Ñù¶à µ«ÊÇÀàÐͲ»Ò»Ö ¿ÉÒÔ×öµ½Ñ½ Ôڸ߼¶ÓïÑÔÖУ¨C# java£©¶¼ÊÇÕâÑùʵÏÖÖØÔØµÄ Ã÷ÌìÈ¥ÊÔÊÔ ÍíÉϻشðÖ® ÎÒÒ²¾õµÃJAVAÖ®ÀàµÄ¶¼ÐеÃͨ£¬µ«ÊÇORACLE¾ÍÊÇÎÞ·¨Ê¶±ð°¡...ÎÒ¹À¼ÆÊDz»ÊÇCHARÀàÐͺÍNUMBERÀàÐÍÒª×Ô¼º±êʾһÏÂʲôµÄÒýÓà ÎÒµÄORACLEÒ»¸ö°üÄÚÓÐÁ½¸öÖØÔØµÄ¹ý³Ì·Ö±ðÊÇ£º procedure peoplegrade(use_sname char, use_cno char, use_grade smallint); procedure peoplegrade(use_sno number, use_cno char, use_grade smallint); ÏëʵÏÖÖØÔØ£¬ÒòΪÊäÈëµÄÊýÁ¿¶¼ÊÇÒ»ÑùµÄ¡¡ ¸Ä²âÊÔ´úÂëËÆºõ
Ïà¹ØÎÊ´ð£º
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿ ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ.. ÒýÓà ¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃ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 for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨ ÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......