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

0 vote344 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote361 views1 answer
Mysql sum with group by
SQL
0 vote387 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
1 vote351 views2 answers
Mysql error 1215
SQL
1 vote336 views1 answer
Mysql find tables with column name
SQL
0 vote351 views1 answer
Mysql pad zeros
SQL
1 vote357 views1 answer
How to between in sql
SQL
0 vote341 views1 answer
Raiserror nowait sql server
SQL
3 votes434 views1 answer
Apex call duration
SQL
2 votes359 views1 answer
Power query concatenate
SQL