Drag-n-Drop comes to VirtualBox5
I’m always trying to remember how to set up shared folders between my MacBook Pro and my VirtualBox VMs. This has mostly been because I want to install something on a VM that I have downloaded to host system. … Continue reading
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 … Continue reading
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 … Continue reading
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 … Continue reading
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 … Continue reading
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 … Continue reading
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 … Continue reading
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 … Continue reading
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 … Continue reading
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 … Continue reading