Oracle show error line number

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

4 votes322 views1 answer
Delete record mysql query
SQL
1 vote321 views2 answers
Mysql type conversion
SQL
3 votes386 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
0 vote380 views1 answer
Sql cursor example multiple columns
SQL
0 vote323 views1 answer
Can we rollback data that are deleted using DELETE
SQL
1 vote312 views1 answer
Primary key reset in SQL database
SQL
7 votes334 views3 answers
Restore postgres database from sql file
SQL
0 vote347 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
25 votes333 views6 answers
Sql update query
SQL
0 vote326 views1 answer
T-SQL - Where Used List (Table/View)
SQL