Oracle show errors

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

10 votes262 views3 answers
How to fetch first 5 characters in sql
SQL
20 votes252 views2 answers
Mysql bigint max value
SQL
3 votes259 views1 answer
Mssql remove column
SQL
0 vote268 views2 answers
How to delete the rows with null values in mysql
SQL
1 vote255 views1 answer
Get url of cpanel database hostname
SQL
46 votes319 views4 answers
Create column sql
SQL
0 vote286 views1 answer
SQL Cut part string
SQL
0 vote255 views1 answer
Min and max salary and name in sql
SQL
0 vote348 views1 answer
How to check common records in 2 table
SQL
0 vote267 views1 answer
Mysql update table from select on another table
SQL