ÎÒµÄ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ÄÜÐУ¬ËûÃÇ˵ÔÒòÊǰ²×°Ê± ......
ÓÐÒ»¸öorcle¹ý³Ì
PROCEDURE PROC_AVG_F(cur_OUT OUT MYCURSOR,TABLE_NAME VARCHAR2,START_TIME VARCHAR2,END_TIME VARCHAR2 );
¹ý³ÌµÄÄ¿µÄÊÇÏë²éѯ³ö TABLE_NAME ±íÖÐ ¿ªÊ¼Ê±¼äºÍ½áÊøÊ±¼ä¶ÎµÄËùÓÐÐÅÏ¢
Ìí¼Óµ½½á¹û¼¯Óαêcur_OUTÀïÃæ£¬ÎÒÏëÎÊÄãµÄ¾ÍÊǴ˲éѯÓï¾ä¸ÃÔõôºÍÊäÈë²ÎÊý½øÐнáºÏ
ÏÂÃæÊÇÎÒÒѾÍê³ÉµÄ²¿·Ö¹ ......
¸Õ°²×°Á˸ö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 ;
......
»ñÈ¡Ajax·µ»ØÖµ£º
JScript code:
.....
var a = -1;
var b = -1;
if (xmlHttp.readyState == 4) {
if (xmlHttp.status == 200) {
a = xmlHttp.responseText;
}
}
alert(a); // ´òÓ¡a
alert(b); // ´òÓ¡b
if(a!= b) {
doSomething();
a = b;
}
ÎÊÌâ¾Í³öÔÚalertµÄµØ·½£¬Èç¹ûÓ ......