Oracle error line

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

4 votes320 views1 answer
Force drop all tables postgres
SQL
1 vote308 views1 answer
Mysql server does not start mac
SQL
9 votes339 views2 answers
Sql server check table exists
SQL
0 vote329 views1 answer
Connect to ssms with python
SQL
0 vote361 views1 answer
Sql out file formate
SQL
1 vote338 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
35 votes379 views5 answers
Sql alter column
SQL
0 vote362 views10 answers
Sql statement checker corrector
SQL
4 votes361 views1 answer
Mysql query first character
SQL
0 vote300 views1 answer
Mysql group rows with same value
SQL