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 votes290 views1 answer
For loop postgresql
SQL
0 vote302 views1 answer
Mysql case when on date
SQL
0 vote303 views1 answer
Oracle decode
SQL
0 vote280 views1 answer
Get last date join sql
SQL
0 vote280 views1 answer
Two inner joins sql
SQL
1 vote330 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
8 votes288 views3 answers
Alter user root mysql
SQL
7 votes248 views1 answer
Mysql load data infile csv
SQL
12 votes273 views2 answers
Delete entries in postgresql
SQL
1 vote302 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL