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]

Oracle LazyDBA home page