Being Regular with Regular Expressions

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. While most DBAs do not use Java, it does provide a rich and powerful regular expressions capabilities that SQL and PL/SQL do not have. Similarly, improper use of regular expression 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. Presentation White Paper.