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 vote319 views1 answer
Generate sql from specific migration ef core
SQL
12 votes271 views4 answers
Mysql version query
SQL
5 votes273 views3 answers
Mysql extract month from date
SQL
12 votes271 views2 answers
Delete entries in postgresql
SQL
0 vote273 views1 answer
Sql server size of every table in a db
SQL
1 vote275 views1 answer
Set statiscis on in ssms
SQL
0 vote305 views1 answer
Drop view in mysql
SQL
0 vote277 views1 answer
Sql select most frequent value in column
SQL
0 vote272 views1 answer
How to create a table in sql stack overflow
SQL
0 vote278 views1 answer
Mysql shell ERROR: Not connected.
SQL