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 vote119 views3 answers
Get free card roblox
SQL
0 vote141 views1 answer
Tsql pad left
SQL
-1 vote122 views3 answers
Check table exist postgresql
SQL
9 votes145 views4 answers
Oracle get table column names
SQL
0 vote140 views1 answer
Check for directory in bash
SQL
0 vote125 views2 answers
Csv into data postgres
SQL
9 votes129 views3 answers
Oracle undo usage by session
SQL
0 vote131 views1 answer
Oracle right characters
SQL
0 vote128 views1 answer
Oracle list datafiles
SQL
0 vote129 views1 answer
Python mysql show databases
SQL