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

2 votes220 views6 answers
In operator in sql
SQL
0 vote226 views1 answer
Groupby sort sql hive
SQL
37 votes209 views3 answers
Duplicate records in sql
SQL
0 vote228 views1 answer
Sql join on a subquery
SQL
0 vote212 views1 answer
Execute sql stored procedure in powershell
SQL
2 votes164 views1 answer
Oracle current date without time
SQL
18 votes210 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
7 votes218 views3 answers
Sql fill table with info from anothe rtable
SQL
1 vote178 views1 answer
Restart identity postgresql
SQL
0 vote269 views1 answer
Insert query return id mysql
SQL