Home » Applications » Oracle Fusion Apps & E-Business Suite » SQL*Loader
SQL*Loader [message #222469] Mon, 05 March 2007 00:24 Go to next message
discoverer
Messages: 30
Registered: January 2007
Member
I have a scenario in SQL*Loader.
Suppose u have a table T with a single column COL and
u also have a text file with data as follows
A
B
A
B
R
G
H
O
B
E
A
A
F
A
B
S
A


Now if u want to insert the rows containing 'A' into column COL
u use the following code

LOAD DATA
INFILE *
INSERT INTO TABLE T
WHEN COL='A'
(COL)
BEGINDATA
A
B
A
B
R
G
H
O
B
E
A
A
F
A
B
S
A


If u want to insert the rows containing 'B' along with 'A',how do u achieve this.

Thanks & Regards
Pavan.

[Updated on: Mon, 05 March 2007 00:25]

Report message to a moderator

Re: SQL*Loader [message #222545 is a reply to message #222469] Mon, 05 March 2007 06:47 Go to previous messageGo to next message
prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US
Senior Member
Do you want A & B only to be instered ??

give data of your result how you want it to be loaded?
Re: SQL*Loader [message #222676 is a reply to message #222545] Mon, 05 March 2007 21:53 Go to previous messageGo to next message
discoverer
Messages: 30
Registered: January 2007
Member
yes i want to insert rows that contain 'A' or 'B'.

Thanks & Regards
Pavan.
Re: SQL*Loader [message #222787 is a reply to message #222676] Tue, 06 March 2007 06:38 Go to previous messageGo to next message
prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US
Senior Member
try this

WHEN (COL = 'A') OR (COL = 'B')
Re: SQL*Loader [message #222945 is a reply to message #222787] Wed, 07 March 2007 00:42 Go to previous message
discoverer
Messages: 30
Registered: January 2007
Member
i tried it.But its not working.
Previous Topic: What is ADI
Next Topic: Other forums Oracle-eBusiness Suite
Goto Forum:
  


Current Time: Sun Dec 11 04:12:49 CST 2016

Total time taken to generate the page: 0.12493 seconds