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 …
Category: Oracle
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 …
SSH Tunnel with #SQLDev 4.1 EA1 and EA2 side by side
Yesterday March 9th, the team that works on #SQLDev, dropped EA2 out there for us to play with. For some random reason, I decided to check out SSH tunneling feature. If you are familiar with it in the EA1 release, some things have moved around and features have been added. Let’s take a look at …
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 …
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 …
Close Multiple Connections in SQL Developer
ThatJeffSmith has already shown you how to clean up your Connections window in SQL Developer by using Folders. If you are like me, you may have multiple open connections to various database instances or to the same one for that matter, and maybe you want to close a certain set of connections. By using folders, …
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 …
Big Data Lite VM and SQL Developer v4.1 EA1
As a regular user of #SQLDeveloper, I decided to go ahead and check v4.1 EA1 connectivity to the Oracle Big Data Lite VM. The good news is that it works. The better news, is the steps are the same for the SQL Developer 4.0.3, the most recent GA release. If by chance, you haven’t already …
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 …
