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 vote125 views1 answer
Mysql join only one column
SQL
2 votes104 views2 answers
Sql strip non alphanumeric characters
SQL
10 votes101 views1 answer
Oracle view dependencies
SQL
0 vote95 views3 answers
Postgres trim string
SQL
0 vote103 views1 answer
Oracle call a function in a insert statement
SQL
0 vote95 views1 answer
Mysql server not starting in xampp in mac
SQL
0 vote114 views1 answer
Postgresql linux password
SQL
0 vote111 views1 answer
Oracle search in date columns
SQL
0 vote105 views1 answer
Import sql in postgresql
SQL
0 vote109 views2 answers
Sql query for getting details by id
SQL