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 vote196 views1 answer
Create table with timestamp mysql youtube
SQL
1 vote190 views1 answer
Get table which have specific columns in mysql
SQL
2 votes198 views1 answer
Ssh mysql port forwarding
SQL
8 votes179 views3 answers
Duplicate entry
SQL
1 vote192 views2 answers
Change table name phpmyadmin
SQL
0 vote222 views1 answer
Calculer pourcentage mysql
SQL
1 vote189 views1 answer
Postgres regex remove special characters
SQL
2 votes190 views1 answer
Postgresql add entry to table
SQL
0 vote202 views1 answer
Complete date is 1 year or not sql server
SQL
0 vote183 views1 answer
Mysql to get column name in database
SQL