RE: Help in the Query

RE: Help in the Query

 

  

Molinaro,
You "developer", you! Can you do the "two step"? All "developers" know how to "two step" code? Hehe!


-----Original Message-----
From: Patterson Joel
[mailto:oracledba-ezmlmshield-x57470307.[Email address protected]
Sent: Wednesday, August 31, 2005 1:00 PM
To: LazyDBA Discussion
Subject: RE: Help in the Query


Aaaooh!

-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x76534415.[Email address protected]
Sent: Wednesday, August 31, 2005 12:29 PM
To: LazyDBA Discussion
Subject: RE: Help in the Query

Nah! I am from the old school! I do the "James Brown"!


-----Original Message-----
From: Patterson Joel
[mailto:oracledba-ezmlmshield-x68899444.[Email address protected]
Sent: Wednesday, August 31, 2005 12:23 PM
To: LazyDBA Discussion
Subject: RE: Help in the Query


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




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




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