Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracle, stored procedure, cursor

CREATE OR REPLACE PROCEDURE kevin_proc(x varchar) IS
a VARCHAR(20);
b VARCHAR(20);
CURSOR mycur(rn NUMBER) IS SELECT * from t_kevin_test WHERE ROWNUM<rn;
BEGIN
OPEN mycur(10);
LOOP FETCH mycur INTO a,b;
EXIT WHEN mycur%NOTFOUND;
Dbms_Output.put_line('a: '||a);
Dbms_Output.put_line('b: '||b);
END LOOP;
CLOSE mycur;
begin
dbms_output.put_line (x);
end;
END;


Ïà¹ØÎĵµ£º

Oracle±í¶ÎÖеĸßˮ루HWM£©

ÔÚOracleÊý¾ÝµÄ´æ´¢ÖУ¬¿ÉÒÔ°Ñ´æ´¢¿Õ¼äÏëÏóΪһ¸öË®¿â£¬Êý¾ÝÏëÏóΪˮ¿âÖеÄË®¡£Ë®¿âÖеÄË®µÄλÖÃÓÐÒ»ÌõÏß½Ð×öˮλÏߣ¬ÔÚOracleÖУ¬ÕâÌõÏß±»³ÆÎª¸ßˮλÏߣ¨High-warter mark, HWM£©¡£ÔÚÊý¾Ý¿â±í¸Õ½¨Á¢µÄʱºò£¬ÓÉÓÚûÓÐÈκÎÊý¾Ý£¬ËùÒÔÕâ¸öʱºòˮλÏßÊǿյģ¬Ò²¾ÍÊÇ˵HWMΪ×îµÍÖµ¡£µ±²åÈëÁËÊý¾ÝÒԺ󣬸ßˮλÏ߾ͻáÉÏÕÇ£¬µ«ÊÇÕâ ......

Oracle»ù´¡Óï¾ä


1¡¢ 
Á¬½ÓÊý¾Ý¿â
connect uuu/ooo
connect 
sys/ok as sysdba
2¡¢ 
´´½¨±í¿Õ¼ä
create tablespace stu(±í¿Õ¼äÃû
) datafile 

e:\stu.dbf

 size 100m autoextend on next 5m maxsize 500m;
3¡¢& ......

Oracle tnsÅäÖõÄ6ÖÖ³£¼û´íÎó½â¾öÎÊÌâ

¾­¹ý³¤Ê±¼äѧϰOracle£¬Äã¿ÉÄÜ»áÓöµ½Oracle tnsÅäÖÃÎÊÌ⣬ÕâÀォ½éÉÜOracle tnsÅäÖÃÎÊÌâµÄ½â¾ö·½·¨¡£×î½üæ×Ű²×°OracleÊý¾Ý¿â£¬±¾À´Í¦¼òµ¥µÄ£¬¿ÉÀÏÊdzöÏÖÎÊÌ⣬×îºó×Ô¼ºÔÚÍøÉÏÕûÀíÁËһЩtns´íÎó½â¾ö·½·¨£¬Ï£Íû¶Ô³õѧÕßÓÐÒæ¡£
³£¼ûÎÊÌâ:
1¡¢ORA-12541:tns:ûÓмàÌýÆ÷£º
ÏÔ¶øÒ×¼û£¬·þÎñÆ÷¶ËµÄ¼àÌýÆ÷ûÓÐÆô¶¯£¬ÁíÍâ¼ì²é¿Í» ......

OracleÍⲿÉí·ÝÈÏÖ¤Ñо¿

OracleÍⲿÉí·ÝÈÏÖ¤Ñо¿
ÃÜÂëÎļþÈÏÖ¤          ²Ù×÷ϵͳÈÏÖ¤                  remote_login_passwordfile   SQLNET.AUTHENTICATION_SERVICES   &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ