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

7 votes272 views2 answers
Execute mysql file
SQL
0 vote264 views3 answers
Group_concat sql server
SQL
0 vote261 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
0 vote223 views1 answer
Connection error in mysql workbench
SQL
1 vote266 views1 answer
Mysql query where in select
SQL
11 votes265 views1 answer
Ddl materialized view
SQL
0 vote266 views1 answer
What is default mysql database password in linux
SQL
2 votes258 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote279 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
2 votes258 views1 answer
Mysql time ago difference
SQL