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 vote171 views1 answer
Group by two columns postgres
SQL
0 vote186 views1 answer
Max length found in mysql
SQL
3 votes178 views2 answers
Postgresql select all column names
SQL
56 votes325 views5 answers
Psql create user
SQL
1 vote256 views1 answer
Mysql get max value and id
SQL
0 vote178 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
0 vote182 views2 answers
Sql trigger difference between for and after
SQL
0 vote167 views1 answer
Sql find leading space
SQL
0 vote178 views1 answer
Postgres declare variable
SQL
0 vote178 views1 answer
Mysql db dump restore max file size issue
SQL