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 vote250 views1 answer
Check id exist or not in sql
SQL
0 vote317 views1 answer
My sql data file extention
SQL
1 vote293 views1 answer
Get url of cpanel database hostname
SQL
0 vote315 views1 answer
Restore backup mysql .gz
SQL
3 votes347 views1 answer
Oracle sql commit example
SQL
14 votes343 views4 answers
Sql compiler
SQL
2 votes294 views1 answer
Mysql cannot delete or update a parent row
SQL
3 votes308 views2 answers
Postgresql remove not null constraint
SQL
0 vote305 views2 answers
How to use aggregate functions in sql
SQL
13 votes318 views1 answer
Sql join 3 tables on id
SQL