Ig. Sistema

Introducing Oracle Regular Expressions
An Oracle White Paper September 2003

Introducing Oracle Regular Expressions

Introduction........................................................................................................4 History of Regular Expressions...................................................................4 Traditional Database Pattern Matching.....................................................5 Oracle Regular Expressions .........................................................................6 Enhancing the Data Flow ............................................................................6 Database to Client.....................................................................................7 Database Update.......................................................................................7 Client to Database.....................................................................................7 Oracle Regular Expressions Key Features .....................................................8 Interfaces ........................................................................................................8 Metacharacters...............................................................................................9 Locale Support...............................................................................................9 Character sets.......................................................................................... 10 Case and AccentSensitivity.................................................................. 10 Range........................................................................................................ 11 Character Class ....................................................................................... 11 Collation Element.................................................................................. 12 EquivalenceClass................................................................................... 12 Using Regular Expressions in Oracle........................................................... 13 Function Overview..................................................................................... 13 REGEXP_LIKE ................................................................................... 13 REGEXP_SUBSTR.............................................................................. 13 REGEXP_INSTR ................................................................................. 13 REGEXP_REPLACE .......................................................................... 14 Arguments ................................................................................................... 15 Offset....................................................................................................... 15 Occurrence.............................................................................................. 15 Multiline................................................................................................... 16Newline.................................................................................................... 16 Using with DDL......................................................................................... 17 Constraints .............................................................................................. 17 Indexes..................................................................................................... 18Views........................................................................................................ 18 Using with PL/SQL................................................................................... 18 Performance Considerations .................................................................... 19 Advanced Topics............................................................................................. 20...