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

2 votes328 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
0 vote304 views1 answer
Dnsmasq.conf location macos
SQL
1 vote292 views1 answer
Mysql collation
SQL
4 votes325 views2 answers
Mysql delete user if exists
SQL
6 votes309 views4 answers
Eloquent to sql with bindings
SQL
11 votes297 views2 answers
Sql between date range
SQL
0 vote312 views1 answer
Join in update query in mysql
SQL
0 vote354 views1 answer
FIND most frequent word in sql server
SQL
0 vote333 views1 answer
Apex for oracle 11g
SQL
-1 vote323 views1 answer
Mysql case when multiple conditions
SQL