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

0 vote196 views1 answer
Resulting Query
SQL
0 vote220 views1 answer
Hour differeence in mysql
SQL
11 votes197 views3 answers
Sqlite3 create table from another table
SQL
0 vote197 views1 answer
Output table plsql
SQL
2 votes210 views1 answer
Get hour from date sql
SQL
0 vote225 views2 answers
Sql query print strings and int
SQL
0 vote205 views1 answer
Create user faunadb
SQL
0 vote284 views1 answer
Postgressql uuid
SQL
5 votes242 views2 answers
Functions
SQL
15 votes206 views5 answers
If null mysql
SQL