Home » RDBMS Server » Server Utilities » Re: DB sequence in Sql*loader, not SEQUENCE function.....
Re: DB sequence in Sql*loader, not SEQUENCE function..... [message #368089] Tue, 14 March 2000 11:05 Go to next message
Cindy
Messages: 88
Registered: November 1999
Member
You need to specify the input record position
for the first field as starting in col 1:

LOAD DATA
INFILE infile.txt
APPEND INTO TABLE my_table
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY "'"
(
SEQ_ID "mysequence.nextval",
DELIVERY_ID POSITION(1) ,
ITEM_ID ,
)

And then your infile can still look like:

333,121
433,122
544,655

Cindy

Report message to a moderator

Re: DB sequence in Sql*loader, not SEQUENCE function..... [message #368090 is a reply to message #368089] Tue, 14 March 2000 11:12 Go to previous message
Kieron Smythe
Messages: 11
Registered: March 2000
Junior Member
Perfect.Thanks very much.

Kieron

Report message to a moderator

Previous Topic: Re: SQLldr Record delimeter
Next Topic: Re: oracle server
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Feb 01 07:32:05 CST 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.