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

2 votes303 views4 answers
Duplicate record mysql
SQL
2 votes294 views2 answers
Mysql date range
SQL
0 vote320 views1 answer
T sql dynamic top n query
SQL
0 vote306 views1 answer
Ver usuarios mysql
SQL
2 votes324 views3 answers
Sql truncate table
SQL
3 votes295 views5 answers
Mysql get last inserted id
SQL
1 vote333 views3 answers
Epoch to datetime
SQL
0 vote315 views1 answer
Radius search with point data in mysql
SQL
11 votes274 views1 answer
Reset identity sql server
SQL
1 vote306 views1 answer
Too many connections mysql
SQL