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

3 votes167 views2 answers
Mysql select database
SQL
1 vote201 views1 answer
Postgresql pass array in function
SQL
0 vote147 views1 answer
Insert data from stored procedure into table
SQL
0 vote162 views1 answer
Interview experience as a call?
SQL
1 vote150 views1 answer
DATE_SUB postgres
SQL
3 votes164 views1 answer
Postgres select max value
SQL
0 vote146 views1 answer
Sql server port 1434
SQL
0 vote113 views1 answer
Mysql select top 2
SQL
0 vote168 views2 answers
Enter into postgresql database,create user and grant Access
SQL
0 vote215 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL