David Njoku in Oracle

Oracle for Absolute Beginners: Problem-Solving as a New Developer

Learning programming logic and syntax is just the beginning. In this article, David Njoku talks about how to debug and...

30 April 2019 9 min read

David Njoku

Oracle for Absolute Beginners: Users, Synonyms, Privileges, & Roles

I accidentally locked myself out of my house this evening, and so I had to climb up the wall like...

01 March 2017 11 min read

David Njoku

JSON For Absolute Beginners: Part 6 – Generating JSON post-12c Release 2

In this sixth and final installment in this introductory series on JSON I’d like to revisit the question of generating...

22 February 2017 6 min read

David Njoku

Oracle for Absolute Beginners: Data Types

All databases stand on a tripod of datatypes: strings, numbers and dates. And so I’d imagine that by Day 2...

15 February 2017 11 min read

David Njoku

Oracle for Absolute Beginners: Date, Timestamp and Interval

All databases stand on a tripod of datatypes: strings, numbers and dates. And though they might dress them in fancy...

02 February 2017 12 min read

David Njoku

Oracle for Absolute Beginners: Other SQL Functions

Here’s a simple trick you can play on your friends. Ask them to pick a number from 1 to 10,...

30 January 2017 8 min read

David Njoku

JSON For Absolute Beginners: Part 5 – Generating JSON in Oracle

In this fifth article in our series on JSON and the Oracle database we’ll be pulling the curtains back on...

11 October 2016 7 min read

David Njoku

JSON For Absolute Beginners: Part 4 – Retrieving JSON in Oracle

There’s a possibility you’ve parachuted into this series on JSON and Oracle at this point. If you are already familiar...

03 October 2016 11 min read

David Njoku

JSON For Absolute Beginners: Part 3 – Storing JSON in Oracle

Welcome to part three in this series of articles about Oracle and its uneasy romance with JSON. Uneasy? Well, that’s...

16 September 2016 7 min read

David Njoku

JSON For Absolute Beginners: Part 2 – Why Use Oracle?

In this short series of articles, we’ll be talking about JSON and its integration with the Oracle database. The first...

02 September 2016 5 min read

David Njoku

JSON For Absolute Beginners: Part 1- Introduction

Hi, meet my friend JSON. Chances are you’ve heard of it, perhaps you have a vague idea of what it’s...

02 September 2016 5 min read

David Njoku

XQuery for Absolute Beginners: Part 5 – XQuery Update Facility

There’s something slightly oxymoronic about the phrase XQuery Update Facility. Make your mind up, dude – are you querying or...

19 April 2016 7 min read

David Njoku

XQuery for Absolute Beginners: Part 4 – Conditions & Custom Functions

This is the fourth part of a series introducing Oracle developers to XQuery. In the first three parts we’ve talked...

12 April 2016 8 min read

David Njoku

XQuery for Absolute Beginners: Part 3 – FLWOR

This is the third instalment in a series of articles that I’m hoping will serve as a primer for Oracle...

21 March 2016 9 min read

David Njoku

XQuery for Absolute Beginners: Part 2 – XQuery and the Oracle Database

In this series of articles I’m hoping to provide a primer for newish Oracle developers who are curious about XQuery...

02 March 2016 7 min read

David Njoku

SQLcl: The new challenger for the SQL Plus crown

I’m that grumpy old guy who comes to your party and sits in a corner with a face like a...

30 November 2015 9 min read

David Njoku

Multi-Table Insert Statements in Oracle

We all know this: if a long-bearded prophet came down from a mountaintop bearing the ten commandments of Oracle programming,...

09 November 2015 7 min read

David Njoku

Introduction to User-Defined Aggregate Functions

OK, let’s speed past the easy bits, the parts we all already know: standard aggregate functions. Aggregate functions, unlike regular...

30 September 2015 7 min read

David Njoku

Introduction to Analytic Functions (Part 2)

In the first part of this series I introduced you to the analytic functions family, outlined its close relationship to...

17 September 2015 7 min read

David Njoku

Introduction to Analytic Functions (Part 1)

Analytic functions have been part of Oracle for a very long time now – ever since 8i back in 1999....

07 September 2015 10 min read

Register for Simple Talk

David Njoku

David Njoku's content

Oracle for Absolute Beginners: Problem-Solving as a New Developer

Oracle for Absolute Beginners: Users, Synonyms, Privileges, & Roles

JSON For Absolute Beginners: Part 6 – Generating JSON post-12c Release 2

Oracle for Absolute Beginners: Data Types

Oracle for Absolute Beginners: Date, Timestamp and Interval

Oracle for Absolute Beginners: Other SQL Functions

JSON For Absolute Beginners: Part 5 – Generating JSON in Oracle

JSON For Absolute Beginners: Part 4 – Retrieving JSON in Oracle

JSON For Absolute Beginners: Part 3 – Storing JSON in Oracle

JSON For Absolute Beginners: Part 2 – Why Use Oracle?

JSON For Absolute Beginners: Part 1- Introduction

XQuery for Absolute Beginners: Part 5 – XQuery Update Facility

XQuery for Absolute Beginners: Part 4 – Conditions & Custom Functions

XQuery for Absolute Beginners: Part 3 – FLWOR

XQuery for Absolute Beginners: Part 2 – XQuery and the Oracle Database

SQLcl: The new challenger for the SQL Plus crown

Multi-Table Insert Statements in Oracle

Introduction to User-Defined Aggregate Functions

Introduction to Analytic Functions (Part 2)

Introduction to Analytic Functions (Part 1)