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

51 votes292 views6 answers
Opera gx
SQL
0 vote185 views1 answer
Comparing with today and yesterday record in sql query
SQL
-1 vote203 views1 answer
Mysql delete duplicate rows except one
SQL
8 votes182 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote177 views1 answer
Show create table in postgresql
SQL
0 vote198 views1 answer
Query to remove duplicate rows from a table
SQL
0 vote217 views1 answer
Sql select rows with different values in one column
SQL
0 vote190 views1 answer
Get substract count sql
SQL
12 votes269 views4 answers
How to drop all tables in postgresql
SQL
3 votes185 views1 answer
Async await mysql nodejs
SQL