Home » RDBMS Server » Server Utilities » SQL*Loader lowercase insert (SQL*Loader )
icon5.gif  SQL*Loader lowercase insert [message #516403] Sun, 17 July 2011 18:50 Go to next message
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!
Re: SQL*Loader lowercase insert [message #516404 is a reply to message #516403] Sun, 17 July 2011 19:29 Go to previous messageGo to next message
BlackSwan
Messages: 23146
Registered: January 2009
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.
Re: SQL*Loader lowercase insert [message #516406 is a reply to message #516404] Sun, 17 July 2011 20:21 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8024
Registered: November 2002
Location: California, USA
Senior Member
Just use the following in your SQL*Loader control file:

username "lower (:username)"
Re: SQL*Loader lowercase insert [message #516414 is a reply to message #516406] Mon, 18 July 2011 00:40 Go to previous message
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.
Previous Topic: sequence
Next Topic: how to use < > operators in WHEN clause sql *LOADER control file
Goto Forum:
  


Current Time: Thu Dec 18 18:05:53 CST 2014

Total time taken to generate the page: 0.08516 seconds