Oracle show errors compilation

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

7 votes187 views6 answers
Group_concat in mysql
SQL
2 votes168 views1 answer
Install sqlite npm
SQL
1 vote122 views1 answer
Postgres reset auto increment
SQL
1 vote171 views1 answer
Sql eliminare un record
SQL
1 vote183 views1 answer
Mysql show current queries
SQL
1 vote173 views1 answer
MySQL AND Operator
SQL
0 vote187 views1 answer
Shows all databases created by user in ms sql
SQL
1 vote182 views2 answers
Check if word is in column sql
SQL
0 vote171 views1 answer
Dump db only triggers mysql
SQL
0 vote161 views1 answer
Postgresql find missing id
SQL