With the release of the Oracle Database 184.108.40.206 there was a number of new features and options. Most of the publicity has been around the in-Memory option. But there was lots of other features for the DBA and a few for the developer.
One of the new SQL functions is the APPROX_COUNT_DISTINCT(). This function is different to the tradition count distinct, COUNT(DISTINCT expression), in that is performs an approximate count distinct. (more...)
When Oracle Data Miner (ODMr) 4.0 (which is part of SQL Developer) came out back in late 2013 there was a number of new features added to the tool. One of these was a Graph node that allows us to create various graphs and charts that include Line, Scatter, Bar, Histogram and Box plot.
I've been using this node recently to produce graphs and particularly scatter plots. I've been using the scatter plots to (more...)
In this post I want to show some example of using a new feature in 12c for selecting the first X number of records from the results set of a query.
See the bottom of this post for the background and some of the reasons for this post.
Before we had the 12c Database if we only wanted to see a subset or the initial set of records from the results of a query we (more...)
The following steps are what I did for installing 220.127.116.11 on Windows.
1. Download the Oracle installation ZIP files from the Oracle Downloads page.
2. Unzip the two 12c downloads files into the same directory.
3. Go to the newly created directory (it is probably called 'database') and you will find a file called setup.exe. Double click on this file.
After a couple of seconds you will see the Oracle Database (more...)
Oracle Open World is coming up in a few days time. This is a huge event that also incorporates Jave One and various other smaller conferences that are for specific product areas and for partners.
I will be presenting at Oracle Open World this year and I'll also be taking part in a number of other sessions/events including the Oracle ACE Directors briefing. Check out my blog post that list these sessions/events.
In addition to (more...)
I had an previous blog post listing the various Oracle Advanced Analytics sessions/presentation at Oracle Open World 2014.
After trawling through the list of Hands-on-Labs it was disappointing to see that there was no Oracle Data Mining or Oracle R Enterprise hands-on-labs this year.
But there is a hands on lab that looks are how to use the new SQL for Big Data feature (announced over the summer).
Here is the abstract for the session.
With Oracle Open World just a few days away now, I was going through the list of presentations that are focused on using the Oracle Advanced Analytics Option. These will cover Oracle Data Miner and Oracle R Enterprise.
So I've decided to share this list with you :-) and hopefully I will get to see you are some or all of these sessions.