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

18 votes347 views4 answers
Uninstall mysql ubuntu 18.04
SQL
5 votes356 views3 answers
Show indexes mysql
SQL
0 vote345 views1 answer
Convert int to varchar sql
SQL
4 votes334 views1 answer
Is there any command to change postgres password
SQL
3 votes375 views2 answers
Sqlite show table structure
SQL
0 vote375 views1 answer
Recently updated stored procedure in sql server
SQL
1 vote346 views1 answer
Postgresql pass array in function
SQL
1 vote368 views1 answer
Database Queries
SQL
8 votes342 views1 answer
Declare table variable sql server
SQL
1 vote327 views1 answer
Postgres count string length
SQL