About a week ago, I was presenting at ECO on JSON parsing in the Oracle 12c Database and an attendee asked a great question. To summarize, Maria Colgan gave a keynote in which she noted a feature in 12c that allows you to define a column as Case Insensitive. The attendee in my session asked if …
Tag: Oracle
OEM13c Roles and AD Groups
Managing OEM13c Roles and AD Groups. In my last post, we explored how to enable LDAP (using Windows Active Directory) authentication within OEM 13c. Now that we can centrally manage basic user access to OEM, we need to apply some security constraints around these users. If you are familiar with Active Directory (AD), then …
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 …
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 …
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 …
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 …
Database Objects Compare: Grants, Types, and Owners
On Tap for Today: I had a chance to have a little fun today browsing these database tables: sys.obj$, sys.objauth$, sys.user$, and table_privilege_map. This last migration, the result of at least two other blogs posts, has forced me to think about how we do object migrations. It’s one of the few times that we had …
