Re: SQL*LOADER and SYSDATE

I think you can. Use "sysdate+10".

Here is an example that calls a function but it could do the above.

LOAD DATA
APPEND
INTO TABLE attribute
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '|' (
 GUID "ATTRIBUTE_SEQ.NEXTVAL",
 SKU_GUID "get_sku_guid('BMC',:SKU_GUID,get_load_created_date)", ATTRTYPE_NAME,
 TEXT_VALUE
)

john kelly wrote:

> Is there a way to do the following in sqlloader for a date field
> date_toreview (sysdate + 10),
> or have a fixed value of a date added to this field. I've tried many
> different ways to get a date in the future loaded in this field for
> these records that I am trying to load and I keep getting SQL LOADER
> syntax errors.
> The file has to many records to manually update.
>
> Thanks in advance.
>
> John
Received on Wed Mar 17 1999 - 03:21:15 CST