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 vote152 views1 answer
Postgresql filter on
SQL
8 votes142 views1 answer
Oracle search text in all packages
SQL
2 votes131 views6 answers
In in sql
SQL
0 vote121 views1 answer
Mysql regex exact match
SQL
-1 vote133 views1 answer
Condition in orderby mysql
SQL
0 vote88 views1 answer
How to set field to null in sql
SQL
0 vote125 views1 answer
Resulting Query
SQL
3 votes122 views1 answer
Sql select all
SQL
5 votes144 views3 answers
Sql server utc to local
SQL
19 votes135 views6 answers
What is mySQL
SQL