David Njoku

Author

I’m that grumpy old guy who comes to your party and sits in a corner with a face like a dog’s backside. You know, that guy who hates everything new: Adele? She’s no Whitney Houston! Bluray? It’s not as good as Betamax! TOAD? It’s not as good as SQL Plus! I’m exaggerating – but only a little. Unless your work… Continue Reading →

All Things Oracle Full Articles, Database Development

We all know this: if a long-bearded prophet came down from a mountaintop bearing the ten commandments of Oracle programming, one of them might read thus: Thou canst select from many tables, but thou may only update, delete from or insert into one table at a time. Right? Well, not exactly. Because you can actually add data to multiple tables… Continue Reading →

All Things Oracle Full Articles

OK, let’s speed past the easy bits, the parts we all already know: standard aggregate functions. Aggregate functions, unlike regular functions, take values from multiple rows as their input. The category includes those aggregate functions that are so ordinary they’re almost invisible – SUM, COUNT, MAX – and a couple that most of us never use – such as APPROX_COUNT_DISTINCT…. Continue Reading →

All Things Oracle Full Articles, Database Development

In the first part of this series I introduced you to the analytic functions family, outlined its close relationship to aggregate functions, and illustrated my points with a few examples. I demonstrated how, by clever use of the analytic function clauses – partition by, order by, and the windowing clause – you could tune your functions to wring even more… Continue Reading →

All Things Oracle Full Articles, Database Development

Analytic functions have been part of Oracle for a very long time now – ever since 8i back in 1999. Analytic functions are an ANSI/ISO standard, and so you’ll find that they are similarly-implemented across a number of compliant databases. (This SQL Server article on “window functions” from sister site, Simple Talk, could very well have been talking about Oracle.) Analytic… Continue Reading →

All Things Oracle Full Articles, Database Development, Oracle Database

We need a baritone voiceover man. You know how those huge TV shows – 24, Prison Break, Jane the Virgin – always start with a recap sequence to bring you up-to-date in case you’d missed the last episode. And it’s always a deep-voiced male narrator: “Previously on The Walking Dead,” he’ll say. We need that guy. Previously on Anatomy of a… Continue Reading →

All Things Oracle Full Articles

My wife and I just welcomed our first child to the world. No, there’s no need to congratulate me; as Chris Rock once said, it’s no big deal, even cockroaches have babies. However, it does mean that I’ve often been up at 3 a.m. rocking my son, mumbling nursery rhymes to him.  Which, of course, always has me thinking of… Continue Reading →

All Things Oracle Full Articles, Database Administration, Database Development

Come, young one.  Come sit by the open fire; hold your cold hands to its warmth. Let me tell you a story.  Back when I was young, the world was a simpler place: we roamed the plains, hunted game with our spears – and Oracle Select statements consisted of only a SELECT, a FROM and, possibly, a WHERE. Things done… Continue Reading →

All Things Oracle Full Articles, Database Development

Database triggers. If you have spent any length of time within the Oracle development circle you might have noticed something strange: pretty much every expert – commentator, blogger, Oracle evangelist – has written an article condemning triggers. And every single time the comment section is flooded with developers/DBAs defending them. I recently joined the fray, writing an article warning against… Continue Reading →

All Things Oracle Full Articles, PL/SQL

Feeling brave?  Enjoy danger? Well, I dare you to walk into a room full of Oracle experts wearing an I ♥ DATABASE TRIGGERS t-shirt. Let’s see if you walk out of that room alive. Database triggers are the Oracle feature that developers love to hate, perhaps above every other.  And it’s pretty unanimous – from luminaries like Tom “Triggers are… Continue Reading →

Database Development, Oracle Database, PL/SQL