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

3 votes272 views1 answer
Oracle get trigger ddl
SQL
2 votes324 views1 answer
Sql string starts with
SQL
0 vote296 views1 answer
Allow null in psql
SQL
0 vote283 views1 answer
Initcap in mysql
SQL
0 vote296 views1 answer
Mysql 8 geo to json
SQL
1 vote281 views1 answer
Sysdate in sql
SQL
0 vote274 views1 answer
Drop all tables db2
SQL
1 vote271 views1 answer
Sqlite3 read only
SQL
31 votes271 views1 answer
Postgresql add column with constraint
SQL
0 vote304 views1 answer
Alter domain sql
SQL