OraFAQ Forum: Server Administration » sql loader and conditional statement

Home » RDBMS Server » Server Administration » sql loader and conditional statement

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sql loader and conditional statement [message #58397]

Sat, 23 August 2003 08:34

ram
Messages: 95
Registered: November 2000

Member

hi,

how i can give conditional statements in .ctl file using sql loader for bulk data loading.

Regards

Report message to a moderator

Re: sql loader and conditional statement [message #58407 is a reply to message #58397]

Mon, 25 August 2003 01:45

LT
Messages: 29
Registered: August 2003

Junior Member

Please be more specific, what do you mean conditional statements? What exactly are you trying to do?

Report message to a moderator

Re: sql loader and conditional statement [message #58443 is a reply to message #58407]

Tue, 26 August 2003 19:26

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

Check the below link...it may help u...

http://news.dcn-asu.ru/BOOKS/Oracle.Unleashed.Second.Edition/ch16/0384-0387.html

you can also do this using the WHEN Clause as follows

LOAD DATA
INFILE 'country1.txt'
INTO TABLE COUNTRY
WHEN CAPITAL_CITY = 'Y'
FIELDS TERMINATED BY ','
(COUNTRY_NAME,
LARGEST_CITY,
CAPITAL_CITY )

regards
sai

Report message to a moderator

Previous Topic:	how to move a table's tablespace
Next Topic:	current session information

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:43:03 CDT 2024