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

In reply to Oracle 10g incorporating "Perl-influenced regular expressions" by spectre9

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.