Home » RDBMS Server » Server Utilities » Load data of choice
icon9.gif  Load data of choice [message #111777] Sat, 19 March 2005 23:51 Go to next message
vivekmenon4u
Messages: 1
Registered: March 2005
Location: India
Junior Member
I have a text file containing data terminated by comma and the last column being null

eg:91456,test,mumbai, ,

I need to load these data into a table, but i just want the first 3 columns to be loaded.how can this be done.

Regards
Vivek

Report message to a moderator

Re: Load data of choice [message #111829 is a reply to message #111777] Mon, 21 March 2005 03:44 Go to previous message
sridcpp
Messages: 23
Registered: February 2005
Location: India
Junior Member
load data
infile *
replace
into table tablename
( col1 position (01:05) char(4),
col2 position (06:12) char(20)
)

Report message to a moderator

Previous Topic: Sqlldr NVL Direct Load
Next Topic: sqlldr return code in Windows platform ...
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 25 18:34:54 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.