Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SELECT ... IGNORE ERRORS ?

unpstepNov 6 2018 — edited Nov 6 2018

Hi,

This is probably a dumb question and I suppose a very old one, too ...

Is it possible to just ignore any ORA-Error in a select statement? Just return the valid records.

If not - why not?

I know about "LOG ERRORS" for DML statements - but I'm not interested in what kind of errors appear nor do I want to make any DML. Just a plain select ignoring any and all errors.

thanks,

stephan

Comments
Post Details
Added on Nov 6 2018
19 comments
5,055 views