oracle sqlldr 与 外部表[@more@]
自定义例外:
declare
tablenotexist exception;
pragma exception_init(tablenotexist,-942);
begin
execute immediate 'drop table xxxxx';
exception when tablenotexist then
dbms_output.put_line('tablenotexist');
end;
/
tablenotexist exception;
pragma exception_init(tablenotexist,-942);
begin
execute immediate 'drop table xxxxx';
exception when tablenotexist then
dbms_output.put_line('tablenotexist');
end;
/
pragma : 为编译指示命令。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/66634/viewspace-853012/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/66634/viewspace-853012/