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

8 votes113 views1 answer
Oracle find text in functions
SQL
18 votes111 views3 answers
Mysql add column with default value
SQL
0 vote121 views1 answer
Trigger vérifier stock
SQL
2 votes117 views1 answer
Sqlite show table indexes
SQL
4 votes131 views1 answer
Sql quote in string
SQL
1 vote120 views1 answer
Mysql date diff in seconds
SQL
21 votes130 views6 answers
Update sql
SQL
0 vote115 views1 answer
Différence entre deux dates sql oracle
SQL
0 vote106 views5 answers
Sql table intermédiaire
SQL
5 votes116 views1 answer
Minecraft java port number
SQL