Thank you Anthony !!!! Thank you Very much It worked Thank you for this
Group Tooo :-)

Regards ,
Subbu
----- Original Message -----
From: "Anthony Molinaro "
<oracledba-ezmlmshield-x79213517.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, August 31, 2005 9:45 PM
Subject: RE: Help in the Query


> Subbu,
> Just moonwalk like you're Michael Jackson (start backwards and
> glide....) :)
>
>
> SQL> select 'ABCDxxxxx(1856)xxx(z)xxxx(301256..)' str from dual;
>
> STR
> -----------------------------------
> ABCDxxxxx(1856)xxx(z)xxxx(301256..)
>
>
> SQL> select str,
> 2 substr(str,
> 3 instr(str,'(',-1)+1,
> 4 length(str)-instr(str,'(',-1)-1) snippet
> 5 from (
> 6 select 'ABCDxxxxx(1856)xxx(z)xxxx(301256..)' str from dual
> 7 );
>
> STR SNIPPET
> ----------------------------------- -----------------
> ABCDxxxxx(1856)xxx(z)xxxx(301256..) 301256..
>
>
> Hope that helps,
> Anthony
>
>
> -----Original Message-----
> From: subbu
> [mailto:oracledba-ezmlmshield-x19525186.[Email address protected]
> Sent: Wednesday, August 31, 2005 12:00 PM
> To: LazyDBA Discussion
> Subject: Help in the Query
>
> Hi DBA's,
>
> I need help!!! I have a column called Model in table A it may contain
> values like
>
> ABCDxxxxx(1856)xxx(z)xxxx(301256..) I want to retrive the value in the
> last braces i.e 301256..
>
> Model is variable length
>
> Thanks,
> Subbu
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>



Oracle LazyDBA home page