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

1 vote202 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
0 vote206 views1 answer
Mysql function variable
SQL
0 vote263 views1 answer
Many rows to 1 string mysql
SQL
1 vote230 views1 answer
Mysql get latest duplicate rows
SQL
0 vote202 views1 answer
Char vs varchar2 in sql
SQL
0 vote203 views1 answer
Sql server select value large text
SQL
9 votes227 views2 answers
Oracle all tables in schema
SQL
10 votes225 views3 answers
Join multiple tables sql
SQL
0 vote248 views1 answer
Mysql bind-address default value
SQL
2 votes189 views1 answer
Update with join sql server
SQL