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

0 vote202 views1 answer
How to use group_concat in sql server
SQL
4 votes224 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
4 votes241 views2 answers
Insert current date in mysql
SQL
0 vote217 views1 answer
How to combine rows in sql server procedure
SQL
17 votes217 views4 answers
Set mysql Password
SQL
1 vote253 views1 answer
Sql comment header
SQL
20 votes236 views4 answers
How to find average in sql
SQL
0 vote197 views1 answer
Connecting to my cloud sql server with c#
SQL
0 vote150 views1 answer
How to get last client id sql
SQL
0 vote666 views1 answer
How to connect .sql data set to powerbi
SQL