| how to use sqlloader in a routine [message #7761] |
Mon, 07 July 2003 04:10  |
poncet
Messages: 2
Registered: July 2003
|
Junior Member |
|
|
i have a script to load a fole to a table with a delimeter ';' :
LOAD DATA
INFILE 'e:LabProductionImport_DonneesLabProd_CSVunite.csv'
REPLACE
INTO TABLE RefUnite
Fields terminated by ";" OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
CoDunite CHAR,
LIBunite CHAR,
IndActif INTEGER EXTERNAL
)
My file unite.csv :
UI;Unités Internationales 111;1
MeqL;MilliEquivalent par litre;1
i created a trigger and a sequence to create a number automaticly 1,2,...
My table (cleunite number(10),
codunite varchar2(10),
libunite varchar2(64),
indactif number(1))
How can i use this script in a routine ?????
thank you
Touria
Phylum
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
