Home » Other » General » how to make first letter capital
how to make first letter capital [message #229573] Mon, 09 April 2007 03:08 Go to next message
sunsanvin
Messages: 60
Registered: April 2006
Location: Hyderabad
Member

Dear Experts,
while we are converting our sql server queries into oracle, we got one problem.

how can we make first letter of a perticular column capital?

Re: how to make first letter capital [message #229575 is a reply to message #229573] Mon, 09 April 2007 03:26 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Check out the INITCAP built-in. Wink

MHE
Re: how to make first letter capital [message #229679 is a reply to message #229575] Mon, 09 April 2007 12:58 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
would'nt initcap capitalize all the first letter of all words (instead of only the first word)?
Re: how to make first letter capital [message #229688 is a reply to message #229679] Mon, 09 April 2007 13:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, but the OP did not say there may be several words in its column values.
Re: how to make first letter capital [message #229721 is a reply to message #229688] Mon, 09 April 2007 20:45 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Use a pair of 'substr' statements. Do an 'upper' on the first character and concatenate all the other characters behind it.

David
Previous Topic: Arrange Schema Alphabetically in OEM Console
Next Topic: pricing
Goto Forum:
  


Current Time: Sun Dec 04 15:00:25 CST 2016

Total time taken to generate the page: 0.09996 seconds