Oracle show errors

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 vote210 views1 answer
Restore backupfile discourse
SQL
0 vote215 views2 answers
Sql last updated
SQL
0 vote210 views2 answers
Sql if empty then
SQL
4 votes225 views2 answers
Oracle last day of month
SQL
0 vote245 views1 answer
Stratified sampling sql
SQL
0 vote209 views1 answer
Uncomment listen_address=localhost
SQL
0 vote224 views1 answer
Postgresql get diff between two dates in Months
SQL
1 vote216 views1 answer
Sql server epoch to datetime
SQL
0 vote222 views1 answer
Data directory postgresql
SQL
3 votes227 views1 answer
Oracle list user grants
SQL