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 vote162 views1 answer
Sql delimiter to columns
SQL
2 votes158 views1 answer
Insert from table tsql
SQL
8 votes173 views1 answer
Oracle create datafile
SQL
2 votes188 views2 answers
Postgres timestamp to datetime
SQL
0 vote171 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote176 views1 answer
Space not removing from column in sql
SQL
11 votes183 views1 answer
Sql insert multiple rows from select
SQL
0 vote178 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
0 vote192 views2 answers
Pl sql auto increment
SQL
4 votes181 views1 answer
Create db table
SQL