Re: sqlldr & date/time question

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:<3ugm8ucsotfs6290c4s59vltomqbsekln4_at_4ax.com>...
> On 09 Mar 2002 22:34:08 GMT, ktyson9426_at_aol.com (KTyson9426) wrote:
>
> >Hello.... And thank you in adnvace for anyones help
> >
> >I want to use sqlldr to load the date/time into the same date field in my
> >table. I can get the date in there ok, and I can get the time in with the use
> >of a different field, but I can't find anything that tells me how to do get the
> >date/time in the same field. I've found how to do this with an 'insert'
> >statement, but I need to use sqlldr..... Can anyone tell me how to format the
> >*.ctl file? Currently I have;
> >
> >load data
> >infile *
> >append into table vmstat
> >fields terminated by ","
> >(ddate, ttime, vmstat)
> >begindata
> >30-Jan-02, 0122, 'data'
>
> Just specify an appropiate mask

He Wants to Concatenate The Fields ... Is there Anyway to do that in SQL LDR. Is Time and Date are in two different Fields in the DataFile how do u get it into one single field.

It would Be feasible if he uses a Temporary Table But If needs it only thru SQL Server is that possible.

>
> Please check out
> http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76955/ch05.htm#20660
>
> Hth
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

Regards,
Ganesh R Received on Mon Mar 11 2002 - 01:28:46 CST