Home » Other » General » sqlldr input file help
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

Previous Topic: How can i convert my Oracle Forms file ie., *.fmb or *.fmx file into *.exe file
Next Topic: Which is Worth ORACLE or .NET???????
Goto Forum:
  


Current Time: Sun Sep 26 22:25:37 CDT 2021