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

0 vote226 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
1 vote230 views1 answer
Oracle sql create view
SQL
3 votes241 views1 answer
Async await mysql nodejs
SQL
0 vote231 views1 answer
Azure sql server check foreign key
SQL
1 vote219 views1 answer
How to check the mysql version mac
SQL
14 votes271 views6 answers
Finding duplicate rows mysql
SQL
34 votes267 views6 answers
Alter table add foreign key mysql
SQL
1 vote232 views1 answer
Pagination sql
SQL
0 vote241 views1 answer
Report in database
SQL
1 vote232 views1 answer
Mysql add fields
SQL