Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Loader
Put this or something like this in your control file. It does not have to
be fixed width
date_field (xxx:yyy) date "YYMMDD"
In article <3699BE49.90E3FA9C_at_digest.com.pl>, gold_at_digest.com.pl says...
> > Hello,
> >
> > In my database which I must load into Oracle dates are stored as
> > compressed to 4-byte 6-digit numeric fields.
> > Is it possible to tell SQL*Loader, that "this field is decimal packed
> > and represents date in format YYDDMM" ?
> >
> > thanks,
> >
> > Grzegorz Goldian, gold_at_digest.com.pl, Grzegorz_Goldian_at_readersdigest.com
>
>
> Path: news.tpnet.pl!not-for-mail
> Message-ID: <3699BD3E.CB980BB3_at_digest.com.pl>
> From: Grzegorz Goldian <gold_at_digest.com.pl>
> X-Mailer: Mozilla 4.03 [en] (WinNT; I)
> MIME-Version: 1.0
> Newsgroups: comp.databases.oracle.tools
> Subject: SQL*Loader
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
> Date: Mon, 11 Jan 1999 08:53:04 GMT
> NNTP-Posting-Host: 212.244.204.100
> X-Complaints-To: abuse_at_tpsa.pl
> X-Trace: news.tpnet.pl 916044784 212.244.204.100 (Mon, 11 Jan 1999 09:53:04 MET DST)
> NNTP-Posting-Date: Mon, 11 Jan 1999 09:53:04 MET DST
> Organization: TPNET - http://www.tpnet.pl
> Xref: news.tpnet.pl comp.databases.oracle.tools:29354
>
> Hello,
>
> In my database which I must load into Oracle dates are stored as
> compressed to 4-byte 6-digit numeric fields.
> Is it possible to tell SQL*Loader, that "this field is decimal packed
> and represents date in format YYDDMM" ?
>
> thanks,
>
> Grzegorz Goldian, gold_at_digest.com.pl, Grzegorz_Goldian_at_readersdigest.com
>
>
>
>
Received on Mon Jan 11 1999 - 12:16:36 CST