Oracle show errors compilation

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

14 votes193 views2 answers
Sql cast
SQL
4 votes181 views1 answer
Mac install mysql
SQL
0 vote191 views2 answers
Enter into postgresql database,create user and grant Access
SQL
11 votes202 views2 answers
How to import mysql database command line
SQL
-1 vote161 views2 answers
Datetime sql server week
SQL
0 vote254 views1 answer
Sql server query all database objects
SQL
-2 votes227 views3 answers
How to fetch first 10 rows in sql
SQL
-2 votes192 views2 answers
Sqlserver docker
SQL
0 vote180 views1 answer
Install package for sqlserver in asp.net core
SQL
0 vote188 views1 answer
Can we rollback data that are deleted using DELETE
SQL