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

10 votes154 views2 answers
SQL rounding numbers
SQL
0 vote150 views1 answer
H2 auto increment and unique
SQL
9 votes162 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote220 views1 answer
Trigger
SQL
1 vote156 views1 answer
Events mysql
SQL
1 vote165 views2 answers
Oracle leftmost characters
SQL
0 vote191 views2 answers
Cascade syntax in sql
SQL
0 vote142 views1 answer
Date datatype in livesql
SQL
0 vote106 views2 answers
Sql query unique
SQL
0 vote160 views1 answer
Sub query in linq
SQL