Oracle show errors

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 vote186 views1 answer
Updating database in sql
SQL
1 vote138 views1 answer
Mariadb alter user host
SQL
10 votes140 views5 answers
Between keyword in sql
SQL
0 vote148 views1 answer
Sql select random procentage from rows
SQL
13 votes139 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote139 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
0 vote133 views6 answers
Unique key in sql
SQL
0 vote152 views1 answer
Pl/pgsql declare variable
SQL
0 vote129 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote134 views1 answer
Tsql default value when no value returned by query
SQL