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£©¶¼ÊÇÕâÑùʵÏÖÖØÔØµÄ
Ã÷ÌìÈ¥ÊÔÊÔ ÍíÉϻشðÖ®
ÎÒÒ²¾õµÃJAVAÖ®ÀàµÄ¶¼ÐеÃͨ£¬µ«ÊÇORACLE¾ÍÊÇÎÞ·¨Ê¶±ð°¡...ÎÒ¹À¼ÆÊDz»ÊÇCHARÀàÐͺÍNUMBERÀàÐÍÒª×Ô¼º±êʾһÏÂʲôµÄ
¸Ä²âÊÔ´úÂëËÆºõ
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......