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

11 votes187 views2 answers
Insert current date sql
SQL
0 vote195 views1 answer
ACCEPT nome PROMPT on oracle
SQL
3 votes250 views2 answers
Oracle privileges users
SQL
1 vote247 views1 answer
How to get alternate records from a table in sql
SQL
1 vote192 views1 answer
Delete specific row in sql
SQL
0 vote181 views1 answer
Sql count null values in all columns
SQL
1 vote224 views1 answer
Postgresql update auto_increment value
SQL
24 votes198 views5 answers
List mysql users
SQL
1 vote243 views1 answer
Drop column if exists sql server
SQL
3 votes191 views2 answers
Sql random integer
SQL