Oracle error line

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 vote182 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
3 votes145 views2 answers
Update Query in SQL Server
SQL
8 votes157 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote170 views2 answers
How to see table associated with a schema in sql
SQL
5 votes140 views4 answers
Describe table postgres
SQL
5 votes150 views2 answers
Sql create tabel with primary key auto_increment code
SQL
18 votes189 views3 answers
Get the list of all tables in sql server
SQL
0 vote163 views1 answer
Oracle execute immediate quotes
SQL
1 vote160 views1 answer
Liquibase alter column type / length
SQL
1 vote152 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL