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 votes263 views1 answer
Postgresql add entry to table
SQL
0 vote281 views1 answer
Check connections to database postgres
SQL
0 vote225 views1 answer
Mysql offset from bottom
SQL
0 vote260 views1 answer
Replace \n sql
SQL
19 votes281 views5 answers
Mysql between date range
SQL
1 vote260 views1 answer
Sample in sql
SQL
4 votes290 views3 answers
Employee name starting with in sql
SQL
0 vote270 views1 answer
Difference between db.query and db.execute
SQL
2 votes340 views2 answers
MySql FULL OUTER JOIN
SQL
0 vote314 views1 answer
Look at running processes redshift
SQL