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 vote347 views1 answer
Import big data to mysql
SQL
-1 vote344 views1 answer
How to open blade file from blade in laravel
SQL
0 vote357 views1 answer
Select in select sql
SQL
0 vote337 views1 answer
How to to get current date and time in sql
SQL
3 votes359 views3 answers
C# sql select
SQL
0 vote408 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
1 vote363 views1 answer
Check current sequence value postgres
SQL
0 vote370 views1 answer
T-sql email validation
SQL
0 vote367 views1 answer
How to check which table has data in mysql
SQL
0 vote338 views1 answer
Implizite joins sql
SQL