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

2 votes182 views1 answer
Sql as
SQL
0 vote184 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
0 vote206 views1 answer
Mysql streaming example
SQL
0 vote193 views1 answer
Trigger vérifier stock
SQL
0 vote175 views1 answer
Mysql return column names when table is empty
SQL
6 votes563 views3 answers
Sql select last id
SQL
0 vote198 views2 answers
Mysql show foreign keys
SQL
4 votes134 views1 answer
And or sql order of operations
SQL
0 vote180 views1 answer
UNION ALL LEFT JOIN
SQL
0 vote197 views1 answer
Time data type in mysql
SQL