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 vote157 views1 answer
How to print longest name in sql
SQL
0 vote177 views1 answer
Check database restore status sql script
SQL
1 vote136 views1 answer
Select from one table where not on the other
SQL
17 votes204 views2 answers
How to assign date field for table in mysql
SQL
0 vote144 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
0 vote201 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
0 vote157 views1 answer
R write csv without index
SQL
0 vote147 views1 answer
Show the colums of table sql
SQL
0 vote141 views1 answer
Online sql testing tool
SQL
0 vote159 views1 answer
Import excel to sql
SQL