OraFAQ Forum: Server Utilities » SQL*Loader lowercase insert

Home » RDBMS Server » Server Utilities » SQL*Loader lowercase insert (SQL*Loader )

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

SQL*Loader lowercase insert [message #516403]

Sun, 17 July 2011 18:50

AngieT
Messages: 2
Registered: July 2011
Location: United States

Junior Member

Using Oracel SQL*Loader, is it possible to specify insert type statements? I need to know if i can pass a lower type call to a column. Specifically, if one of the entries is: username=MyUserName@gmail.com ... Then I need it to do the following lower(username) record inserts as myusername@gmail.com

Any help is greatly appreciated. I'm a bit stuck at the moment. Sad

I've googled and found LCase (), but I don't know if I'm barking up the wrong tree with that function. Thanks!

Report message to a moderator

Re: SQL*Loader lowercase insert [message #516404 is a reply to message #516403]

Sun, 17 July 2011 19:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

I do not understand what you have or what you want to achieve?
You do not provide sample file data, CREATE TABLE statement, or exact what you expect/desire in the table after it gets loaded.

Report message to a moderator

Re: SQL*Loader lowercase insert [message #516406 is a reply to message #516404]

Sun, 17 July 2011 20:21

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

Senior Member

Just use the following in your SQL*Loader control file:

username "lower (:username)"

Report message to a moderator

Re: SQL*Loader lowercase insert [message #516414 is a reply to message #516406]

Mon, 18 July 2011 00:40

AngieT
Messages: 2
Registered: July 2011
Location: United States

Junior Member

Thanks so much that was exactly what I was looking for!

Next time I post here I'll try to be more detailed and I'll include sample file data.

Thanks again.

Report message to a moderator

Previous Topic:	sequence
Next Topic:	how to use < > operators in WHEN clause sql *LOADER control file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 11:23:20 CDT 2024