Ooh, I like moon walking better. Ed, do you know how to moon walk?

-----Original Message-----
From: Stacy Gaddy
[mailto:oracledba-ezmlmshield-x29603079.[Email address protected]
Sent: Wednesday, August 31, 2005 12:19 PM
To: LazyDBA Discussion
Subject: Re: Help in the Query

Heres one way to do it with string manipulation:
SELECT
'ABCDxxxxx(1856)xxx(z)xxxx(301256..)'

,SUBSTR('ABCDxxxxx(1856)xxx(z)xxxx(301256..)',INSTR('ABCDxxxxx(1856)xxx(
z)xxxx(301256..)','(',-1)+1,
LENGTH('ABCDxxxxx(1856)xxx(z)xxxx(301256..)')-INSTR('ABCDxxxxx(1856)xxx(
z)xxxx(301256..)','(',-1)-1)
FROM DUAL

Just replace 'ABCDxxxxx(1856)xxx(z)xxxx(301256..)' with your field name
and
dual with your tablename.

On Wednesday 31 August 2005 12:00 pm, subbu wrote:
> ABCDxxxxx(1856)xxx(z)xxxx(301256..)

--
Stacy Gaddy
W-(919)321-0855
C-(910)376-1256
stacy.[Email address protected]


--------
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