Oracle error line

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 vote189 views1 answer
Set id count mysql
SQL
1 vote166 views1 answer
Alphabetical order mysql
SQL
5 votes187 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
50 votes184 views6 answers
Sql duplicate rows
SQL
1 vote149 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote136 views2 answers
Postgresql could not start server mac
SQL
0 vote183 views1 answer
Placements hackerrank solution
SQL
0 vote170 views1 answer
Select only one row sql
SQL
1 vote187 views3 answers
Nth highest salary
SQL
9 votes185 views3 answers
Where clause sql
SQL