STANDARD date considerations in Oracle SQL and PL/SQL

Most of us know that the Oracle DATE datatype has upper and lower limits. From the Oracle 11g Database Concepts manual:

Oracle Database can store dates in the Julian era, ranging from January 1, 4712 BCE through December 31, 9999 CE (Common Era, or ‘AD’). Unless BCE (‘BC’ in the format mask) is specifically used, CE date entries are the default.

I never believe 100% anything I read, so I’ll try that. I’ll set (more...)

I’ve Been Made an Oracle Ace Director

Well, I guess the title of this post says it all. As I tweeted yesterday:

I’m grateful, proud, honoured and overall just Jolly Chuffed to have been made an Oracle Ace Director! #ACED

I can now put this label on my belongings

I can now put this label on my belongings

I’ve been an Oracle ACE since 2011 and I’m really happy to be making the step up to being an Ace Director. What does being an ACE Director mean? Well, it certainly does (more...)

Friday Philosophy – Being Rejected by the Prom Queen

If you follow me on twitter (and if you are on twitter, why would you *not* follow me :-) See Twitter tag on right of page -> ) you will know what the title is all about. I posted the below on my twitter feed a few weeks ago:

Submitting to speak at #OOW15 is like asking out prom queens. You live in hope – but expect rejection :-)

{BTW if prom queens are not (more...)

Computers are Logical. Software is Not

We’ve all heard it before. Computers are totally logical, they do exactly what they are told. After all, Central Processing Units (CPUs) are built out of fundamental units called Logic Gates. With perhaps the exception when a stray cosmic ray gets lucky, the circuits in a computer chip and memory act in a totally logical and predicted manner.

And of course, anything built on top of computers will be utterly logical as well. All those (more...)

Friday Philosophy – At What Point Can You Claim a Skill?

I’ve just installed Oracle 12C on my laptop {I know, why only now?}. I went for the option to have a Container database with a pluggable database within it. {It is easy and free to install Oracle on your own home machine – so long as it is for personal use only and you are singed up to OTN (which is also free) }.

12C with pluggable databases (PDBs) is a little different to (more...)

Return from The Temple of Apple

I doubt many of you are on tenterhooks as to how I got on with my phone today {after my << rant last Friday}. But I’m going to tell you anyway.

Overall, Apple have gone some way to redeeming themselves.

I got myself down into Cambridge this morning to visit the Apple Store, at my allotted slot of 10:10 {I later witnessed someone attempting to be 15 minutes early for their slot – and (more...)

Friday Philosophy – Friday Afternoon Phone

There used to be a phrase in the car industry in the UK (I don’t know about elsewhere) a “Friday Afternoon Car“. This is a car which is unusually unreliable, as it was built on Friday afternoon when the workers were tired, the weekend was coming and, heck, they might have been to the pub at lunch. It is occasionally used just to describe something that is a bit crap and unreliable.

I (more...)

Analysing UKOUG Presenter’s – I Know How You Performed.

This last few days I’ve been analysing how well received previous presentations (since 2006!) have been at the UKOUG tech conferences. It’s interesting to look at the information. I’ve learnt some interesting things about all those well-known-names :-)

Like many conferences and user group meetings, during the conference and shortly afterwards the UKOUG ask attendees to feed back on the presentations, keynotes and round tables that people go to. If you chair a session, (more...)

Friday Philosophy – Flippin’ Technology

Sometimes I think I would have been a Luddite or a member of other groups who have trashed new technology in frustration. Some days, I can just scream at it. You would think having worked in Information Technology for so long would make me more of a fan, but it actually makes me worse – as I know there is no need for there to be so much wrong with the electronic dross we all (more...)

Friday Philosophy – Make a Team by Letting Them Burn

The title of today’s Friday Philosophy sounds extreme, but it’s true.

Recently, I was watching a TV program about “experts” helping companies turn around. A couple of decades ago the BBC had a program called “The Troubleshooter” where a gentleman called Sir John Harvey-Jones gave companies in trouble advice {the similar idea but without the cheap and tacky elements we have today with making the targets of the program cry and over-emote for good TV}. (more...)