Hi,

Why not just default the column to sysdate in the table definition.


Michael Peel

-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x35479483.[Email address protected]
Sent: 31 July 2007 12:47
To: LazyDBA Discussion
Subject: RE: BLANK DATE IN FILE SQLLOADER

Try:
time_loaded "to_char(SYSDATE, 'HH24:MI')"




Please take a few minutes to provide feedback on the quality of service you
received from our staff. The Department of Education values your feedback as
a customer. Commissioner of Education Jeanine Blomberg is committed to
continuously assessing and improving the level and quality of services
provided to you.Simply use the link below. Thank you in advance for
completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Shadab Mehboob
[mailto:oracledba-ezmlmshield-x85287875.[Email address protected]
Sent: Monday, July 30, 2007 7:54 PM
To: LazyDBA Discussion
Subject: BLANK DATE IN FILE SQLLOADER

Dear Masters
I am trying to load data through sql loader.
My input file has blanks at some places where the data type in the table
is of type DATE
How do i handle this in the sqlloader. I want to load system date
whenever the DATE filed is blank in the infile.
I have written the query as

load data
infile "filename.csv"
replace
into table table_name
fields terminated by ","
trailing nullcols
(
Field1 char,
Field2 "decode(:Field2, null,sysdate,:Field2)
)


Regards
Shadab


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


**********************************************************************
This e-mail is confidential and may be privileged.
It may only be read, copied and used by the intended recipient.
If you have received it in error please contact the sender immediately
by return e-mail. Please then delete the e-mail and any copies of it
and do not use or disclose its contents to any person.
**********************************************************************
Registered Office: Farncombe House, Broadway, Worcestershire, WR12 7LJ

AccuRead Limited Registered Number: 3076187 England
GSL UK Limited Registered Number: 3333860 England
Global Solutions Limited Registered Number: 3189802 England
**********************************************************************


Oracle LazyDBA home page