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 vote301 views2 answers
Mysql allow remote connections
SQL
1 vote308 views1 answer
Create another table from existing table sql oracle
SQL
0 vote279 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
0 vote306 views1 answer
Postgresql delete type
SQL
0 vote276 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote301 views1 answer
Sql delimiter to columns
SQL
0 vote274 views1 answer
Ms Sql set us timezone
SQL
0 vote293 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
0 vote325 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote287 views1 answer
How to put is null in where in clause
SQL