Oracle 10g incorporating "Perl-influenced regular expressions"by spectre9 (Beadle)
|on Mar 24, 2009 at 02:35 UTC||Need Help??|
I searched around perlmonks and was amazined to not have seen any mention about Oracle 10g having added regular expressions from Perl.
More information is at http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_regexp.htm
My last job was heavy ETL programming. I never gave up the Perl front-end for the ETL -- heck, I used more Perl than Cognos even though the boss frowned me right out the door... his loss!
But back to Oracle -- Having the option to REGEXP_REPLACE contents of the database was quite nice when a new 'cleanup' rule was discovered in our ETL shakedown. In many cases, I could run the search/replace regular expression straight out of my Perl code against the live Oracle tables.
And now that Oracle "gives away" this database even for commercial redistribution "for free" its something other monks could experiment with.
Another minor example is COGNOS/IBM Framework Manager 8 application allows one to use "Perl Regular Expressions Syntax" when searching for objects. Alas, though, no support within the actual objects, though....
This was an exciting addition to Oracle in my mind. I thought I'd throw up a node for other monks to ponder and comment on how Perl regular expresssions are influencing commercial software. Or maybe belatedly comment on Oracle jumping on the "Perl does it better" bandwagon.
spectre#9 -- "Strictly speaking, there are no enlightened people, there is only enlightened activity." -- Shunryu Suzuki