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 vote341 views1 answer
Postgres add prefix to primary key
SQL
4 votes351 views1 answer
Sql delete where in select
SQL
0 vote351 views1 answer
Postgresql alter column nullable
SQL
0 vote371 views1 answer
Adding generated time in row mysql workbench
SQL
5 votes363 views1 answer
Oracle generate list of dates in between a date range
SQL
3 votes367 views2 answers
Postgres show table schema
SQL
0 vote357 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
0 vote449 views1 answer
Oracle simple quote
SQL
1 vote409 views1 answer
Postgresql if 0 then 1
SQL
1 vote330 views1 answer
Select random sample sql
SQL