Learning is not a spectator sport

Datatype discipline

(This is based on some ‘issues’ a client was having, so the example is architected to make a particular point,

I’ve got an existing package called DEMO as below SQL> create or replace package demo is 2 — used to

The OTN forums, which should be a plethora of knowledge and learning, were always hampered by the hideous interface. But,

My Oracle Support had a fairly lengthy outage today right in the middle of the Australian business day. But I’m

The OUGN conference (held on a cruise ship) was an awesome experience and so professionally run by the committee. I

The OUGN user conference (on a cruise ship!) starts next week and I’m presenting there. From all reports, this is

Consider the following simple setup SQL> create table t ( x int, b blob ); Table created. SQL> declare 2

A long time ago … a long long time ago (http://www.oracledba.co.uk/tips/merge_speed.htm) I wrote that MERGE works best over update and

Thanks to everyone that came along. The slides can be found here

I was doing some work for a client, and LOB processing seemed incredibly slow. After some poking around, it appears