Re: PL/SQL substr(instr oracle

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 20 Jun 2003 08:36:56 -0700
Message-ID: <92eeeff0.0306200736.f5ae063@posting.google.com>

wizofoz2k_at_yahoo.com.au (Nuno Souto) wrote in message news:<73e20c6c.0306192212.569341bd_at_posting.google.com>...
> Rauf Sarwar <member31517_at_dbforums.com> wrote in message news:<3023669.1056073455_at_dbforums.com>...

> No not at all, the outside replace is superfluous.
> Use the intentional space *before* the list of lowercase letters!
> As in ' abc...xyz'. Not 'abc...xyz'. That does the same as the replace.

Unless my brain is gone on vacation... this is not going to work. Try it for yourself. I believe this is the query you are referring to, I just added ) after -1 to make it run,

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

YC_C_I_M_C

Regards
/Rauf Sarwar Received on Fri Jun 20 2003 - 10:36:56 CDT