Oracle error compilation 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

1 vote168 views1 answer
Oracle user last connection date
SQL
3 votes140 views1 answer
How to remove characters from string in mysql
SQL
0 vote157 views1 answer
Get who is hired in february in sql
SQL
1 vote153 views1 answer
Postgres get month name from date
SQL
0 vote159 views1 answer
Creating a simple notify in postgresql
SQL
0 vote158 views1 answer
Psql generate id in existing database
SQL
0 vote138 views1 answer
Sql server inner join convert collation
SQL
2 votes173 views1 answer
Oracle trace file
SQL
1 vote143 views1 answer
Base nosql
SQL
0 vote137 views1 answer
Ms sql database data size
SQL