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

1 vote117 views1 answer
Sql string function update replace
SQL
0 vote108 views1 answer
Get all employee of salary if more than in sql
SQL
0 vote129 views1 answer
Regex any word except sql
SQL
6 votes110 views6 answers
Count mysql
SQL
0 vote113 views2 answers
Sql update top 100
SQL
0 vote124 views1 answer
Sql script to remove default from column
SQL
0 vote152 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote116 views1 answer
Oracle current timestamp insert statement
SQL
1 vote124 views1 answer
Table valued functions in sql
SQL
2 votes109 views1 answer
SQL IF ELSE
SQL