Oracle Database Discussions

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!

Skip and capture dirty Oracle SQL record from select statement

941744Feb 2 2016 — edited Feb 3 2016

I have Oracle 11.2.0.4 Oracle Database where i run a select query.

Issue:

10 columns have Date format data. When i try to run that query in TOAD it says , Not a valid month. Since records are billion in nature, I am not able to find out whihc row has this issue.

Is there any way i can capture the defaulter row and add it to some table and continue it with the select statement irrespective of that error

This post has been answered by EdStevens on Feb 2 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 2 2016

Added on Feb 2 2016

#general-database-discussions, #oracle, #sql

8 comments

537 views