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 vote122 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
1 vote122 views1 answer
Oracle sql pad left zeros
SQL
4 votes110 views1 answer
Postgres delete last row
SQL
0 vote168 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
3 votes108 views2 answers
Tsql join multiple record in one string
SQL
0 vote151 views1 answer
Postgresql find biggest table
SQL
0 vote115 views1 answer
Exit psql
SQL
0 vote112 views1 answer
Jenkins SQLCMD run
SQL
1 vote108 views1 answer
Sql run multiple updates in one query
SQL
0 vote109 views1 answer
Flask sqlalchemy. commit does not save changes
SQL