Month: February 2015

dbaOnTap, ODI, Oracle, REGEXP_LIKE

Oracle Data Integrator User Functions with Regular Expressions and Dropped Square Brackets

Just the other day I described how you can use Regular Expressions Functions with Oracle Data Integrator. Well that was only part of the story.  Immediately after that post went out, I had several notes from people who are way smarter than me say “put that in an ODI User Function for reusability”.  This post …

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 …

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 …