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 vote366 views1 answer
Sql change column in existing table
SQL
0 vote361 views1 answer
Install mysql for fedora 34
SQL
0 vote355 views1 answer
Postgres select from values
SQL
3 votes357 views2 answers
Current year sql
SQL
0 vote335 views1 answer
Mysql default uuid
SQL
0 vote362 views1 answer
Mysql get date diff in months
SQL
-2 votes352 views1 answer
Mysql see users and passwords
SQL
0 vote357 views1 answer
Psql attribute cannot login
SQL
2 votes322 views1 answer
Username sql
SQL
1 vote375 views1 answer
Dropping a constraint in ms sql
SQL