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

3 votes223 views1 answer
Async await mysql nodejs
SQL
-1 vote230 views1 answer
How to Activate the database
SQL
1 vote224 views1 answer
Date in where on datetime column clause mysql
SQL
0 vote198 views1 answer
The local psql command could not be located
SQL
2 votes206 views1 answer
Datetrunc
SQL
3 votes200 views1 answer
Show index table
SQL
0 vote208 views1 answer
Plsql check for string in numeric
SQL
0 vote201 views1 answer
Sql get month and year from date
SQL
0 vote204 views1 answer
How to use group_concat in sql server
SQL
0 vote203 views1 answer
Display first three characters sql
SQL