Re: Oracle 10.1.0.2 install

James Williams wrote:

> I downloaded and installed 10 g today and tested regular expressions
> and the like.
>
> They say is is simplier but select coun(*) from dict yields over 1700.

Simpler does not mean simplistic.

It is easier to do many things in 10g. Regular expressions are substantially easier than trying to create the same functionality in 9i or earier.

For example ... try to write this in 8i or 9i?

SELECT *
FROM test
WHERE REGEXP_LIKE(testcol, '[[:alnum:]]{3}');

Good luck. And this is about as simplistic as one can get.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)