Tag: Pattern Matching

REGEXP_LIKE, Regular Expressions

Reject Malformed Email Using Check Constraints with REGEXP_LIKE function

Using Check Constraints with Regular Expressions was something I just wanted to experiment with. Turns out they can be effective. The example here will address a common problem when requesting information from a user. One can argue that the this type of check should be done at the application layer and not the database layer, …

12C, Database, dbaOnTap, Oracle, REGEXP_REPLACE, Regular Expressions

Pattern Matching – Regular Expressions Part 3: REGEXP_REPLACE

It’s been a couple of months since I’ve been on the blogging scene, so I figured I continue my Regular Expressions 101 series. Part 3 will introduce REGEXP_REPLACE. In my previous post, I went into a bit of detail so on to the good stuff. Function name Description REGEXP_LIKE Similar to the LIKE operator but allows …

Beginner Series, Database, Oracle, REGEXP_LIKE, Regular Expressions

Pattern Matching – Regular Expressions Part 2: REGEXP_LIKE

Last month, I gave a general overview of the Pattern Matching in Regular Expressions. This post will introduce the regular expression function: REGEXP_LIKE in the Oracle Database.  Let’s get started. What is a Regular Expression Function? Regular Expression Functions in a nutshell are A set of SQL functions used to search and manipulate strings using Regular …

Database, Oracle

Pattern Matching – Regular Expressions Part 1: META Characters

What are Regular Expressions? Regular Expressions are methods of describing both simple and complex patterns for searching and manipulating. We uses META Characters to define the construct of the search criteria and Oracle’s implementation is an extension of the POSIX (Portable Operating System for UNIX). The following post is will give the reader an overview of …