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

8 votes135 views1 answer
Similarities between ddl and dml
SQL
0 vote174 views1 answer
How to connect postgresql database with java
SQL
0 vote191 views1 answer
Sqlalchemy empty table
SQL
4 votes196 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
7 votes188 views5 answers
Oracle alter table
SQL
1 vote180 views1 answer
Base nosql
SQL
0 vote175 views1 answer
How to check replication lag in mySQL
SQL
3 votes172 views1 answer
Oracle undo tablespace list by user
SQL
0 vote210 views1 answer
Dual in db2
SQL
7 votes180 views3 answers
Sql fill table with info from anothe rtable
SQL