Oracle error compilation 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

0 vote196 views1 answer
Show database not empty tables postgres
SQL
0 vote196 views1 answer
Jenkins SQLCMD run
SQL
2 votes174 views1 answer
Sql find missing values between two tables
SQL
0 vote194 views1 answer
Mysql workbench indent formatting
SQL
0 vote211 views2 answers
How to prevent sql injection in java
SQL
1 vote160 views1 answer
Python escape string for sql
SQL
3 votes204 views2 answers
Mysql import gz
SQL
25 votes201 views6 answers
How to change column name in mysql
SQL
0 vote151 views1 answer
Sql table to store status
SQL
0 vote203 views1 answer
How to get table current identity value in sql server
SQL