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 vote178 views1 answer
Find all tables where column name exists oracle
SQL
0 vote193 views1 answer
Mysql error 1251
SQL
0 vote230 views1 answer
Oracle swap partition
SQL
8 votes192 views2 answers
Oracle undo usage
SQL
0 vote187 views1 answer
Insert into select with group by
SQL
12 votes196 views4 answers
Psql command not found
SQL
3 votes200 views2 answers
Sqlite show table structure
SQL
0 vote167 views1 answer
Oracle for loop on list
SQL
0 vote189 views1 answer
Oracle date winter time
SQL
3 votes218 views2 answers
Search text in all sql server stored procedure
SQL