Oracle error line

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

1 vote410 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote321 views1 answer
Postgresql subquery
SQL
0 vote322 views1 answer
Automate mysql cli query
SQL
0 vote332 views1 answer
How to find unique key in sql
SQL
1 vote330 views1 answer
Psql connect to another database
SQL
1 vote349 views1 answer
Join to find results not in another table
SQL
1 vote353 views1 answer
Right outer vs left outer join
SQL
2 votes367 views2 answers
Mysql alter column default
SQL
1 vote344 views1 answer
Pentaho + pasar de excel a sql
SQL
0 vote328 views1 answer
AddEntityFrameworkSqlite
SQL