need help with txt to oracle import
Date: Sat, 14 Dec 2002 13:34:09 +0800
Message-ID: <3dfabcf1_2_at_news.tm.net.my>
create table Indexs
alter session set NLS_DATE_FORMAT='<DD-MM-YY>';
( indate date not null constraint Index_Date_PK primary key,
indexs number(8,2) not null,
volume number(8,2) not null);
THESE ARE THE commands that i run before i import ... the text file context
is like below:
can anyone tell me how should i import them to my oracle ?
i've tried sqlldr , but it seems that my oracle does have it, it says
"SP2-0042: unknown command "sqlldr" - rest of line ignored."
using oracle8i (8.1.7) personal edition on winxp
thanks
Received on Sat Dec 14 2002 - 06:34:09 CET
29-06-00,830.2500, 237.0000
30-06-00,833.3700, 160.0000
03-07-00,793.9300, 104.0000
04-07-00,807.8700, 89.0000
05-07-00,818.6900, 95.0000
06-07-00,815.6800, 95.0000
07-07-00,820.4700, 135.0000
10-07-00,837.5900, 206.0000