Oracle had released 10g (not for Win32, Linux yet) and I didn't even know.. awww..
Looking forward to trying out regular expression "where" clauses... wheeee
Regular Expressions? Oofda
djberg96 on 2004-02-01T16:46:43
I usually start out trying a LIKE clause, and usually remove it because it hammers the database and it' *slow*. When it comes to doing *any* kind of regular expressions, more often than not I simply grab the entire string (usually a long data type) and use Perl to do my regular expressions. This simplifies the SQL, is usually faster, and keeps me under the IO limits.
I don't expect this to be any better with 10g.
