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 vote145 views1 answer
How to use update trigger in sql
SQL
25 votes152 views1 answer
Mysql grant all privileges to a user
SQL
2 votes146 views1 answer
Get first 2 letter in sql
SQL
0 vote159 views1 answer
Flexible search query delete table
SQL
0 vote188 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote200 views1 answer
How to check rollback status in oracle
SQL
47 votes242 views6 answers
Add column mysql
SQL
4 votes184 views1 answer
Ms sql truncate table vs delete
SQL
0 vote152 views1 answer
Oracle SQL join three tables and group by column
SQL
3 votes158 views3 answers
Stop mysql service ubuntu
SQL