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 vote206 views1 answer
Sql case sttement with set
SQL
3 votes235 views5 answers
No module named 'MySQLdb'
SQL
1 vote191 views1 answer
How to delete a record from sqlite in android
SQL
4 votes210 views2 answers
Postgre sql create table
SQL
2 votes192 views1 answer
Scaffold npgsql net core
SQL
1 vote306 views1 answer
Insert column after column mysql
SQL
0 vote194 views2 answers
Postgresql display subquery as json
SQL
0 vote208 views1 answer
How to put is null in where in clause
SQL
0 vote206 views1 answer
Postgresql update to unique
SQL
2 votes242 views2 answers
Convert_tz mysql
SQL