Oracle show error line number

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

7 votes108 views6 answers
Nth highest salary in sql
SQL
1 vote106 views1 answer
What is intersect
SQL
0 vote151 views1 answer
Do you know sql
SQL
0 vote110 views1 answer
Postgresql if else endif
SQL
5 votes114 views3 answers
Mysql remove unique constraint
SQL
0 vote113 views1 answer
Getting next sequence value jpa postgress
SQL
0 vote109 views1 answer
Sql get number of days between two dates
SQL
0 vote103 views1 answer
Postgresql update to unique
SQL
0 vote112 views2 answers
Sql use not in
SQL
0 vote111 views1 answer
Postgresql get diff between two dates in Months
SQL