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

2 votes314 views1 answer
Enum in SQL Server
SQL
0 vote305 views1 answer
Sql python hwo to pass a list in paramerter
SQL
0 vote375 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
0 vote330 views1 answer
Replace content value from old to new sql
SQL
32 votes331 views6 answers
Insert into values select
SQL
17 votes340 views4 answers
Postgres list users
SQL
3 votes312 views2 answers
How to View column names of a table in SQL
SQL
1 vote352 views2 answers
Grab part of a string sql
SQL
2 votes326 views4 answers
Mysql select into new table
SQL
0 vote339 views2 answers
How to login to mysql as normal user in ubuntu
SQL