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

4 votes168 views4 answers
Date less than in sql
SQL
0 vote172 views1 answer
Get number of tables in database sql
SQL
0 vote228 views1 answer
Sqlite display data in separated columns
SQL
0 vote171 views1 answer
Sql server user permissions and roles
SQL
19 votes172 views6 answers
Mysql if null
SQL
28 votes191 views6 answers
Sql update
SQL
0 vote182 views1 answer
Foreign key multiple columns
SQL
0 vote211 views1 answer
Python dictionary to sql update
SQL
0 vote194 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote177 views1 answer
Mysql beautifier terminla
SQL