| sqlldr input file help [message #109193] |
Tue, 22 February 2005 17:02 |
ghuebner
Messages: 2
Registered: February 2005
Location: Chicago
|
Junior Member |
|
|
I have created a csv form file the first column has several zeros infront of the number. Oracle is stripping off the leading zeros.
after control file is input through sqlldr it looks like
12345678
Create table test1(
SERIAL_NUMBER VARCHAR2(255) NOT NULL,
MODEL_NAME VARCHAR2(255) NOT NULL,
LOCATION VARCHAR2(255) NOT NULL,
HIST_DATE DATE NOT NULL,
Control file for sqlldr is
load data
infile 'c:\test\seialnumber.csv
append into table test1
FIELDS TERMINATED BY ','
(HIST_DATE DATE "DD-MM-YY",
SERIAL_NUMBER CHAR,
MODEL_NAME CHAR,
LOCATION CHAR
)
csv File
00012345678, test, CHICAGO,2/1/2005
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
