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 vote109 views1 answer
Turnicate in mysql
SQL
4 votes105 views1 answer
Check database name postgresql
SQL
6 votes110 views2 answers
How to get yesterday date in mysql
SQL
0 vote117 views1 answer
Oracle concat datetime
SQL
1 vote114 views1 answer
Convert varchar to int in sqlite
SQL
1 vote105 views1 answer
Store select query result in variable sql server
SQL
0 vote109 views1 answer
Cross apply top for each row t1
SQL
4 votes109 views2 answers
Xampp mysql database server is not starting mac m1
SQL
0 vote107 views1 answer
Java mysql date format
SQL
-1 vote120 views1 answer
Mysql select all columns and specific fields as
SQL