errors.sql

oracle dba 常用的管理脚本, 覆盖日常的系统管理.

--* File Name    : Errors.sql
--* Author       : DR Timothy S Hall
--* Description  : Displays the source line and the associated error after compilation failure.
--* Comments     : Essentially the same as SHOW ERRORS.
--* Call Syntax  : @Errors (source-name)
--* Last Modified: 15/07/2000
SELECT To_Char(a.line) || ' - ' || a.text error
FROM   user_source a,
       user_errors b
WHERE  a.name = Upper('&&1')
AND    a.name = b.name
AND    a.type = b.type
AND    a.line = b.line
ORDER BY a.name, a.line;