Oracle error line

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

20 votes135 views5 answers
Sql show tables
SQL
16 votes138 views3 answers
Delete row psql
SQL
3 votes182 views1 answer
Dbms_scheduler drop_job
SQL
0 vote100 views1 answer
Calculate discount from original price sql
SQL
1 vote205 views1 answer
Oracle transaction rollback not working
SQL
2 votes132 views2 answers
Change varchar length mysql
SQL
3 votes145 views1 answer
Get current month last date in sql server
SQL
9 votes137 views2 answers
Sql server check table exists
SQL
0 vote148 views2 answers
How to generate a unique random number in mysql
SQL
16 votes168 views6 answers
Python sqlite
SQL