Oracle error compilation line

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

2 votes282 views1 answer
How to show the whole table in sql
SQL
8 votes237 views8 answers
Second highest salary in mysql
SQL
0 vote271 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote313 views2 answers
How to install psql in ubuntu
SQL
4 votes267 views2 answers
Error loading MySQLdb module.
SQL
0 vote275 views1 answer
Mysql default uuid
SQL
0 vote282 views1 answer
Mysql backup certain tables workbench
SQL
15 votes513 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote316 views1 answer
Oracle chain step succeeded
SQL
0 vote285 views1 answer
Mariadb date equals to current_date plus days
SQL