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

11 votes316 views2 answers
Sql between date range
SQL
0 vote328 views1 answer
Find most frequent value in SQL column
SQL
-1 vote354 views3 answers
How to restart mysql in linux
SQL
0 vote328 views1 answer
How to put is null in where in clause
SQL
18 votes320 views2 answers
Sql inner join
SQL
0 vote340 views1 answer
Sql convert datetime to year
SQL
0 vote339 views1 answer
Subquery aggregation
SQL
58 votes577 views4 answers
Mysql drop column
SQL
2 votes360 views1 answer
Sql as
SQL
2 votes337 views1 answer
Oracle list grants on package
SQL