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 vote406 views1 answer
Download sql file of countries names
SQL
0 vote356 views1 answer
Postgresql create query
SQL
0 vote375 views1 answer
Sql commands in android
SQL
0 vote403 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
1 vote336 views1 answer
Postgres format date in select
SQL
0 vote378 views1 answer
View psql output in horizontal scrolling
SQL
0 vote363 views1 answer
Alter boolean column postgresql
SQL
31 votes331 views3 answers
Sql count
SQL
0 vote322 views1 answer
Access refused mysql xampp server
SQL
0 vote351 views1 answer
Sql select most frequent value in column
SQL