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

ORACLE SAVE EXCEPTION ×Ó¾ä

½ñÌìÔÚÒ»¸öÌû×ÓÀï¿´µ½shiyiwanµÄ»ØÌûÖÐÌá¼°µ½ÁËÁ½¸ö×Ô¼ºÒÔǰû¼û¹ýµÄ¸ÅÄsave exceptionºÍdml error logging¡£ÉÏÍøËÑÁËËÑÏà¹ØÄÚÈÝ£¬¿´ÁË¿´´ó¸ÅÃ÷°×Òâ˼£¬²»¹ýÔÚʵ¼ÊÔËÓÃÖл¹ÊÇûÔõôÓùý¡£±£´æÏÂÀ´£¬ÒÔºóÓõĵ½µÄ»°·½±ã²éÔÄ¡£
ÕâһƪÊǹØÓÚsave exceptionµÄ£¬ÁíÍâһƪdml error loggingµÄ²Î¼ûÈçÏÂÁ´½Ó
http://blog.csdn.net/wh62592855/archive/2009/11/13/4808012.aspx
==================================================================================
Oracle ´Ó9i ¿ªÊ¼ÔöÇ¿ÁËÅú DML ÔÚ·¢ÉúÒ쳣ʱ´¦ÀíµÄ´íÎó¼°Ê§°ÜµÄ³ÌÐòÖ´ÐÐÄÜÁ¦¡£ÕâÊÇͨ¹ýFORALL Óï¾äµÄ SAVE EXCEPTION ×Ó¾äÀ´ÊµÏÖ£¬ÆäÓï·¨ÈçÏÂ:
FORALL index in lower..upper save exceptions
SAVE EXCEPTIONS ×Ó¾äÊÇ oracle 9i ÖÐÒýÈëµÄ£¬ËüÔÚÒ»¸öÒþʽÓαêÊôÐÔ£¬SQL%BULK_EXCEPTIONS Öб£´æ´íÎóÐУ¬ÔÊÐí FORALL Óï¾ä¼ÌÐø´¦ÀíÆäÓàÐС£
ÏÂÃæÕâÒ»¶Î´úÂëÊÇ SQL%BULK_EXCEPTIONS µÄÓ¦ÓÃÀý×Ó£º
create or replace procedure batch_dml(errnum outnumber,errtext outvarchar2)
is
type user_id_tab is table of number index by binary_integer;
type user_name_tab is table of varchar2( 20 ) index by binary_integer;
type user_sex_tab is table of varchar2( 2 ) index by binary_integer;
 
user_id user_id_tab;
user_name user_name_tab;
user_sex user_sex_tab;
bulk_bind_excep EXCEPTION;
pragma exception_init(bulk_bind_excep,- 24381 );
begin
for idx in 1 .. 50000 loop
user_id(idx):=idx;
user_name(idx):= 'xxx' ||idx;
user_sex(idx):= 'F' ;
endloop;
user_id( 40000 ):= 39999 ;
user_id( 10000 ):= 9999 ;
delete from t_user;
forall idx in user_id.first..user_id.last save exceptions
insert into t_user values(user_id(idx), user_name(idx),user_sex(idx));
errnum:= 0 ;
errtext:= '' ;
exception
when bulk_bind_excep then
for i in 1 ..sql%bulk_exceptions.count loop
dbms_output.put_line( 'Iteration '
||SQL%bulk_exceptions(i).error_index|| 'failed with error '
||sqlerrm(sql%bulk_exceptions(i).error_code));
endloop;
commit;
when others then
commit;
errnum:=sqlcode;
errtext:=sqlerrm;
end batch_dml;
Õâ¸öÀý×ÓÊÇÐÞ¸ÄÁËÉÏÃæµÄ³ÌÐò£¬¼ÓÉÏ save exceptions Òì³£´¦Àí£¬µ±Åú dml·¢ÉúÒì³


Ïà¹ØÎĵµ£º

È«Ãæ½âÎöOracle developerµÄÒì³£´¦Àí»úÖÆ

Oracle developerÒÔÆä¿ìËÙµÄÊý¾Ý´¦Àí¿ª·¢¶øÎÅÃû£¬ÆäÒì³£´¦Àí»úÖÆÒ²ÊDZȽÏÍêÉÆ£¬²»¿ÉСêï¡£
1¡¢ Òì³£µÄÓŵã
Èç¹ûûÓÐÒì³££¬ÔÚ³ÌÐòÖУ¬Ó¦µ±¼ì²éÿ¸öÃüÁîµÄ³É¹¦»¹ÊÇʧ°Ü£¬Èç
BEGIN
SELECT ...
-- check for ’no data found’ error
SELECT ...
-- check for ’no data found’ error
SEL ......

×ß½üOracleÊý¾Ý×Öµä(¶þ)

 ÔÚÉÏƪÎÄÕÂÀï“×ß½üOracleÊý¾Ý×Öµä--Êý¾Ý×Öµä±í”£¬ÎÒÃÇ̸µ½ÁËÊý¾Ý×Öµä¶ÔÓÚÎÒÃÇ×÷ΪDBA¶ÔÊý¾Ý¿âά»¤µÄÖØÒªÐÔ¡£Êý¾Ý¿âµÄ¶ÔÏóÐÅÏ¢£¬±ÈÈç±í£¬Óû§£¬´æ´¢¹ý³Ì£¬º¯Êý£¬ÊÓͼ£¬Ë÷ÒýµÈµÈ£¬ÕâЩ´æÔÚÔÚÊý¾Ý¿âÀïµÄ¶ÔÏóµÄÐÅÏ¢£¬¶¼ÊÇÔÚÊý¾Ý×Öµä±íÀï½øÐÐά»¤µÄ£¬ÎÒÃÇ¿ÉÒÔ½èÓÃһЩ±È½ÏºÃµÄOracle¿ª·¢¹¤¾ß±ÈÈçPLSQL dev»òÕß ......

Oracle 10gÊý¾Ý¿â¹Ø±ÕºóÎÞ·¨Æô¶¯£¬ORA

  ½üÈÕÔÚѧϰOracle 10GµÄ¹ý³ÌÖÐÓöµ½Ò»¸öÎÊÌ⣬¹Ø±ÕÊý¾Ý¿â£¨shutdown immediate£©ºó£¬ÔÙÖØÆôÊý¾Ý¿â(startup)£¬Æô¶¯Ê§°Ü£¬12514µÄ´íÎó£¬Èç¹ûͨ¹ýsqlplus /nolog½øÈëÊý¾Ý¿âÒÔºó£¬ÓÃconnÁ¬½Ó£¬Ò»Ñù²»ÐС£ÖØдò¿ªÒ»¸öcmd´°¿Ú£¬ÊäÈ룺
sqlplus
Óû§Ãû£ºsys@sim as sysdba£¬ÃÜÂëÊäÈëÍê³Éºó£¬ÈÔÈ»³öÏÖÈçÏ´íÎó£º
ORA ......

Oracle 1Z0

´ó¼ÒºÃ£¬ÎÒÔÚhttp://download.csdn.net/source/836323ÉÏ·¢µÄÌû×Ó£¬È·ÊµÖ»ÊǸödemo£¬ÆäÌâ¿âÄÚÈݼûÏÂÎÄ£¬´ËΪ×îÐÂÌâ¿âµÄÒ»²¿·Ö£¬Õýʽ°æÌâ¿âÊÇ175Ìâ¡£ÐèÒªÕýʽ°æ±¾µÄÅóÓÑ£¬¿ÉÒÔÖ±½ÓÁªÏµÎÒ»òÕßµ½www.certinside.cn/1z0-051  ÉÏÃæ¿´¿´£¬ÎÒÃǺÍtestinsideÊÇÒ»¼ÒµÄ£¬ÐèÒªµÄ»°ÎÒ¿ÉÒÔ¸øÄã´ò¸öÕÛ£¬¼Û¸ñÔÙÒé¡£ÎÒµÄQQ£º390970748¡¡ ......

Oracle Êý×Öº¯ÊýÓ÷¨

 1. round(Num,n) :  ËÄÉáÎåÈëÊý×ÖNum£¬±£ÁônλСÊý£¬²»Ð´NĬÈϲ»ÒªÐ¡Êý£¬ËÄÉáÎåÈëµ½ÕûÊý¸öλ
 select ROUND(21.237,2) from dual; 
 ½á¹û£º 21.24
 2. trunc(Num,n) : ½ØÈ¡Êý×ÖNum£¬±£ÁônλСÊý£¬²»Ð´NĬÈÏÊÇ0£¬¼´²»ÒªÐ¡Êý
 select TRUNC(21.237,2) from dual;
 ½á¹û£º21.2 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ