Chapter 10. Introduction to Regular Expressions

Regular expressions were introduced in Oracle 10g Release 1, much to the delight of UNIX/Perl programmers everywhere. If you know regular expressions like the back of your hand, this chapter will show you Oracle's implementation, and how your knowledge can be leveraged with PL/SQL. If you aren't familiar with regular expressions, we'll show you what they are, how they work, and what you can do with them.

The chapter begins with an overview of regular expressions, their history, and some typical applications. We discuss the features available with Oracle, including metacharacters and built-in functions. Finally, we demonstrate how regular expressions combined with PL/SQL are a powerful combination ...

Get Expert Oracle PL/SQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.