| SQL*Loader [message #222469] |
Mon, 05 March 2007 00:24  |
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 |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
