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

-1 vote294 views2 answers
Sql query examples
SQL
1 vote338 views1 answer
Backup mysql data only
SQL
1 vote330 views2 answers
Install mysqldump ubuntu
SQL
4 votes334 views1 answer
Mysql ip address data type
SQL
5 votes333 views2 answers
Oracle apex debug mode
SQL
0 vote321 views1 answer
Oracle drop default value
SQL
0 vote324 views3 answers
Sql select statements
SQL
0 vote309 views1 answer
Get duplicate entry sql
SQL
-1 vote361 views3 answers
Error: mysql shutdown unexpectedly.
SQL
0 vote274 views1 answer
Sqlalchemy existing database
SQL