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

10 votes285 views1 answer
Oracle view dependencies
SQL
0 vote339 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
1 vote325 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote334 views1 answer
Mysql insert into select transaction c#
SQL
4 votes321 views3 answers
NOT NULL SQL
SQL
0 vote344 views1 answer
How to delete duplicate rows in oracle
SQL
1 vote327 views1 answer
Sql first
SQL
1 vote320 views1 answer
Sql trigger before delete
SQL
1 vote321 views1 answer
Pv mysql import
SQL
2 votes320 views2 answers
Mysql show table column comments sql
SQL