News, views, tips and tricks on Oracle and other fun stuff

Oracle Regular Expressions

If you want to improve your ability to search and manipulate character data, regular expressions, a notation for describing textual patterns, is for you. And if you have Oracle Database 10g, you’re in luck, as the regular expressions feature was introduced starting with that release. Here are a couple of links that will help you understand and use regular expressions in your Oracle code (courtesy of Robert Vollman):

  1. Article at
  2. Reference at

Filed in Oracle on 06 Jul 05 | Tags: ,

Reader's Comments

  1. |

    It may be interesting for the reader to have a first-hand experience with Oracle’s regular expressions using Yocoya REGEXP Workbench, a simple web application that allows one to create and test patterns using a set of sample strings interactively. You can check it out at the following address: Click on the union jack to switch the language to english. Bye Eddie! Flavio Casetta