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

4 votes156 views2 answers
Mysql show indexes on table
SQL
0 vote208 views1 answer
Doctors appointment
SQL
3 votes178 views1 answer
What is having
SQL
3 votes178 views2 answers
Sql not contains
SQL
0 vote179 views1 answer
Reset postgres table index to next max value
SQL
0 vote171 views1 answer
Query builder doctrien return sql
SQL
3 votes169 views1 answer
Oracle user quota on tablespace
SQL
6 votes172 views2 answers
Mysql timestamp to date
SQL
0 vote157 views1 answer
Mysql procedure between two tables
SQL
4 votes178 views1 answer
Sql delete multiple conditions
SQL