SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Intical Cap

OnenessboyJan 12 2012 — edited Jan 12 2012

Hi Experts,

To print 'initialcap' (not upper or lower) i wrote query something like below:

select upper(substr('oracle',1,1))||substr('oracle',2,max(length('oracle'))) from dual

is there any alternative command to get InitialCap functionality in simple way..

Best Regards
Prasanth

This post has been answered by VI on Jan 12 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 9 2012

Added on Jan 12 2012

7 comments

227 views