Re: PL/SQL substr(instr oracle

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: Mon, 23 Jun 2003 21:00:27 +1000
Message-ID: <3ef6de91$0$24424$afc38c87@news.optusnet.com.au>

"Eric Parker" <eric.parker.spamless_at_virgin.net> wrote in message news:qzAJa.2327$yw5.31172_at_newsfep4-glfd.server.ntli.net...
>
> I don't believe you need the 'replace', but then there was no spec.
>
> select substr('&STR',1,instr('&STR','_'))||
> translate(initcap(substr('&STR',instr(
> '&STR','_'))),'abcdefghijklmnopqrstuvwxyz'||'_',' ')
> from dual;
>

Well done!

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam

Received on Mon Jun 23 2003 - 06:00:27 CDT