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 vote168 views1 answer
Create bakupd database sqlserver
SQL
0 vote213 views1 answer
Mysql delete entire row on condition
SQL
0 vote209 views1 answer
Oracle list datafiles
SQL
0 vote207 views1 answer
Tsql cmd exec script from file
SQL
0 vote268 views1 answer
Drop view sql
SQL
0 vote217 views1 answer
Tinydb add table
SQL
2 votes219 views1 answer
Mysql change data type of column
SQL
0 vote188 views1 answer
Metada in sql
SQL
4 votes198 views1 answer
Mysql insert from local csv
SQL
0 vote198 views1 answer
Getting next sequence value jpa postgress
SQL