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 vote335 views1 answer
Change default schema sql server
SQL
12 votes348 views4 answers
Mysql version
SQL
0 vote419 views1 answer
Delete ids between sql
SQL
1 vote357 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
2 votes357 views1 answer
How to delete view in sql
SQL
5 votes375 views2 answers
Postgresql insert select
SQL
4 votes356 views3 answers
How to describe a table in sqlite3
SQL
0 vote293 views1 answer
Update sql join multiple tables
SQL
0 vote381 views1 answer
Running mysql from bash sc
SQL
2 votes340 views1 answer
Possgress drop if exists table
SQL