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

3 votes207 views2 answers
Savepoint in sql
SQL
2 votes141 views2 answers
Calculate percentage in sql
SQL
0 vote122 views1 answer
Sqlite explain plan
SQL
0 vote136 views1 answer
Oracle insert single quote in string
SQL
0 vote123 views2 answers
Oracle create chain rule
SQL
0 vote123 views1 answer
Sql get count without group by
SQL
2 votes141 views1 answer
Oracle percentage
SQL
2 votes119 views1 answer
Date_format for time sql
SQL
1 vote83 views1 answer
Ms sql how to see active job current run time
SQL
2 votes112 views1 answer
Mysql list users on ubuntu
SQL