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

1 vote291 views1 answer
STOP message of how many rows affected sql
SQL
0 vote275 views1 answer
Doesn't have default value mysql
SQL
-1 vote297 views1 answer
Ms sql select datetime as date
SQL
3 votes240 views1 answer
V$session not found in oracle
SQL
3 votes254 views2 answers
How to start mysql in terminal
SQL
1 vote272 views2 answers
Grab part of a string sql
SQL
-1 vote254 views2 answers
Get day in sql
SQL
0 vote254 views1 answer
Phpmyadmin tabellentyp ändern
SQL
1 vote240 views1 answer
How to print longest name in sql
SQL
11 votes256 views1 answer
Sql insert multiple rows from select
SQL