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 vote338 views1 answer
Sql last 3 rows
SQL
0 vote309 views1 answer
Why mysql is used?
SQL
0 vote333 views1 answer
Sql ignore
SQL
0 vote321 views1 answer
How to export only procedures mysql
SQL
0 vote405 views1 answer
Scheduled mysql database backup in linux
SQL
0 vote298 views1 answer
Wordpress sql find and replace
SQL
0 vote318 views1 answer
Database get 10 user aleatory
SQL
0 vote311 views2 answers
What is 1=2 in sql
SQL
6 votes338 views1 answer
Oracle pl sql source
SQL
3 votes331 views1 answer
Oracle failed login attempts
SQL