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 vote357 views1 answer
Sql server select furst day of current year
SQL
1 vote366 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
0 vote352 views1 answer
Postgresql inline table
SQL
42 votes437 views6 answers
Sql query duplicate rows
SQL
0 vote368 views2 answers
How do I install microsoft SQL on my Mac?
SQL
4 votes382 views3 answers
Sql drop database if exists
SQL
2 votes383 views1 answer
Revokeprivileges mysql
SQL
0 vote365 views1 answer
Désinstaller postgresql linux
SQL
4 votes344 views1 answer
To date oracle with time
SQL
1 vote372 views1 answer
Sql server: query to find out all the places where the table is used
SQL