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

8 votes247 views2 answers
Phpmyadmin password
SQL
4 votes263 views3 answers
How to describe a table in sqlite3
SQL
0 vote260 views1 answer
Sql delete dastabase
SQL
1 vote269 views1 answer
Pgsql sum switch case
SQL
3 votes301 views5 answers
No module named 'MySQLdb'
SQL
1 vote276 views1 answer
How to use db.execute
SQL
12 votes267 views4 answers
Mysql ifnull
SQL
-1 vote265 views1 answer
Sql set max value in column
SQL
0 vote295 views1 answer
Sql quary intervewi question
SQL
0 vote286 views1 answer
Shrink database file in sql server
SQL