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?

Report message to a moderator

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: 7065
Registered: December 2001
Senior Member
Check out the INITCAP built-in. Wink

MHE

Report message to a moderator

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: 10707
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)?

Report message to a moderator

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: 68645
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.

Report message to a moderator

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: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 16:35:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.