Database Development

Category

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

This article is about functions and how to get more out of them if you combine them with record structures. Functions are the instrument in the Oracle Database to execute code and return a value. Nothing new here, everybody who develops in PL/SQL on the database knows that. In case you’re just starting with Oracle and want to know more about… Continue Reading →

All Things Oracle Full Articles, Database Development, Oracle Database, PL/SQL

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

This post was originally published on Working With Devs. Welcome to part 2 in this short series. In this post I’ll explain how to extend the Oracle DB continuous integration process I set up in part 1 by adding a release management process that deploys changes to staging or production databases at the click of a button. Objective for part… Continue Reading →

All Things Oracle Full Articles, Continuous Delivery, Database Administration, Database Development

This post was originally published on Working With Devs. Welcome to part 1 in this short series, where I explain how to set up a continuous integration process for Oracle databases. In part 2 I’ll set up a release management process that allows a user to deploy changes to staging and live databases at the click of a button. Objective… Continue Reading →

Continuous Delivery, Database Development

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

Prior to Oracle Grid Infrastructure (GI) release 12.1.0.2, ASM Library (ASMLIB) was the only method to access storage devices by means of ASM Disks and Diskgroups. There were serious limitations to this method. The ASM disks were owned by GI home owner and both the owner and any users belonging to an operating system group designated as the OSASM group… 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