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

3 votes311 views3 answers
Postgresql random number
SQL
14 votes304 views2 answers
Install mysqldump
SQL
7 votes296 views3 answers
Sql fill table with info from anothe rtable
SQL
6 votes275 views1 answer
To count number of rows in SQL table
SQL
0 vote322 views1 answer
Pl sql disable trigger
SQL
1 vote235 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
0 vote290 views1 answer
How to input data as id in database sql c#
SQL
22 votes312 views3 answers
Year format in date mysql
SQL
0 vote311 views1 answer
Get clob size oracle
SQL
0 vote321 views1 answer
Comparing with today and yesterday record in sql query
SQL