Tag: database

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 …

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 …

dbaOnTap, ODI, Regular Expressions

Regular Expressions Functions with Oracle Data Integrator

Starting with Oracle database 10gR1, 4 Regular Expression functions were introduced that you can use in SQL and PL/SQL statements. This post will illustrate how to use the REGEXP_REPLACE function in a flat file to Oracle database mapping using ODI. The beauty of the ODI implementation is that it takes advantage of the technology within the target …

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 …

ACEA, cool stuff, Database, Migration, Oracle, SQLDev

Database Objects Compare: Grants, Types, and Owners

On Tap for Today: I had a chance to have a little fun today browsing these database tables: sys.obj$, sys.objauth$, sys.user$, and table_privilege_map. This last migration, the result of at least two other blogs posts, has forced me to think about how we do object migrations.  It’s one of the few times that we had …

#odtug, Conferences, KScope14, Oracle, SQL

The Final Note – Kscope14

KScope14 was hosted in Seattle, the City of Music, and what an experience it was.  For six days, Oracle experts and professionals descended upon the City to share with and learn from each other.  We kicked off on Saturday with a Community Service event event with the Nature Consortium.  After being stuck and scratched by …