Home » SQL & PL/SQL » SQL & PL/SQL » About Upper case
About Upper case [message #239843] Wed, 23 May 2007 07:52 Go to next message
parasuramchekuri
Messages: 32
Registered: March 2007
Location: vishakapatnam
Member
hai
i ve table, all data have in lower case, my problem is
change the data in to the upper case
let me know the solution
thanks in advance...
Ram
Re: About Upper case [message #239845 is a reply to message #239843] Wed, 23 May 2007 07:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use the upper function.

Regards
Michel
Re: About Upper case [message #239846 is a reply to message #239843] Wed, 23 May 2007 07:56 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
A combination of UPDATE and UPPER might help. Wink

UPDATE yourtable SET yourcolumn = UPPER(yourcolumn)


MHE
Re: About Upper case [message #239847 is a reply to message #239843] Wed, 23 May 2007 07:57 Go to previous messageGo to next message
parasuramchekuri
Messages: 32
Registered: March 2007
Location: vishakapatnam
Member
hi Michale

i want to change old Data into Upper case, can i change
pls replay
thanks
Ram...


Re: About Upper case [message #239849 is a reply to message #239847] Wed, 23 May 2007 08:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read Maarten post.

Regards
Michel
Re: About Upper case [message #239850 is a reply to message #239847] Wed, 23 May 2007 08:08 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Clear answer already given by Maaher.
Re: About Upper case [message #239854 is a reply to message #239843] Wed, 23 May 2007 08:16 Go to previous message
parasuramchekuri
Messages: 32
Registered: March 2007
Location: vishakapatnam
Member
yes i got it
thanks once again to all
Ram...
Previous Topic: echo .
Next Topic: PROCEDURE HELP
Goto Forum:
  


Current Time: Sat Dec 03 11:55:05 CST 2016

Total time taken to generate the page: 0.08721 seconds