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 vote120 views2 answers
Call to undefined function mysql_query()
SQL
2 votes107 views1 answer
How to insert string variable into sqlite database
SQL
-1 vote93 views2 answers
How to select the lowest values from table per client sql
SQL
3 votes119 views1 answer
Where id is in list sql
SQL
1 vote96 views1 answer
Select random sample sql
SQL
0 vote106 views1 answer
Selecting duplicates
SQL
0 vote103 views2 answers
Tsql row number
SQL
0 vote121 views2 answers
Check if sql temp table exists
SQL
0 vote96 views1 answer
Mysql table variables
SQL
15 votes113 views5 answers
Select all tables sql
SQL