I was asked a while ago by a twitter follower this question. “One year ago to now, how has your use of technology changed in your job role?” Interestingly enough, I celebrated 1 year @snowflakeDB on April 16, 2019. I think now is a good time to answer that question. In a nutshell, a year …
Category: dbaOnTap
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 …
Georgia Oracle Users Group – Reboot
Looking for an Oracle User Group home in Atlanta? I want to re-introduce everyone to the Georgia Oracle Users Group (GaOUG). For over 20 years, this group has been laser focused on supporting the DBA community in the metro Atlanta area by hosting monthly educational meetings where individuals, both members and non-members presented on topics of …
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 …
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 …
It’s Out! #SQLDeveloper v4.1 EA1
Earlier today, I saw a few hints that we might need to check out the SQL Developer Download page. Finally having a chance to check, yep there is was, the long awaited SQL Dev v4.1 EA1. Now please be aware that this is and Early Adopter release. This version also requires that you have JDK 8 …
SQL Developer Database Copy: I Really Like This Tool!
SQL Developer Database Copy Recently, my team has been involved in a pretty detailed migration from a Development Instance to our QA instance prior to a final promotion to Production. In the past, some of the team members were moving PL/SQL packages between instances by doing this: Opening them up Copying to the clipboard Open …
