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 vote183 views1 answer
Migrations.RunSQL
SQL
3 votes165 views1 answer
Oracle sql commit example
SQL
0 vote126 views1 answer
Save single sql query result boolean spring boot
SQL
2 votes156 views1 answer
Sql percentage with % rounded down
SQL
10 votes138 views1 answer
Oracle view dependencies
SQL
4 votes144 views2 answers
Oracle set date format
SQL
0 vote99 views1 answer
How to connect sql server using ip address in c#
SQL
10 votes136 views6 answers
Mysql delete duplicates
SQL
0 vote178 views1 answer
Stop and start mysql
SQL
0 vote93 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL