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

0 vote323 views1 answer
Wordpress sql find and replace
SQL
0 vote362 views1 answer
Alter check command
SQL
0 vote343 views1 answer
MySQL - How to find word with the most similar beginning
SQL
4 votes354 views2 answers
Installing sql on ubuntu
SQL
0 vote335 views1 answer
Postgresql if else endif
SQL
0 vote401 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
0 vote321 views1 answer
Sql min
SQL
9 votes360 views6 answers
Replace sql
SQL
0 vote346 views1 answer
Trigger stock phpmyadmin output message
SQL
0 vote333 views1 answer
Why mysql is used?
SQL