Re: PL/SQL substr(instr oracle

Brian Peasland wrote:

> You probably won't be able to do this in a simple SQL statement. Most
> likely, you'll have to use some PL/SQL and loop through the string and
> parse it as you go.
>
> Cheers,
> Brian
>
> Pal wrote:
> >
> > Hi
> >
> > can some one help to write a sql where I can extract string from the
> > field like this
> >
> > YC_CHOICE_IS_MY_CHOICE
> >
> > YC_CIMC
> >
> > SP_786_at_YAHOO.COM
> >
> > THANK YOU IN ADVANCE
>
> --
> ===================================================================
>
> Brian Peasland
> oracle_dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"

If by your answer you are indicating that you understand what the OP was asking I would very much like to know what it is?

Thanks.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)