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

4 votes211 views1 answer
Describe table mysql
SQL
1 vote191 views2 answers
Mysql update table from another table
SQL
0 vote200 views1 answer
Clone table structure mysql
SQL
0 vote174 views1 answer
Sql gather statistics to increase performance
SQL
0 vote221 views1 answer
Como hacer un select entre fechas mysql
SQL
0 vote206 views2 answers
Sql server select first day of previous year
SQL
8 votes201 views2 answers
Grant all privileges database postgres to user
SQL
0 vote211 views3 answers
Join
SQL
0 vote190 views2 answers
Laravel: customize or extend notifications - database model
SQL
4 votes199 views2 answers
Mysql delete user if exists
SQL