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

0 vote331 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote315 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote291 views1 answer
Call procedure in wordpress
SQL
0 vote284 views1 answer
Time mysql w3
SQL
0 vote309 views2 answers
How to take recent row without limit in mysql
SQL
2 votes287 views2 answers
How to get capital letter first in sql
SQL
1 vote306 views1 answer
Sql order by where condition
SQL
5 votes275 views1 answer
How to check nls timestamp format in oracle
SQL
1 vote295 views1 answer
Get last week data in mysql
SQL
12 votes341 views6 answers
Change mysql root password
SQL