CHAPTER4
Regular Expressions
Support for regular expressions was added to the Oracle Database to expand on single- and multiple-character wildcard searches to allow for more complicated search patterns. This greatly enhances searching capabilities; however, writing regular expressions can prove quite tricky. Sometimes it requires a different way of thinking. This chapter discusses the regular expression functions in Oracle.
With the arrival of Oracle Database 12c, pattern matching got another boost with the introduction of match_recognize. This functionality will be briefly explained toward the end of the chapter.
Also in Oracle Database 12c
Get Real World SQL and PL/SQL: Advice from the Experts 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.
