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 vote211 views1 answer
Select top 3 sql
SQL
1 vote178 views1 answer
Psql connections
SQL
2 votes197 views1 answer
Oracle trace file
SQL
9 votes166 views2 answers
Mysql change value
SQL
1 vote170 views1 answer
Postgres grant read only access to database
SQL
0 vote202 views2 answers
Postgres isnull
SQL
0 vote175 views1 answer
Mysql 8 geo to json
SQL
0 vote180 views1 answer
Mysql order by rand limit 1 really slow
SQL
0 vote172 views1 answer
Subquery aggregation
SQL
5 votes131 views1 answer
Postgres upsert
SQL