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 vote139 views2 answers
Create-toys-table-with-toy_name-column
SQL
5 votes124 views1 answer
Update sql user password
SQL
0 vote132 views1 answer
Mysql Digital Ocean connection problems
SQL
0 vote131 views1 answer
Sintaxis SELECT sql
SQL
1 vote179 views1 answer
Oracle transaction rollback not working
SQL
2 votes134 views1 answer
Mysql clear screen
SQL
1 vote133 views1 answer
Pl sql insert into table
SQL
10 votes165 views1 answer
Oracle all_dependencies
SQL
2 votes128 views1 answer
Oracle generated column
SQL
0 vote162 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL