regex

Thumbnail image for REGEX to Split a Comma-Separated String into Rows

REGEX to Split a Comma-Separated String into Rows

How to split a comma-separated string into rows in Oracle SQL, using regex function REGEX_SUBSTR and recursion via CONNECT BY.

Read the Full Article →
Hierarchical Data in a Relational Table

Flatten Hierarchical Data using a Single SQL

Single Oracle SQL to find and flatten hierarchical data stored in a table, using a combination of SYS_CONNECT_BY_PATH and regular expressions.

Read the Full Article →
Thumbnail image for How to Validate Email Address in SQL

How to Validate Email Address in SQL

In applications that take user email id as input, there is a need to check for email id validity. Here is a an way to validate email address, using regular expressions in Oracle SQL.

Read the Full Article →
Regular Expressions in Oracle

Regular Expressions in Oracle Made Easy

A regular expression (also called regex or regexp for short) is a sequence of characters that describes a pattern in text. Tips and examples about how to regular expression in SQL

Read the Full Article →