Oracle show errors compilation

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 votes344 views1 answer
Mariadb select multiple rows into one column
SQL
0 vote359 views1 answer
Mysql count unique in group statement
SQL
0 vote351 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
6 votes386 views2 answers
Insert into select mysql
SQL
1 vote361 views4 answers
Sql now
SQL
16 votes377 views1 answer
Mssql int max value
SQL
0 vote334 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote391 views1 answer
How to install sql in anaconda
SQL
0 vote327 views1 answer
Format the money fied with comma in international system using sql
SQL
1 vote375 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL