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 vote359 views1 answer
To_date sql
SQL
6 votes352 views1 answer
Oracle desc table primary key
SQL
0 vote359 views1 answer
Leftjoin in sql
SQL
0 vote354 views1 answer
Sql tabelle erstellen
SQL
0 vote356 views1 answer
Oracle archivelog usage
SQL
0 vote373 views1 answer
Oracle table privileges
SQL
0 vote358 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote385 views4 answers
Get week day from date in sql
SQL
4 votes357 views2 answers
Insert current date in mysql
SQL
0 vote382 views1 answer
Connecting mySQL to STS
SQL