Datatype discipline
(This is based on some ‘issues’ a client was having, so the example is architected to make a particular point,
(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