Re: PL/SQL substr(instr oracle

rs_arwar_at_hotmail.com (Rauf Sarwar) wrote in message news:<92eeeff0.0306181306.1bf89859_at_posting.google.com>...
>
> I am sure this can be done easily in PL/SQL but it's fun doing it in
> SQL -:)
>

Oh come on!
What's all that uppercase/lowercase list of all the letters for?

This is much simpler:

select
substr('&STR',1,instr('&STR','_')-1)||
replace(translate(initcap(replace(substr('&STR',instr('&STR','_')), '_',' ')),'abcdefghijklmnopqrstuvwxyz',' '),' ','_') from dual;

:D)))

PS: Great use of functions in Oracle! Eat your heart out, DB2/commoncodebaseUDB/SQL Server crap!

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Thu Jun 19 2003 - 17:19:38 CDT