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 vote273 views1 answer
How to check even or odd in sql
SQL
2 votes272 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
8 votes292 views2 answers
How to fetch data from database without last column
SQL
1 vote280 views1 answer
Decalre temp table sql
SQL
3 votes308 views2 answers
Oracle sql first day of month
SQL
0 vote262 views1 answer
How to update random rows in sql
SQL
0 vote315 views1 answer
How to find date from date table in sql
SQL
0 vote266 views1 answer
Minus equivalent in my sql
SQL
1 vote288 views1 answer
Mysql how to truncate table with foreign keys
SQL
0 vote282 views1 answer
Mysql regex select
SQL