Home » SQL & PL/SQL » SQL & PL/SQL » input large amount of old data and controling the case (upper/lower)
input large amount of old data and controling the case (upper/lower) [message #10306] Wed, 14 January 2004 03:53 Go to next message
Sandra Taylor
Messages: 10
Registered: October 2002
Junior Member
I'm using Oracle 9i. 

I'm creating a new application in Visual Basic with Oracle database that will replace an old application in MSAccess.  The old database has a LOT of data that is in mixed case.  I wonder if you know of a way to load the old data so that it will be in one case or the other.  I can control any new data as it goes in.

Thanks for any help you can give.

Sandra

Report message to a moderator

Re: input large amount of old data and controling the case (upper/lower) [message #10311 is a reply to message #10306] Wed, 14 January 2004 08:22 Go to previous message
sverch
Messages: 582
Registered: December 2000
Senior Member
SQL> select lower('Sandra') from dual;

LOWER('
-------
sandra

SQL> select upper('Sandra') from dual;

UPPER('
-------
SANDRA

SQL> select initcap('sandra') from dual;

INITCA
------
Sandra

SQL>

Report message to a moderator

Previous Topic: sql query problem
Next Topic: How to change table owner
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 10:34:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.