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

3 votes114 views1 answer
Sql cast to integer
SQL
0 vote117 views1 answer
Mysql pv progres
SQL
0 vote120 views1 answer
Wordpress sql find and replace
SQL
0 vote113 views1 answer
Logtash mysql cofiguration file
SQL
0 vote102 views1 answer
Docker export psql sql
SQL
0 vote124 views1 answer
Python sqlalchemy connection show server
SQL
0 vote97 views1 answer
Dnsmasq.conf location macos
SQL
0 vote122 views4 answers
What is unique key in sql
SQL
5 votes111 views1 answer
Sql integer to serial
SQL
0 vote113 views1 answer
SQL Server Enterprise
SQL