Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

Oracle 10g incorporating "Perl-influenced regular expressions"

by spectre9 (Beadle)
on Mar 24, 2009 at 02:35 UTC ( #752772=perlmeditation: print w/replies, xml ) 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

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
  • Comment on Oracle 10g incorporating "Perl-influenced regular expressions"

Replies are listed 'Best First'.
Re: Oracle 10g incorporating "Perl-influenced regular expressions"
by Limbic~Region (Chancellor) on Mar 24, 2009 at 13:49 UTC
    Oracle 10g was released in 2003 (6 years ago). Additionally, Oracle didn't add "regular expressions from Perl" as you indicate. They borrowed some character classes, quantifiers and modifieres. In other words, no assertions and other doodads.

    I am not trying to diminish from Oracle adding regular expression support (including some borrowed perl syntax) - I am just trying to put it in perspective.

    Update: Regarding your meditation (perl influencing regular expressions) - For years, perl has lead the way. Even with the perpetuated fugly syntax and moving to NFA, the world has recognized the benefits. It isn't entirely uncommon for software to provide regex support by linking against PCRE. The real meditation in mind though is that, with Perl 6, we will be shattering the mold and blazing a new trail for others to follow.

    Cheers - L~R

      Oracle indeed borrow some regex syntax of perl. However it's not handy. I prefer to retrieve data to perl then regex it.

      I am trying to improve my English skills, if you see a mistake please feel free to reply or /msg me a correction

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlmeditation [id://752772]
Approved by ysth
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (2)
As of 2019-08-18 10:45 GMT
Find Nodes?
    Voting Booth?
    If you were the first to set foot on the Moon, what would be your epigram?

    Results (134 votes). Check out past polls.