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 vote102 views1 answer
Mysql event last execution
SQL
0 vote107 views1 answer
Turn on foreign keys check mysql
SQL
0 vote115 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote100 views1 answer
Postgres : ERROR: division by zero
SQL
0 vote106 views1 answer
Sql select random procentage from rows
SQL
1 vote94 views1 answer
Sql restore backup query
SQL
0 vote97 views1 answer
Sql show all users
SQL
1 vote109 views1 answer
Get create table query existing table mysql
SQL
0 vote110 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote108 views1 answer
Mariadb mysql root access denied
SQL