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

4 votes261 views2 answers
Oracle unlock user
SQL
0 vote294 views1 answer
Typical max-connect-errors mysql
SQL
0 vote276 views1 answer
Call object contructor and call methods of object
SQL
-1 vote219 views1 answer
Oracle db list usernames
SQL
0 vote237 views1 answer
Mysql select row with min date
SQL
4 votes250 views1 answer
Postgresql change default value
SQL
1 vote264 views1 answer
Postgresql how to show table names
SQL
0 vote267 views1 answer
PSQL use LIKE with timestamps
SQL
1 vote261 views1 answer
Rermove categories woocommerce sql
SQL
0 vote262 views3 answers
Database restoring error
SQL