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

0 vote306 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
3 votes331 views1 answer
Null sql
SQL
0 vote321 views1 answer
Oracle list proxy users
SQL
1 vote310 views1 answer
Oracle list datafiles in tablespace
SQL
4 votes326 views1 answer
T-sql get duplicate rows
SQL
1 vote313 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote322 views1 answer
Placements hackerrank solution
SQL
0 vote320 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote323 views1 answer
Alter owner in PostgreSQL
SQL
0 vote320 views2 answers
Close external port 3306 with iptables
SQL