Oracle error line

SELECT to_char(a.LINE) || ' - ' || a.TEXT ERROR
FROM ALL_SOURCE a,
     ALL_ERRORS b
WHERE a.NAME = 'object_name'
  AND a.NAME = b.NAME
  AND a.TYPE = b.TYPE
  AND a.LINE = b.LINE
ORDER BY a.NAME, a.LINE;

Similar codes

0 vote284 views1 answer
Sql waitfor
SQL
0 vote285 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
16 votes314 views2 answers
Mysql date between two dates
SQL
5 votes286 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote285 views1 answer
Complete date is 1 year or not sql server
SQL
12 votes293 views4 answers
Import mysql database command line linux
SQL
53 votes479 views6 answers
Sql server alter column
SQL
1 vote276 views1 answer
Not exists mysql
SQL
4 votes280 views1 answer
Oracle delete last row
SQL
0 vote281 views1 answer
Oracle synonym procedure dblink
SQL