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

0 vote176 views1 answer
Pgsql is not permitted to log in
SQL
1 vote180 views3 answers
Remove unique key from a table
SQL
1 vote360 views2 answers
Sql unique rows
SQL
0 vote236 views1 answer
Sql ssrs
SQL
-1 vote189 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
0 vote172 views1 answer
Sql constarint
SQL
0 vote197 views1 answer
How to find lowest in sql
SQL
3 votes258 views2 answers
How to list columns for particular tables in postgresql
SQL
0 vote184 views1 answer
Python mysql query to dataframe
SQL
3 votes202 views5 answers
No module named 'MySQLdb'
SQL