Regular Expressions: Say What?

Session Number: 8161
Track: Database
Sub-Categorization: DB Dev
Session Type: Tips, Techniques and Tuning
Primary Presenter: Alex Nuijten [Director - allAPEX]
Time: Jun 26, 2019 (03:30 PM - 04:30 PM)
Room: 618, Level 6

Speaker Bio: Alex Nuijten is an independent consultant (allAPEX) specializing in Oracle database development with PL/SQL and Oracle Application Express (APEX). Alongside his consultancy work, Alex conducts training classes, mainly in APEX, SQL, and PL/SQL. Alex has been a speaker at numerous international conferences such as ODTUG Kscope, Oracle OpenWorld, UKOUG, IOUG, OUGF, BGOUG, OGH APEX World, and OBUG. For his presentations, Alex has received several best speaker awards.

Alex has written many articles in Oracle-related magazines, and at regular intervals he writes about Oracle Application Express and Oracle database development on his blog Notes on Oracle ( He is co-author of the book Oracle APEX Best Practices (published by Packt Publishers). Alex is also co-author of Real-World SQL and PL/SQL (published by Oracle Press).
Because of his contributions to the Oracle community, Alex was awarded the Oracle ACE Director membership in August 2010.

Technologies or Products Used: SQL,PL/SQL

Session Summary for Attendees:  It has been possible to get regular expression support with its own set of functions since Oracle database release 10, but getting started with regular expressions is not easy. Most database developers would avoid them if at all possible.

With the current release of the Oracle database, regular expression syntax becomes more important. You can use it to redact data with DBMS_REDACT and to search for patterns using the Match_Recognize clause. This session covers the basic syntax and gives you an easy introduction to regular expressions with plenty of code samples.