Easily Use Regular Expressions
in Your Oracle Database SQL Code

Oracle Database 10g REGEXP

Starting with version 10g, Oracle Database supports POSIX Extended Regular Expressions via four functions. REGEXP_LIKE is just like LIKE, except that it uses a regex pattern rather than a SQL pattern. The REGEXP_SUBSTR function extracts the part of a column that matches a regex, while the REGEXP_REPLACE function replaces that part with another string. Finally, REGEXP_INST returns the position at which a regex matches in a string, which you can use in more advanced SQL code. Together, these three allow you to create some very powerful SQL queries with very little code.

See How Easy Querying with Regexes Can Be

First, use RegexBuddy to define a regex or retrieve a regexp saved in a RegexBuddy library. Rely on RegexBuddy's clear regex analysis, which is constantly updated as you build the pattern, rather than dealing with the cryptic regex syntax on your own. Detailed help on that syntax is always only a click away.

If you copied a regex written for another programming language or database, simply paste it into RegexBuddy, and select the original regex flavor. RegexBuddy will then automatically convert it to the POSIX ERE regex flavor when you generate a Oracle source code snippet.

If you created a new regular expression, test and debug it in RegexBuddy before using it in your Oracle queries. Test each regex in RegexBuddy's safe sandbox without risking precious data. Quickly apply the regex to a wide variety of input and sample data, without having to produce that input through your database.

Finally, let RegexBuddy generate a source code snippet that you can copy and paste directly into whichever database application you use. Just choose what you want to use the regex for, and a fully functional code snippet is ready. You can change the names of tables and columns to suit your naming style or the current situation, which RegexBuddy automatically remembers.

Don't bother trying to remember Oracle's specific regexp syntax. And don't worry about properly escaping backslashes and other characters. Just tell RegexBuddy what you want to do, and you will get the proper Oracle code straight away.

Let RegexBuddy Make Regex Easy for You

• Discover how you can automate tedious tasks with regular expressions.
• Find out how RegexBuddy makes the regex syntax crystal clear enabling you to use regular expressions with the greatest ease ever.
• Watch self-running demonstrations in your web browser and see what RegexBuddy can do for you.
• Take a look at the screen shots.
• Buy RegexBuddy now and try it risk-free with our 3-month unconditional money-back guarantee.

Page URL: http://www.regexbuddy.com/oracle.html
Page last updated: 08 June 2007
Site last updated: 04 October 2008

Published by Just Great Software Co. Ltd.
Copyright © 2004-2008 Jan Goyvaerts.
All rights reserved.