File Library

Introduction to Regular Expressions in Oracle
Topic: The Database
Owner: Galo Balda
Date: 2013-06-08
Subtopic: At A Glance

Oracle support for regular expressions has been around since version 10g Release 1. However it's common to find developers that aren't aware of this powerful functionality.

Oracle SQL support for regular expressions lets application developers implement complex pattern-matching logic in the database, which is useful for these reasons:

By centralizing pattern-matching logic in the database, you avoid intensive string processing of SQL results sets by middle-tier applications.

By using server-side regular expressions to enforce constraints, you avoid duplicating validation logic on multiple clients.

In this session we'll talk about common used operators, pattern matching conditions and functions provided by Oracle.

Download File

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database