Skip to Main Content

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!

SQL Loader Control file

mjocasio23Jul 7 2024

I need to filter out a load using the when clause apply to a column datatype of date.

I need to check if the result check for weekday such as FRI.

AND TO_CHAR(TO_DATE('2024-01-01','YYYY-MM-DD')-7,'DY' = 'FRI'

getting an error…

Comments
Post Details
Added on Jul 7 2024
1 comment
172 views