How about those Florida Gators? Hehe.


-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x47621561.[Email address protected]
Sent: Monday, April 02, 2007 11:50 AM
To: LazyDBA Discussion
Subject: Oracle Database 10G Regular Expressions (REGEXP_REPLACE)

Ahhhhh, yes! The old Oracle Database 10G REGEXP_REPLACE (regular
expression)! Hehe.

--Remove all "th"

set lines 132

SELECT REGEXP_REPLACE('Joe Smith MirTh Ed lives on 9th Street and today
is his 18Th birthday and he is on the 18TH hole: hehe',
'(th|tH|Th|TH){1,}', NULL)
AS RX_REPLACE
FROM dual
/


Please take a few minutes to provide feedback on the quality of service
you received from our staff. The Department of Education values your
feedback as a customer. Commissioner of Education Jeanine Blomberg is
committed to continuously assessing and improving the level and quality
of services provided to you.Simply use the link below. Thank you in
advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

Oracle LazyDBA home page