Oracle show error line number

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 vote185 views1 answer
Sql server check whether column has same equal values
SQL
0 vote199 views2 answers
Oracle create tablespace autoextend
SQL
0 vote197 views1 answer
Exectuer myssql .sql
SQL
0 vote174 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
46 votes262 views4 answers
Create column sql
SQL
1 vote213 views1 answer
Raw query must include primary key
SQL
0 vote170 views1 answer
Knex last insert id mysql
SQL
0 vote190 views1 answer
Windows aggregate functions in postgresql
SQL
3 votes224 views1 answer
RENAME table pl sql
SQL
1 vote195 views1 answer
Mysql show data from table
SQL