Oracle error compilation 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 vote307 views1 answer
Sql server remove 0 from left
SQL
2 votes308 views1 answer
Sql server find table name
SQL
4 votes321 views1 answer
Mysql copy table with new name
SQL
3 votes302 views1 answer
Oracle apex message quit website
SQL
0 vote304 views1 answer
Mysql update privileges
SQL
0 vote309 views1 answer
Drop all tables db2
SQL
4 votes321 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote321 views2 answers
Sqlite unix timestamp
SQL
0 vote295 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
-1 vote326 views3 answers
How to restart mysql in linux
SQL