An Oracle blog – Amardeep Sidhu

February 27, 2008

Learning Regular Expressions

Filed under: Oracle Basics,Scripting,SQL — Sidhu @ 9:29 pm
Tags: ,

From Eddie’s blog I got a link to 3 posts on Regular Expressions on OTN written by CD. Wonderful stuff. Check out.

Part 1

Part 2

Part 3

& Thanks CD…wonderful work buddy !


  1. I’ve been working with regular expressions in PL/SQL a lot lately and the one tool that’s helped me more than any other is Regex Buddy ( Yeah, it’s not free, but it was the best $40 I’ve spent. There are free options, like regex coach and a few free online options, but the problem is you have to find one that matches the Oracle specific Posix ERE format. Regex buddy even has a drop-down for Oracle syntax ( I have no affiliation with this tool whatsoever, just found it to be exceptionally useful.


    Comment by Tyler — February 28, 2008 @ 7:51 am | Reply

  2. […] Amardeep Sidhu offers links to a three-part howto on regular expressions in Oracle. […]

    Pingback by Log Buffer #86: a Carnival of the Vanities for DBAs — February 29, 2008 @ 11:24 pm | Reply

  3. Thanks Tyler

    Surely, I will have a look at Regex Buddy 🙂


    Comment by Sidhu — March 3, 2008 @ 9:02 pm | Reply

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Theme: Rubric. Get a free blog at

%d bloggers like this: