My Speaking Schedule for Oracle Open World 2014

A quick post to let you know about the two presentations that I’ll be doing at Oracle Open World 2014.

Session ID:         UGF4482
Session Title:     “Getting Started with SQL Pattern Matching in Oracle Database 12c
Venue / Room:  Moscone South – 301
Date and Time:  9/28/14, 13:30 – 14:15

Session ID:          CON4493
Session Title:      “Regular Expressions (more...)

AIOUG Tech Day at Hyderabad (Aug 23rd)

Hi there, Last week, I spoke at AIOUG Tech Day at Hyderabad. All India Oracle Users Group (AIOUG) in association with TechMahindra organized one full day of techtalk event. Believe me, the Danube auditorium was a state-of-art facility with 500 capacity. Fabulous venue and huge crowd with similar interest. I thought of sharing my experience … Continue reading

Quote: In the middle of difficulty

In the middle of difficulty lies opportunity. – Albert EinsteinFiled under: Quotes Tagged: einstein, quote

Order, Order.. Sorting Happens Last

While preparing for my session at Oracle Open World on "Oracle 12c for Developers" I ran into a little remarkable thing.

When sorting a dataset, the sorting is always done last. That is what I was taught anyway. There is probably some obscure way to detect the exact execution plan, but personally I never bothered to go and investigate.
When I was created some test scripts I found there was a way to see that (more...)

Unforgettable In-Memory

Inspired by Maria Colgans quest for In-Memory bumper sticker slogans for OOW14, I couldn't resist a little fun. Musical readers should stop reading now :-)




Sung to the tune of the old Nat King Cole classic


Unforgettable
Like wizardry
Unforgettable
In-Memory

Like the speed of light my query go
Column aggregates just happen so
Never before
Has data been more...

||:
Unforgettable
So cleverly
Is forever more
In-Memory

Row based access, it's a dinosaur

White Elephant Requirements

I’m often engaged with clients helping them respond to Requests for Proposals (RFPs), and there are way too many bad RFPs out there.

These bad RFPs not only specify what the customer actually needs, they also specify that the customer can possibly think he will ever need. Typical requirements are that the user must be able to add extra attributes to all entities, or that the user can dynamically change which attributes are mandatory, or (more...)

%sql: To Pandas and Back

A Pandas DataFrame has a nice to_sql(table_name, sqlalchemy_engine) method that saves itself to a database.

The only trouble is that coming up with the SQLAlchemy Engine object is a little bit of a pain, and if you're using the IPython %sql magic, your %sql session already has an SQLAlchemy engine anyway. So I created a bogus PERSIST pseudo-SQL command that simply calls to_sql with the open database connection:

%sql PERSIST mydataframe

The result is (more...)

Neue Features in Postgres

Eine kleine Sammlung neuer Features, die in Postgres 9.4 eingeführt wurden bzw. in 9.5 eingeführt werden sollen - oder darin wünschenswert wären:
  • Craig Kerstiens hat dieser Tage seine Wunschliste mit neuen Features, die er gerne in Version 9.5 sehen würde, veröffentlicht. Auf Position 1 steht dabei das Upsert - aka MERGE - und das scheint auch mir die erstaunlichste Lücke im gegenwärtigen postgres-Funktionsumfang zu sein. Immerhin ist es seit Version 9.1 möglich, (more...)

Autoformat ANY amount item, anywhere

If you’re building a “finance-ey” application you probably have plenty of fields that should show and accept monetary amounts – and quite possibly these items may be implemented in a variety of ways – ordinary apex number items, edit fields in tabular reports, or even dynamically generated items using APEX_ITEM.text.

In my case I had all three, scattered throughout the application. Our users routinely deal with multi-million dollar amounts and they had trouble checking the amounts visually, (more...)

★ How BIG is Oracle OpenWorld?

Oracle OpenWorld

Here is how big it was in 2013. Compare it to its size in 2012. It is safe to assume that it will be bigger in 2014!

I will attend this year’s event by invitation from the Oracle ACE Program. Prior to the start of the conference, I will be attending a two day product briefing with product teams at Oracle HQ. It’s like a mini OpenWorld but only for Oracle ACE Directors.

During the (more...)

DRM Free Downloads – Is That OK?

I talked to a prospect today that was using a competitive platform to deliver their video products.  We talked extensively about differentiation of InteliVideo over their current platform (from brand to analytics to customers to apps and so on).  But one thing that came up had to do with DRM free downloads.  You might think that's a good thing if you don't understand what it means...as they did.  I said "so you're OK with (more...)

How the Big Boys Do It!

We have a number of VERY large (video on demand) customers.  We've broken our customer-base into 3 categories:

1. Infoprenuers - these are companies who do something and have video, but video is not their primary business.  For example, RunBare.  Their primary business is teaching people how to run in your barefeet.  They do have a video on this topic, along with books and other items.  Another example is BDB Software, which is my (more...)

Remote DML with DBMS_PARALLEL_EXECUTE

A comparison of sucking data into a table over a db link using DBMS_PARALLEL_EXECUTE.

This particular example is based on something I needed to do in the real world, copying data from one database into another over a db link. Datapump is not available to me. Tables in question happen to be partitioned by a date-like number (boo!) hence some of the specific actions in the detail.

I think it’s a good example of (more...)

The Spiritual Programmer

Based on my article in the latest issue of OTech Magazine, I am offering a free teleseminar (by phone or Skype) on how to live a happy, meaningful life in IT.

Programmers have a head start over the rest of humanity in leading happy, meaningful lives. If you have not yet reached complete enlightenment, I encourage you to sign up and invest 30 minutes listening to this call. It might improve your life.

Sharing SQLDeveloper SQL history across several machines with Dropbox

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. A quick tip for keeping a single shared SQL history repository among different installations of SQLDeveloper, for the same user, on distinct computers synchronized with Dropbox.   This seems to be working just fine on Mac OS X and SQLDeveloper 4.0.2 however it's a totally unsupported

Abgeleitete IS NOT NULL Prädikate

Jonathan Lewis weist (im Rahmen einer Quiz-Frage, die sehr schnell ihre Antwort fand) darauf hin, dass der Optimizer implizite IS NOT NULL Prädikate schon seit vielen Releases aus der Join-Bedingung ableiten kann (im Sinne von: wenn ein Join durchgeführt wird, kann die Join-Bedingung keine NULL-Werte enthalten haben).

OTech Magazine Issue 4 – APEX 5 and much more

Well it's the second half of August and this is my first real post for the month. There are two very good reasons for this:

1) We've just completed a major implementation at one of our clients - a tablet based application using APEX, which completely changes the face of a major arm of the business. It's a groundbreaking application with only one peer in the industry - which users are already claiming superiority to (more...)

Demystifying Oracle Unpivot

A couple of years ago I posted a simple example using PIVOT, converting rows to columns with the classic example of figures by months.

Oracle 11g R1 also introduced the UNPIVOT function, allowing columns to be converted into rows.

Problem

I've created an example that lists cities by row, but two attractions as two columns, with pairing attributes describing the reason for the attraction.
create table aus_attractions(id  number, city varchar2(50)
, attraction1 varchar2(50)
, (more...)

Oracle 12C – In-Memory Option Resources

Hi folks,

Introduced as an Option Oracles In-Memory option will change the world of databasing also like SAP HANA does; Since July the release is out but the search for resources and documentation is  poor;

Here some useful links I found.

Non-Oracle Resources

 

Oracle Documentation

Concepts (found a small passage) ...

 

 

just started the list - wiil enhance it - from time to (more...)

Employee or Member Training

Do you have a group of employees or members that you would like to train?  Would you like to make the training available for a limited time only - such as for 2 weeks?  Would you like to have the ability to take the ability to view the training away at your discretion (such as when an employee leaves the company)?  Would you like to know who watched which videos?  For example, did Jim watch (more...)