Oracle show errors

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

1 vote302 views1 answer
How to fetch alternate records from two tables
SQL
0 vote279 views3 answers
Convert sql query to python pandas
SQL
10 votes279 views2 answers
Sql merge statement
SQL
0 vote273 views6 answers
Unique key in sql
SQL
0 vote320 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
1 vote299 views2 answers
Begin transaction in sql
SQL
20 votes304 views6 answers
Mysql reset auto increment
SQL
0 vote313 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote297 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
0 vote263 views1 answer
Create table employees oracle
SQL