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 vote196 views1 answer
Convert varchar to int in sqlite
SQL
1 vote196 views1 answer
Mysql show queries running
SQL
0 vote196 views1 answer
Sql server user permissions and roles
SQL
0 vote185 views1 answer
Cast for print sql
SQL
4 votes194 views1 answer
Oracle show errors
SQL
0 vote197 views2 answers
Close external port 3306 with iptables
SQL
0 vote196 views1 answer
Google sheets filter rows above current cell
SQL
0 vote242 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
0 vote219 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
4 votes197 views2 answers
Oracle unlock user
SQL