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 a burglar and clamber in... 01 March 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 clothing – varchar2, clob, float,... 02 February 2017 12 min read
David Njoku Oracle for Absolute Beginners: Part 8 – Database Design and Normalization A wise man once said, I know one thing: that I know nothing. If you’ve followed this series from the very beginning I am hoping... 27 June 2014 7 min read
David Njoku Oracle for Absolute Beginners: Part 7 – Creating Tables, Constraints and Triggers A wise man once said: start at the beginning and go on till you come to the end: then stop. We’ve done things a little... 10 June 2014 9 min read
David Njoku Oracle for Absolute Beginners: Part 6 – Procedures and Functions A wise man once said, insanity is doing the same thing over and over again but expecting different results. If that is the case then... 07 May 2014 13 min read
David Njoku Oracle for Absolute Beginners: Part 5 – PL/SQL A wise man* once said, all software programming is about hoops and loops. You take some variables, give them hoops to jump through and, depending... 07 April 2014 13 min read
David Njoku Oracle for Absolute Beginners: Part 4 – Multi-table queries Part 1, Part 2, Part 3 A wise man* once said: To build the Great Wall of China, you must start with a brick. In... 03 March 2014 10 min read
David Njoku Oracle for Absolute Beginners: Part 3 – Update, Insert, Delete Part 1, Part 2. A wise man* once said: So no-one told you life was gonna be this way. Your job’s a joke, you’re broke,... 13 February 2014 10 min read
David Njoku Oracle for Absolute Beginners: Part 2 – SQL A wise man* once said, no one’s ever learned how to cook just by reading recipes. And so, since we painted in the background in... 13 January 2014 13 min read
David Njoku Oracle for Absolute Beginners: Part 1 – Databases A wise man* once said, an expert is someone who uses big words and acronyms where simple phrases would do just as nicely. So stand... 10 December 2013 8 min read
