在SQLLPLUS中判断异常退出-非权限用户中止执行

set termout on
set serveroutput on
whenever sqlerror exit;


spool uninstll.log

select to_number('ERROR') from (select user name from dual) where name not like 'FM%';

prompt here is me!!!!!!!!!!!!!!!!!!
spool off;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11813230/viewspace-750348/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11813230/viewspace-750348/