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, …
Category: Database
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 …
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 …
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 …
Let The Games Begin! – #Kscope14
We kicked off KScope 14 with a great Community Service event with the Nature Consortium. If you saw my tweet earlier, we HANDLED that Himalayan Blackberry. I’ve got some of that stuff or a very close relative growing in my back yard, so I felt really good pulling that stuff out. Not to be beat …
XML/BI Publisher in Oracle EBS – Bye Bye Discoverer
All good things must come to an end. It has been a long run with plenty of ups and downs. Getting Discoverer rolled out was one of my first tasks as I embarked upon my +Oracle E-Business Suite journey. Alas, we are saying our final goodbyes to Discoverer. This however opens new doors to address our reporting …
Installing SQL Dev 4.0 (JRE 1.6 and JDK 1.7)
I’m in an environment where our 11i version of EBS (I know we need to upgrade) still requires JRE 1.6 to open Oracle Forms. Being an SQL Developer fan (listen to my podcast here), I decided to download and install SQL Dev 4.0. Anyone that’s been following this knows that the latest release requires JDK …
Use Start-up Script to Modify State of your Pluggable Database to Open Read Write in SQL Developer 4.0 EA3 (ORA-01033)
I’m playing around with Oracle’s SQL Developer 4 EA3 and Database 12c. Using SQL Dev, I quickly created a Pluggable Database (PDB). I try to open it, and I get this (ORA-01033). Then I remember reading that the Pluggable Databases don’t open automatically when the database services are started. Well that sucks because now I …
