Month: June 2015

Database, Oracle, REGEXP_REPLACE, Regular Expressions

Using Virtual Columns with REGEXP

In a previous post, I discussed the REGEXP_REPLACE¬†function. Let’s combine this example with the virtual columns feature introduced in Oracle Database 11g. In that example, we looked at using the REGEXP_REPLACE function in the select statement to display a phone number in the desired format.   A similar construct can be used to define a …