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 DBA¶¼»á¾³£Åöµ½µÄÎÊÌâ¡£ÔÚORACLE9iÒÔǰµÄÄê´ú£¬ÎÒÃÇÒªÏȲéÕÒÊÇ·ñ´æÔÚÀÏÊý¾Ý£¬Èç¹ûÓÐÓÃUPDATEÌæ»»£¬·ñÔòÓÃINSERTÓï¾ä²åÈ룬Æä¼äÉÙ²»ÁË»¹ÓÐһЩ±ê¼Ç±äÁ¿µÈµÈ£¬·±ËöµÄºÜ¡£ÏÖÔÚORACLE9iרΪÕâÖÖÇé¿öÌṩÁËMERGEÓï¾ä£¬Ê¹ÕâÒ»¹¤×÷±äµÃÒì³£ÇáËÉ£¬
MERGEÓï ......
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 DBAÕ¾µãÉÏ£¬Óкܶà²éÕÒ±íÖеÚn¸ö×î´óÖµµÄС¼¼ÇÉ£¬ÕâЩÓï¾äȷʵÏ൱ÇÉÃËüÃǶ¼¶À±Ùõè¾¶µØÓõ½ÁËOracle±íÖеÄÒ»¸öα×ֶΓlevel”¡£µ«ÊÇÔںܶàÇé¿öÏ£¬Õâ¸öÓï¾ä±ä³ÉÁË ÃÀÀöµÄÏÝÚå¡£Èç¹ûÄãÏëÖªµÀΪʲô£¬²¢ÔõÑùÈÆ¹ýËü£¬ÇëÌýÎÒµÀÀ´£¡
Ñо¿Á˼¸Ì죬ÎÒ·¢ÏÖÒ»ÖÖÑÜÉúËã·¨£¬¼´ÕÒ³öµÚn¸öºÍµÚm¸ö×î´óÖ ......
½üÈÕÔÚ²éѯijÏîÈÕÖ¾µÄʱºò£¬·¢ÏÖ²éѯ·Ç³£»ºÂý£¬¸ù¾ÝÒÔÍùµÄ¾ÑéÕâÊÇÓÉÓÚij¸öÈÕÖ¾±í¹ý´óÒýÆðµÄ£¬ÎªÁ˼ӿì²éѯ£¬¾ö¶¨½«´ó²¿·ÖµÄÀúÊ·Êý¾ÝÇ¨ÒÆµ½ÁíÍâÒ»¸ö±íÖУ¬±¾ÎÄÖ÷Òª¼Ç¼ɾ³ýÕâ¸ö´ó±íµÄ¹ý³Ì£¬¾Í½â¾öÎÊÌâ¶øÑÔ»¹Óкܶ෽·¨£¬µ«ÊDZ¾ÎIJàÖØµãÔÚÓÚÈçºÎ´¦Àí´óÊý¾ÝÁ¿É¾³ýµÄ²Ù×÷£¬¼°ÆäÉÆºó¹¤×÷¡£
Ê×ÏÈ¿´¿´ÎÒÃÇÒª×öÊý¾ÝÇ¨ÒÆµÄ±íËùÕ¼µÄ ......