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

0 vote328 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
1 vote352 views1 answer
Psql connections
SQL
0 vote341 views1 answer
How to input data as id in database sql c#
SQL
0 vote338 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
4 votes364 views1 answer
List tables sqlite
SQL
3 votes345 views1 answer
Select sequence oracle
SQL
0 vote349 views1 answer
T-SQL Create Trigger
SQL
0 vote355 views1 answer
Kill mysqld_safe process mariadb
SQL
0 vote364 views1 answer
Oracle to_number
SQL
-1 vote307 views2 answers
How to display top 50 rows?
SQL