Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL load problem

Re: SQL load problem

From: Kurt Krieger <kkriegerSPAM_at_erols.com.SPAM>
Date: Sun, 01 Oct 2000 14:23:13 GMT
Message-ID: <39D7491A.1E71BAA2@erols.com.SPAM>

I found the answer at
http://technet.oracle.com/doc/server.815/a67792/ch05.htm#20510 ...

LOAD DATA
INTO TABLE DATES (COL_A POSITION (1:15) DATE "DD-Mon-YYYY") BEGINDATA
1-Jan-1991
1-Apr-1991 28-Feb-1991

Kurt

sc wrote:

> I was trying to load data to a table, but the oraiginal data for the DATE
> column is like this:
> "1988269000000", and I always got error message that the format is not
> right, could someone tell me how to load this kind of data into the table?
>
> Thanks
Received on Sun Oct 01 2000 - 09:23:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US