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

2 votes194 views1 answer
Sqlite show table indexes
SQL
0 vote204 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
0 vote302 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
0 vote214 views1 answer
Mysql server not running
SQL
0 vote228 views1 answer
Sort by
SQL
2 votes309 views2 answers
Mysql compare datetime to another datetime
SQL
3 votes210 views1 answer
Oracle list invalid password ORA-01017
SQL
2 votes213 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote204 views1 answer
Sql case sttement with set
SQL
0 vote195 views1 answer
What are the aggregate function in sql
SQL