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

1 vote106 views2 answers
Login to mysql
SQL
0 vote104 views1 answer
Postgres regex word boundary
SQL
2 votes97 views1 answer
Oracle index size calculation
SQL
0 vote100 views1 answer
Oracle job class
SQL
1 vote99 views4 answers
Get week day from date in sql
SQL
1 vote119 views2 answers
Select only columns that are not empty oracle sql
SQL
3 votes144 views1 answer
Apex call duration
SQL
1 vote100 views2 answers
Sql for date greater than
SQL
0 vote90 views1 answer
Get records in sql according to month name and count
SQL
6 votes90 views2 answers
Return columns from table sql
SQL