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 vote100 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote106 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
1 vote91 views1 answer
Real world example of nosql
SQL
1 vote107 views1 answer
Postgres select as csv
SQL
53 votes267 views6 answers
Sql server alter column
SQL
0 vote106 views1 answer
Raiserror with nowait
SQL
0 vote106 views1 answer
Oracle swap partition
SQL
1 vote114 views1 answer
SQL Integer devision
SQL
2 votes104 views1 answer
Oracle kill session by sql_id
SQL
3 votes109 views3 answers
How to set up an auto incrementing id db browser
SQL