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

0 vote200 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
11 votes221 views2 answers
Set default column value sql
SQL
26 votes198 views2 answers
What is the sql statement that finds duplicate usernames
SQL
4 votes192 views1 answer
SQL order random
SQL
4 votes191 views2 answers
How to delete row in sql
SQL
0 vote219 views1 answer
Postgre query date
SQL
0 vote215 views1 answer
Datagrip execute procedure
SQL
0 vote208 views1 answer
Sql server count all tables rows
SQL
6 votes211 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote183 views1 answer
Opensuse stop MySQL
SQL