What? I don't believe it! A dancing "developer"! Hehe!


-----Original Message-----
From: Anthony Molinaro
[mailto:oracledba-ezmlmshield-x79213517.[Email address protected]
Sent: Wednesday, August 31, 2005 12:16 PM
To: LazyDBA Discussion
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