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 vote265 views1 answer
Check if database exists sql
SQL
0 vote271 views1 answer
Alter fedora mysql 8.0 user
SQL
0 vote265 views1 answer
Sql server system messeges
SQL
2 votes269 views1 answer
Mariadb JSON_EXTRACT
SQL
5 votes311 views1 answer
Mysql count lines
SQL
0 vote279 views1 answer
How to run mysql in git bash
SQL
17 votes273 views6 answers
MySQL ORDER BY
SQL
2 votes291 views1 answer
Oracle block
SQL
2 votes257 views6 answers
In in sql
SQL
0 vote276 views1 answer
Postgresql get diff between two dates in Months
SQL