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 vote135 views1 answer
Mysql_error replacement
SQL
5 votes143 views2 answers
Sql constraint check value in list
SQL
1 vote142 views1 answer
Mysql size int
SQL
7 votes124 views1 answer
Forge server hosting
SQL
1 vote150 views1 answer
How to show index type in postgresql
SQL
0 vote127 views1 answer
Get all employee of salary if more than in sql
SQL
15 votes136 views4 answers
Mysql where value is null
SQL
2 votes154 views1 answer
Sql missing records from another table
SQL
-1 vote146 views4 answers
Restart mysql server ubuntu
SQL
16 votes147 views3 answers
Jwt secret key generator laravel
SQL