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 vote348 views1 answer
UNION ALL LEFT JOIN
SQL
3 votes351 views2 answers
Oracle grants
SQL
0 vote347 views1 answer
Selecting Data in SQL - Select Data
SQL
0 vote341 views1 answer
Sequelize postgresql schema
SQL
0 vote405 views1 answer
Comparing with today and yesterday record in sql query
SQL
0 vote382 views1 answer
Sql express database size limit
SQL
1 vote356 views1 answer
Postgresql pass array in function
SQL
0 vote335 views1 answer
Ffeathers express mysql application users login
SQL
0 vote391 views1 answer
Insert using condition postgres
SQL
13 votes330 views2 answers
Display users in mysql
SQL