My OOW15 Brain dump I’m finally back to a point where I can write a few blog posts after OOW15. If you didn’t attend Oracle Open World this year, I have one word for you, “CLOUD”. Here is your obligatory OOW15 infographic. Larry opened by presenting Oracle’s journey down the “as a Service” path covering SaaS, …
Connecting ODI 12c to Oracle Public Cloud (OPC)
Connecting ODI 12c to the Oracle Public Cloud Recently I had the opportunity to subscribe to the Oracle Public Cloud DBaaS, and since I’ve been working with ODI 12c in my test lab, what better thing to do than explore some opportunities to utilize these two technologies. This post will cover the steps necessary to …
Oracle DB12c on OL7 with Virtual Box 5 installation issues
As usual, I’m goofing off in my home Data Center (riiiiight), and I decide to install Oracle Linux 7 and the 12c Database. While not concerning myself with what’s on the Compatibility Matrix, I go ahead and start up Virtual Box 5 (recently released) and install my O/S. No problem there so, I’m thinking everything …
Configure NFS on Oracle Linux 6.6
Configure NFS on Oracle Linux 6.6 I started taking a class yesterday and volunteered to help figure out how to share directories between linux machines on the same network. I decided to make it a blog post. First let’s get it straight that I am not a Linux Admin or anything like that so this …
Reject Malformed Email Using Check Constraints with REGEXP_LIKE function
Using Check Constraints with Regular Expressions was something I just wanted to experiment with. Turns out they can be effective. The example here will address a common problem when requesting information from a user. One can argue that the this type of check should be done at the application layer and not the database layer, …
Drag-n-Drop comes to VirtualBox5
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. There are a multitude of way to accomplish this, so by all …
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 …
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 …
