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 vote183 views1 answer
Duplicating a MySQL table with all the data Command
SQL
3 votes207 views3 answers
Raw select laravel
SQL
3 votes198 views2 answers
How to force truncate a table in mysql
SQL
15 votes177 views2 answers
Install mysql 8 ubuntu 18.04
SQL
0 vote173 views1 answer
Django mysqlclient connection string
SQL
0 vote185 views1 answer
Sql server query database space available
SQL
0 vote176 views1 answer
Sql server separar numeros por comas miles
SQL
0 vote188 views1 answer
Django mssql backend
SQL
0 vote184 views1 answer
Mac os zsh: command not found: mysql
SQL
6 votes202 views6 answers
Rename column postgres
SQL