Connecting Tech Pros Worldwide Help | Site Map

Oracle 10g Feature: REGULAR EXPRESSIONS - 1

amitpatel66's Avatar
Moderator
 
Join Date: Mar 2007
Location: Hyderabad, India
Posts: 2,192
#1   Oct 9 '07
Oracle 10g feature: Regular Expressions

This article will provide information about regular expressions in oracle 10g which the forum members might find it useful.

The regular expressions feature in Oracle Database 10g is a powerful tool for manipulating textual data.

Oracle's implementation of regular expressions comes in the form of various SQL functions and a WHERE clause operator.

Some of the SQL functions are:

1. REGEXP_INSTR
2. REGEXP_SUBSTR
3. REGEXP_REPLACE

and the WHERE clause operator is:

1. REGEXP_LIKE



Closed Thread