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

16 votes239 views2 answers
Add column to all tables after first column mysql
SQL
0 vote232 views3 answers
Group_concat sql server
SQL
0 vote265 views2 answers
Sql having multiple conditions
SQL
0 vote243 views1 answer
Alter fedora mysql 8.0 user
SQL
33 votes264 views6 answers
Sql delete
SQL
0 vote227 views1 answer
Truncate a table then insert data
SQL
0 vote270 views1 answer
Capabilities of sql select statements
SQL
0 vote218 views1 answer
Insert or update cassandra
SQL
-1 vote242 views1 answer
Concat two columns in sql server
SQL
2 votes234 views1 answer
Oracle drop table free up space
SQL