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

1 vote237 views1 answer
Last 6 months postgresql
SQL
0 vote234 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
3 votes238 views1 answer
Pl sql escape &
SQL
0 vote239 views1 answer
Query string starts with vowels
SQL
1 vote229 views1 answer
Count of tables in database mysql
SQL
0 vote243 views2 answers
How do I install microsoft SQL on my Mac?
SQL
16 votes239 views2 answers
Add column to all tables after first column mysql
SQL
0 vote249 views1 answer
Create table database in psql
SQL
0 vote234 views1 answer
Sql create table with references not primary key
SQL
0 vote241 views1 answer
Select amount weeks between two dates mysql
SQL