OraFAQ Forum: SQL & PL/SQL » sqlldr: when clause

Home » SQL & PL/SQL » SQL & PL/SQL » sqlldr: when clause

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

sqlldr: when clause [message #113264]

Thu, 31 March 2005 22:33

kuul13
Messages: 8
Registered: March 2005

Junior Member

i want to restrict those rows which have 'Trailer Record' or '.' in CARRIER field. Something like

when carrier <> 'Trailer Record'
when carrier <> '.'

record layout
carrier, id, state
google, 12122, NY
jamees, 12332, CA
Trailer Record,,
.

want output records in table
google, 12122, NY
jamees, 12332, CA

what should be my when clause???

thanks in advance
sri

Report message to a moderator

Re: sqlldr: when clause [message #113286 is a reply to message #113264]

Fri, 01 April 2005 01:30

Barbara Boehmer
Messages: 9103
Registered: November 2002
Location: California, USA

Senior Member

load data
infile 'your_data_file.dat'
into table your_table
when carrier <> 'Trailer Record' and carrier <> '.'
fields terminated by ', '
trailing nullcols
(carrier, id, state)

Report message to a moderator

Re: sqlldr: when clause [message #113581 is a reply to message #113286]

Mon, 04 April 2005 13:53

kuul13
Messages: 8
Registered: March 2005

Junior Member

Thanks Barbara for your prompt answer. It worked for me but struck in another issue. I will post it as different topic. Thanks again.
Sri

Report message to a moderator

Previous Topic:	FOR loop - dumping value for each iteration
Next Topic:	DB links Issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 27 03:49:03 CST 2025