Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Formatting time fields in SQL*Loader
hi
i cant understand your problem more specifically. Any way if you want to
load date field in to the table thro' sqlloader, querry the date field with
to_date option. i.e.,
SELECT a,TO_DATE(b),
FROM XXXX;
Now if you load into the table, the b field will be date datatype.
make sure the table is empty before loading
---palani
"News" <lesley_at_vimich.com> wrote in message
news:87q1e801163_at_enews3.newsguy.com...
> Hello everyone. I'm just learning Oracle and SQL*Loader and I'm in the
> middle of an import from dataease into Oracle 8i. I can't seem to find
> anything in the documentation about formatting time in my control file for
> SQL*Loader? Can I use DATE? If not, can I format time?
> Any suggestions are appreciated!
> Lesley
>
>
>
>
Received on Tue Feb 08 2000 - 21:18:41 CST