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

1 vote292 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
9 votes284 views1 answer
Alter table column change data type to text mysql
SQL
0 vote252 views1 answer
Remove from table where
SQL
20 votes267 views2 answers
Counting in sql
SQL
13 votes272 views6 answers
Current date sql
SQL
0 vote280 views1 answer
Mysql wait_timeout
SQL
3 votes258 views3 answers
Mysql select table names
SQL
7 votes268 views4 answers
Mysql delete older duplicates
SQL
0 vote259 views1 answer
MySql get primary keys of table
SQL
2 votes328 views3 answers
Sql delete duplicate
SQL