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

10 votes192 views4 answers
Join with multiple conditions sql
SQL
5 votes202 views2 answers
Update all rows mysql
SQL
1 vote212 views1 answer
Alter constraint in sql
SQL
0 vote209 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote231 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote236 views1 answer
Sparql if bound query
SQL
0 vote292 views1 answer
SQL Server Altering Column to be Unique
SQL
0 vote217 views1 answer
Cannot pip install mysqlclient
SQL
0 vote198 views1 answer
Sql server remove enter from string
SQL
12 votes209 views2 answers
Delete all entries postgres
SQL