Re: PL/SQL substr(instr oracle

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"