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 vote164 views1 answer
USING THE NOT CONDITION IN SQL
SQL
1 vote202 views1 answer
How to select random rows from a table
SQL
3 votes186 views1 answer
Mysql cli connect with password
SQL
0 vote179 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
-2 votes205 views1 answer
Trunc in sql
SQL
0 vote148 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote162 views1 answer
Oracle sql add column auto generated value
SQL
0 vote181 views1 answer
Original Query
SQL
0 vote152 views2 answers
Mysql to python pandas
SQL
0 vote258 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL