O'Reilly logo

Oracle Regular Expressions Pocket Reference by Peter Linsley, Jonathan Gennick

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Oracle Regular Expression Functions

Oracle’s regular expression support, which we introduced earlier in the book, manifests itself in the form of four functions, which are described in this section. Each function is usable from both SQL and PL/SQL.

All the examples in this section search text literals. We do this to make it obvious how each function works, by showing you both input and output for each example. Typically, you do not use regular expressions to search string literals, but rather to search character columns in the database, or character variables in PL/SQL.

For the same reason, the regular expressions in this section are simple to the extreme. We don’t want you puzzling over our expressions when what you really want is to understand the functions.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required