Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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£©

˵µ½HWM,ÎÒÃÇÊ×ÏÈÒª¼òÒªµÄ̸̸ORACLEµÄÂß¼­´æ´¢¹ÜÀí.ÎÒÃÇÖªµÀ,ORACLEÔÚÂß¼­´æ´¢ÉÏ·Ö4¸öÁ£¶È:±í¿Õ¼ä,¶Î,ÇøºÍ¿é.
(1)¿é:ÊÇÁ£¶È×îСµÄ´æ´¢µ¥Î»,ÏÖÔÚ±ê×¼µÄ¿é´óСÊÇ8K,ORACLEÿһ´ÎI/O²Ù×÷Ò²Êǰ´¿éÀ´²Ù×÷µÄ,Ò²¾ÍÊÇ˵µ±ORACLE´ÓÊý¾ÝÎļþ¶ÁÊý¾Ýʱ,ÊǶÁÈ¡¶àÉÙ¸ö¿é,¶ø²»ÊǶàÉÙÐÐ.
(2)Çø:ÓÉһϵÁÐÏàÁÚµÄ¿é¶ø×é³É,ÕâÒ²ÊÇORACLE¿Õ¼ ......

Oracleɾ³ý´ó±í²¢»ØÊÕ¿Õ¼äµÄ¹ý³Ì

½üÈÕÔÚ²éѯijÏîÈÕÖ¾µÄʱºò£¬·¢ÏÖ²éѯ·Ç³£»ºÂý£¬¸ù¾ÝÒÔÍùµÄ¾­ÑéÕâÊÇÓÉÓÚij¸öÈÕÖ¾±í¹ý´óÒýÆðµÄ£¬ÎªÁ˼ӿì²éѯ£¬¾ö¶¨½«´ó²¿·ÖµÄÀúÊ·Êý¾ÝÇ¨ÒÆµ½ÁíÍâÒ»¸ö±íÖУ¬±¾ÎÄÖ÷Òª¼Ç¼ɾ³ýÕâ¸ö´ó±íµÄ¹ý³Ì£¬¾Í½â¾öÎÊÌâ¶øÑÔ»¹Óкܶ෽·¨£¬µ«ÊDZ¾ÎIJàÖØµãÔÚÓÚÈçºÎ´¦Àí´óÊý¾ÝÁ¿É¾³ýµÄ²Ù×÷£¬¼°ÆäÉÆºó¹¤×÷¡£
Ê×ÏÈ¿´¿´ÎÒÃÇÒª×öÊý¾ÝÇ¨ÒÆµÄ±íËùÕ¼µÄ ......

Oracle ¸ßËÙÅúÁ¿ËÙ²åÈëÊý¾Ý ½â¾ö·½°¸

×î½ü×ö¶ÌÐÅȺ·¢ÏîÄ¿ÓÐÒ»¸öÐèÇó,ÐèÒª¿Í»§´óÅúÁ¿(Ê®Íò¼¶)µ¼ÈëÊý¾Ý.
¿ªÊ¼ÊÇÓÃinsertµ¥ÌõÊý¾Ý,10ÍòÌõÊý¾ÝÒª20·ÖÖÓ
ºóÀ´·¢ÏÖ¿ÉÒÔÓÃinsert all Ò»ÌõsqlÒ»´Îµ¼Èë500Ìõ¼Ç¼,ÕâÑù10ÍòÌõÊý¾ÝÖ»ÓÃÁË1.5·ÖÖÓ,µ¼ÈëËÙ¶ÈÌá¸ßÁ˽üÀ´20±¶
ÏÂÃæ¾ÍʹÓÃinsert allµÄÐĵÃÌå»á¼Ç¼ÈçÏÂ.
ʹÓ÷½·¨:
insert all into table_name(col_1,col_2) v ......

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ