Re: Oracle string issue

Anthony wrote:
> I think the regular expression is only supported in Oracle 10g
>

They are supported, to a limited extent, in previous versions via the OWA_PATTERN built-in package. For example:

CREATE OR REPLACE FUNCTION owa_match(phone# VARCHAR2) RETURN BOOLEAN IS BEGIN
   RETURN owa_pattern.MATCH(phone#,'^[0-9]{3}-[0-9]{3}-[0-9]{4}$'); END owa_match;
/

But it was extremely inefficient.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org