Oracle error compilation 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

40 votes428 views4 answers
PostgreSQL add column
SQL
1 vote367 views1 answer
Mysql find most common value
SQL
2 votes366 views2 answers
Mysql on duplicate key update get value from values
SQL
0 vote365 views1 answer
Get last inserted primary key
SQL
9 votes339 views5 answers
Sql delete duplicate rows but keep one
SQL
2 votes323 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
2 votes368 views1 answer
Python sql
SQL
0 vote347 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote323 views1 answer
Mysql grant access to one database
SQL
0 vote303 views1 answer
Drop check command
SQL