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 vote106 views3 answers
Mysql get age from date
SQL
0 vote117 views1 answer
Pl sql round
SQL
15 votes112 views7 answers
MYSQL
SQL
0 vote115 views1 answer
QUERY JPQL
SQL
1 vote132 views2 answers
Copy table in sql
SQL
0 vote106 views1 answer
Running query in redshift
SQL
0 vote120 views1 answer
Normalization in database 2nd normal form
SQL
0 vote126 views1 answer
Datatables server side filter where clause
SQL
2 votes163 views1 answer
Oracle block
SQL
4 votes139 views1 answer
Is there any command to change postgres password
SQL