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

0 vote283 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
19 votes271 views2 answers
Mysql add column after another
SQL
0 vote370 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote256 views1 answer
Sql python hwo to pass a list in paramerter
SQL
3 votes287 views2 answers
Find string in stored procedure sql server
SQL
31 votes275 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote276 views1 answer
Sql ignore
SQL
0 vote274 views1 answer
Sql server datetime to string
SQL
1 vote274 views1 answer
Moodle query first user access
SQL
0 vote283 views1 answer
How to get parent and child record in single query using sql
SQL