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 vote208 views1 answer
How to install Firebird
SQL
36 votes218 views3 answers
Add column in mysq
SQL
4 votes185 views1 answer
Sql group by year
SQL
0 vote198 views1 answer
Postgresql heritage
SQL
3 votes366 views6 answers
Sql unique select
SQL
0 vote193 views1 answer
Dns slave zone convert
SQL
0 vote249 views1 answer
How to pass list as parameter in SQL query
SQL
1 vote232 views2 answers
How to add amount between date in sql
SQL
1 vote224 views1 answer
Sql and
SQL
0 vote198 views1 answer
Oracle current timestamp insert statement
SQL