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

15 votes172 views3 answers
Find duplicate keys in mysql
SQL
0 vote238 views1 answer
Mysql readable output
SQL
10 votes174 views3 answers
Sql check double value
SQL
0 vote167 views3 answers
ChAnge TABLE name apex oracle
SQL
3 votes160 views1 answer
What is having clause
SQL
0 vote273 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote156 views1 answer
Oracle tablespace autoextend
SQL
0 vote158 views1 answer
Stuff in sql server
SQL
0 vote161 views1 answer
Coalesce for comma separated in sql server
SQL
3 votes213 views2 answers
Wp do sql query from function
SQL