ÎÒµÄ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ÐÍ£¬ÎÒÈÏΪϵͳÄܹ»Ê¶±ð ......
oracleÓÃ127.0.0.1½ÓÁ¬²»ÉÏ,ÓÐÈË˵ÊÇÒòΪ°²×°Ê±ÊÇÁªÍø°²×°µÄ£¬ËùÒÔ²»ÁªÉÏ£¬Óñ¾»úip¿ÉÒÔ
¸÷λ´ó¸ç£¬ÏÖÔÚÔõôÐ޸ģ¬Ð»Ð»ÁË
¼ÈÈ»ÊDZ¾»ú£¬·þÎñÃûtnsname.oraºÍlistener.ora¶¼¿É²»Å䣬¾Í¿ÉÒÔÁ¬½Ó¡£
127.0.0.1 localhost
ÖØÐÂÅäÖÃÒ»±é¼àÌý£¡
ÔõÃ´ÖØÐÂÅäÖã¬
ÓÃ127.0.0.1²»ÐУ¬µ«±¾»úµÄipÄÜÐУ¬ËûÃÇ˵ÔÒòÊǰ²×°Ê± ......
¸Õ°²×°Á˸öoracle9£¬xpÏµģ¬µ«ÊÇÔÚ´´½¨×ÊÁϵµ°¸¿âµÄʱºòÌáʾûÓмàÌýÆ÷£¬Ê¹ÓÃsqlplusµÄʱºòÒ²ÊÇ£¬ÉÏÍø²éÁËÏÂ×ÊÁÏ£¬¶¼ËµÊǼàÌý·þÎñûÓпªÆô£¬µ«ÎÒÕÒÁËÏÂÎҵķþÎñÀïÃæ¾ÍûÓмàÌý·þÎñ°¡£¬ÊÇÎҵݲװÎļþÓÐÎÊÌâô£¿»¹ÊÇÔõô»ØÊÂÄØ£¿
Ó¦¸ÃÊÇûÓа²×°ÍêÈ«¡£ÔÚ½¨¿âÍêÒԺ󣬾ͻáÌáʾÄã°²×°¼àÌýÆ÷µÄ¡£
OEM¿ØÖÆÌ¨·ÖÁ½ÖÖ·½Ê½Æô¶¯£ ......
SQL code:
procedure sc_numberbiao(use_sno char, use_number char) is
have number; --ÓÃÓÚÈ·¶¨ÊÇ·ñ´æÔÚ±íSC_NUMBER
cnumber number; --ÒÑÓпγÌÊýÁ¿
excp_number exception; --×Ô¶¨ÒåÒì³££¬ÓÃÓÚÈ·ÈÏÓû§Ñ¡¿ÎÊìÁ·ÊÇ·ñ´ïµ½ÒÑÓпγÌÉÏÏÞ
begin
select count(*) into cnumber from course ;
......
ËÓÐoracleÓëmysql µÄÇø±ð×ÊÁÏ
Ê²Ã´Çø±ð?
Óï·¨?
¹æÄ£?
Ó¦Óò¿Êð?
½á¹¹?
......ÄãÕâ¸ö·¶Î§Ò²Ì«´óÁ˰É
¾ÍÊÇOracleÖÐÓеĺ¯Êý£¬¶øÔÚmysqlÖÐûÓУ¬Ò²²»ÄÜÓõİ¡
ËûÃÇÖ®¼ä±ê×¼SQL99¶¼Ö§³ÖµÄ,ORACLE×Ô¼ºµÄPL/SQLÊÇÔÚSQLÉÏ×öÀ©Õ¹,
ºÜ¶àº¯ÊýûÓÐ,ûÓÐ×ö¹ý×ܽᰡ,ÀýÈçWM_CONCAT(),ROW_NUMBER(),DUMP()¶àÁËÈ¥ ......
Çë½Ì¸÷λ¸ßÊÖ£¬ÔÚred hat linux 5 Éϰ²×°oracleµÄ²½Ö裬лл°ïÖú£¡
°´ÕÕ°ïÖúÎĵµÉÏ°ì ·ÇrootÓû§°²×° java»·¾³Ö§³Ö ¾ÍokÁË
End_rbody_64648529//-->
¸Ã»Ø¸´ÓÚ2010-04-14 13:08:00±»°æÖ÷ɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP
vvhh33qq14
(vvhh3 ......