405: Being Regular with Regular Expressions
John Garmany , ProxITec    Biography

Objectives: Introduction to Regular Expressions
Explain and demonstrate Regular Expressions in SQL and PL/SQL.
Explain the performance implication of using Regular Expressions.
Abstract: This presentation will explain the why and how of using regular expression with Oracle. Unix SAs know the power of matching with regular expression and now the Oracle DBA and Developer can put that power to use. But regular expressions are not the only (of even the best) answer in all situations. We will cover your regular expression options in the SQL, PL/SQL and Java. This presentation will include the new 11g capabilities. The presentations will also discuss improper use of regular expression that can have a large negative impact on database performance. The presentation will explain the pros and cons of each method and when they can best be utilized to provide you with high performance matching capability.

Audiernce Focus: DBA
Expertise: Beginner
Track: Development
Date: Monday, April 14, 2008
Time: 10:30 AM - 11:30 AM