Oracle error 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 vote208 views1 answer
How to find columns with null values in sql
SQL
25 votes183 views4 answers
Metadata
SQL
19 votes186 views6 answers
What is mySQL
SQL
2 votes203 views1 answer
Sql OR
SQL
1 vote187 views2 answers
Reset mysqli fetch_arra
SQL
0 vote201 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote182 views1 answer
Oracle drop default value
SQL
2 votes202 views1 answer
Add new column not null sql server
SQL
1 vote202 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
4 votes198 views1 answer
Oracle delete last row
SQL