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Êý¾ÝµÄ´æ´¢ÖУ¬¿ÉÒÔ°Ñ´æ´¢¿Õ¼äÏëÏóΪһ¸öË®¿â£¬Êý¾ÝÏëÏóΪˮ¿âÖеÄË®¡£Ë®¿âÖеÄË®µÄλÖÃÓÐÒ»ÌõÏß½Ð×öˮλÏߣ¬ÔÚOracleÖУ¬ÕâÌõÏß±»³ÆÎª¸ßˮλÏߣ¨High-warter mark, HWM£©¡£ÔÚÊý¾Ý¿â±í¸Õ½¨Á¢µÄʱºò£¬ÓÉÓÚûÓÐÈκÎÊý¾Ý£¬ËùÒÔÕâ¸öʱºòˮλÏßÊǿյģ¬Ò²¾ÍÊÇ˵HWMΪ×îµÍÖµ¡£µ±²åÈëÁËÊý¾ÝÒԺ󣬸ßˮλÏ߾ͻáÉÏÕÇ£¬µ«ÊÇÕâ ......
SolarisÉÏOracle×Ô¶¯Æô¶¯ÉèÖÃ
===========================================================
×÷Õß: tianying(http://tianying.itpub.net)
·¢±íÓÚ: 2005.04.03 21:51
·ÖÀà: ³õʼ·ÖÀà
³ö´¦: http://tianying.itpub.net/post/2852/24823
---------------------------------------------------------------
¸ÕÔ ......
oracleÓû§¹ÜÀí
  ......
oracleÆô¶¯ÎÊÌâ
Ò»£ºÊý¾Ý¿âûÓÐÆô¶¯
#sqlplus /nolog
sql>connect /as sysdba
sql>startup
¶þ£º¼àÌý³öÎÊÌâ
µÇ¼DB·þÎñÆ÷
ʹÓÃlsnrctl start/stop¿ªÆô/¹Ø±Õ¼àÌý
ʹÓÃlsnrctl status²é¿´×´Ì¬
ÀíӦΪ£º
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ERPAP)(PORT=1521)))
STATUS of the ......
ͨ¹ý select * from table whereid=16701 for update Ëø×¡Ò»Õűí
ͨ¹ýÒÔÏÂÓï¾ä¿É²éѯ³ö±»Ëø×¡µÄ¶ÔÏó
SELECT OBJECT_ID,
SESSION_ID,
SERIAL#,
ORACLE_USERNAME,
&nb ......