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 vote136 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote124 views1 answer
Search from comma separated values in sql server
SQL
0 vote133 views2 answers
Sql server set default value equal to auto increment
SQL
13 votes147 views3 answers
Sql select from multiple tables without join
SQL
0 vote83 views1 answer
Alter session set nls_language french
SQL
3 votes131 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
1 vote141 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
0 vote115 views1 answer
Install mysql 8 linux
SQL
0 vote126 views1 answer
Oracle string length
SQL
2 votes129 views2 answers
Create temporary table in mysql
SQL