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 vote238 views1 answer
Raise application error in oracle
SQL
1 vote228 views1 answer
Access the postgres psql
SQL
0 vote230 views1 answer
Incorrect datetime value sql table error 1292
SQL
3 votes220 views1 answer
Sql server check version
SQL
0 vote213 views1 answer
Sql offfset
SQL
0 vote220 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
0 vote238 views1 answer
Select top values sql
SQL
3 votes232 views1 answer
Oracle apex warn on unsaved changes
SQL
1 vote247 views1 answer
Mysql connect bash
SQL
0 vote180 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL