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 vote236 views2 answers
How to know the character set of an oracle databes
SQL
19 votes255 views3 answers
Grant mysql
SQL
4 votes232 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote226 views2 answers
Php convert dbf to mysql
SQL
-1 vote247 views1 answer
Phinehas Psalm 106
SQL
1 vote225 views1 answer
Create sqlite database in laravel
SQL
1 vote223 views2 answers
Sql select only first occurrence
SQL
0 vote259 views1 answer
Mysql order by rand limit 1 really slow
SQL
0 vote233 views2 answers
How to create a table from another table in sql derby
SQL
1 vote208 views1 answer
Find logged in users mysql
SQL