David Njoku

David Njoku is a software developer at CACI. His tools of choice are Oracle technologies and he has over a decade of experience building applications with Oracle Forms, Oracle Application Development Framework and Oracle Application Express. David holds a degree in Accountancy and earned his bread as a short story writer and a magazine editor and columnist before turning to IT. David can be contacted at about.me/davidnjoku.

31 May 2012
31 May 2012

Introduction to Oracle Flashback Technology (Part 2: Database Administrators)

0
0
In the first in this series of articles on the tools in the Oracle Flashback Technology armoury, I discussed what is available to application developers, the various means by which they can rewind the clock and correct recently-past data errors.  However, if this was a world in which the worst thing that could happen was a small mix-up with data,… Read more
0
0
12 March 2012
12 March 2012

The 40 Most Common Oracle Errors

0
9
I have been in this industry long enough to remember the bad old days, when every developer and DBA had a pile of dusty Oracle user guides on their desks and, every time their database or application coughed up an error, would thumb through the books with mounting desperation. Fortunately, the times have moved on and we now all outsourc… Read more
0
9
17 October 2011
17 October 2011

Introduction to Scheduled Jobs

0
1
Psst, wanna see something cool? I bet I can read your future. Your tomorrow is going to be almost exactly like your today; unless it’s a weekend, in which case it’ll be almost exactly the same as last weekend. You’re welcome: that’ll be ten quid. It is a truth that life’s events – and, by extension, computer operations – ar… Read more
0
1
04 October 2011
04 October 2011

Introduction to Virtual Private Databases

0
1
  You know the story. A group of blind men come across an elephant and each one feels a part of it. One touches the tusk and goes away thinking elephants are pointy, hard and sharp; another feels its side and is amazed at how wide and featureless elephants are; and one unfortunate man feels the elephant up its backside,… Read more
0
1
06 September 2011
06 September 2011

Introduction to Regular Expressions in Oracle

0
2
Regular expressions – RegEx or RegExp to their friends – were fashionably late in coming to the Oracle party. The seeds of what we know today as regular expressions were formulated in the period immediately following the Second World War in fields as diverse as formal language theory and neurophysiology; but it wasn’t until the PL/SQL Web toolkit arrived for… Read more
0
2
18 August 2011
18 August 2011

Autonomous Transactions in Oracle

0
1
Autonomous transactions are a bit like that dark part of the forest, beyond the rickety bridge, where the shadows are shaped like witches and bats swarm soundlessly from the trees. We all know it’s there, but the wise are in no hurry to visit. Here, however, is a definition: an autonomous transaction is a completely independent transaction that is started… Read more
0
1