Skip to Main Content
Forums

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!

Change case for Roman numerals

Saaz EnaNov 11 2009 — edited Nov 12 2009
Hi All,

I have Roman numerals with a char and want to chane the case. could someone please help me in solving this problem.
SQL> select nls_initcap('VIA PARC XVII BOH') name from dual;
 
NAME
-----------------
Via Parc Xvii Boh
The output is Via Parc Xvii Boh. but actually roman numerals like V, X MC, III should be in upper case. like Via Parc XVII Boh

Rgds
Saaz
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 10 2009
Added on Nov 11 2009
13 comments
1,661 views