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 …
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 …
Kscope15 Conference Planning
What a weekend!! Fresh from two intense days in Hollywood, planning your Kscope15 Conference. If you follow any of your Conference Planning Committee members on Facebook or Twitter, I am sure you saw images of us with picturesque backdrops, comments about how good the food was, etc. I can definitely say it was fun. I’m …
East Coast Oracle Users Conference 2014 Wrap Up (#ECO2014)
It’s Friday, and I have just returned from the East Coast Oracle Users Conference. I must say that this regional conference comes packed with content. There were approximately 60 sessions over the two days, and at least 15 presenters were Oracle ACE Associates, ACEs, or ACE Directors. Tuesday’s Keynote session led by Kerry Osborne of Enkitec …
Data Security with VPD in Oracle EBS
Enhance data security by using VPD and EBS Profile Options to prevent viewing of sensitive data. In this example we will look at blocking employee SSN or National Identifier, as they are called in EBS, in PER_ALL_PEOPLE_F . As most people familiar with Oracle EBS know, there are a number of delivered views that have embedded security. Take …
