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 vote271 views1 answer
Sql server current time without date
SQL
0 vote292 views1 answer
Sql server system messeges
SQL
10 votes189 views5 answers
Mysql create user
SQL
0 vote206 views1 answer
Mysql master slave setup with keepalived
SQL
1 vote196 views1 answer
Woocommerce mysql price table
SQL
0 vote213 views1 answer
Oracle calculate statistics on partition
SQL
2 votes202 views4 answers
Check timezone of mysql database
SQL
0 vote200 views1 answer
Sql select duplicates based on two columns
SQL
0 vote197 views1 answer
Run postgresql dump to csv
SQL
3 votes291 views2 answers
Mysql user permission database
SQL