O'Reilly logo

OCA Oracle Database SQL Expert Exam Guide by Steve O'Hearn

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

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 ...

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