OraFAQ Forum: Server Administration » Data Storage in UPPERCASE

Home » RDBMS Server » Server Administration » Data Storage in UPPERCASE

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

Data Storage in UPPERCASE [message #55380]

Tue, 21 January 2003 22:57

Karthick Shrinivasan
Messages: 2
Registered: January 2003

Junior Member

Dear Sir,
I have a requirement on my development. When i enter data through forms, system should store the data in UPPERCASE, independent of data entry (Mixed/Lower/Upper Case). Is there is any Option in Oracle to enable this feature at the database level.
Can any one help on this.

Thanks and Regards,
S.Karthick

Report message to a moderator

Re: Data Storage in UPPERCASE [message #55387 is a reply to message #55380]

Wed, 22 January 2003 07:07

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

use the builtin function UPPER.
wrap the input to database with upper
SQL> ed
Wrote file afiedt.buf

  1* select loc,lower(loc),upper(loc) from dept
SQL> /

LOC           LOWER(LOC)    UPPER(LOC)
------------- ------------- -------------
NEW YORK      new york      NEW YORK
DALLAS        dallas        DALLAS
CHICAGO       chicago       CHICAGO
BOSTON        boston        BOSTON

Report message to a moderator

Previous Topic:	Oracle Installation problem on WIn2k
Next Topic:	Listener services failed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:55:25 CDT 2024