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 vote116 views2 answers
Mysql disable foreign key checks
SQL
1 vote138 views1 answer
Mysql search like order by best match
SQL
0 vote136 views1 answer
Alter fedora mysql 8.0 user
SQL
1 vote126 views1 answer
Python escape mysql
SQL
1 vote122 views6 answers
In sql
SQL
4 votes130 views2 answers
Sql offset
SQL
1 vote149 views1 answer
Get current date in pyspark sql
SQL
0 vote139 views1 answer
No query unable to fetch row sqlite
SQL
0 vote146 views1 answer
Sql server pivot rows to columns
SQL
0 vote150 views1 answer
Sql_inner_join
SQL