Oracle show errors compilation

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 vote221 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote236 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
0 vote221 views1 answer
Mysql insert into select transaction c#
SQL
0 vote196 views1 answer
Optimize sql query
SQL
9 votes243 views3 answers
Pyodbc connect to sql server
SQL
3 votes191 views2 answers
Oracle sql truncate table
SQL
0 vote188 views1 answer
Java input type sql date
SQL
1 vote207 views2 answers
Sql where is not number
SQL
1 vote198 views1 answer
GROUP BY clause; this is incompati
SQL
1 vote196 views1 answer
Alphabetical order mysql
SQL