17Regular Expression Support

CERTIFICATION OBJECTIVES

17.01 Using Metacharacters

17.02 Regular Expression Functions

17.03 Replacing Patterns

17.04 Regular Expressions and CHECK Constraints

Image Two-Minute Drill

Q&A Self Test

This chapter explores the use of regular expressions in Oracle SQL. The term “regular expressions” refers to a specific language for working with text. You can use regular expressions to specify some complex character patterns and perform complex searches in a succinct and efficient manner.

Regular expressions have an identity that goes beyond SQL and Oracle. They are used in Unix, C, and elsewhere. This chapter will look at the ...

Get OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) 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.