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 vote195 views1 answer
Create database store
SQL
3 votes207 views1 answer
Pl sql escape &
SQL
0 vote200 views1 answer
Insert array into mysql column
SQL
0 vote183 views1 answer
Get records in sql according to month name and count
SQL
0 vote243 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
1 vote187 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
0 vote207 views1 answer
Clone table structure mysql
SQL
24 votes196 views5 answers
Sql server insert into select
SQL
0 vote193 views1 answer
Sql case when exists in another table
SQL
0 vote235 views1 answer
Combine 2 columns search query mysql
SQL