Twenty-five years without you

摘要： 第一步：自定义异常excp_notexists exception第二步：捕获异常begin select*** into*** from*** where ***; exception when no_data_found then raise excp_notexists;end;第三步：处理... 阅读全文

摘要： 用DBA身份登录后查找死锁：select sess.sid, sess.serial#, lo.oracle_username, lo.os_user_name, ao.object_name, lo.locked_mode from v$locked_object lo, dba_o... 阅读全文