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

1 vote178 views1 answer
Drop colum oracle 18c
SQL
1 vote142 views1 answer
Sql not equal multiple columns
SQL
3 votes148 views2 answers
Sql asc
SQL
0 vote208 views1 answer
Osm2pgsql mac
SQL
54 votes359 views6 answers
Sql rename column
SQL
0 vote137 views1 answer
Selecting Data in SQL - Select Data
SQL
0 vote154 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote162 views1 answer
Mysql regex select
SQL
0 vote146 views1 answer
Oracle sql winter time change
SQL
23 votes180 views2 answers
Query to delete a database in mysql
SQL