Articles tagged

01 March 2017
01 March 2017

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 through a bathroom window, while the neighbourhood kids all watched and giggled, probably taking secret photos to share on Snapchat or something.  Embarrassing, yes, but what’s it got to do with Oracle? Well, the point… Read more
02 February 2017
02 February 2017

Oracle for Absolute Beginners: Date, Timestamp and Interval

0
42
All databases stand on a tripod of datatypes: strings, numbers and dates. And though they might dress them in fancy clothing – varchar2, clob, float, integer – strings are really just strings, and numbers are really just numbers. But dates — dates are interesting. In this article I’ll talk to you about dates, about time, and about how both ar… Read more
27 June 2014
27 June 2014

Oracle for Absolute Beginners: Part 8 – Database Design and Normalization

0
11
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 that you’ve gone from knowing absolutely nothing about Oracle database programming to this point where you know the foundations, know how the parts fit together – basically, know enough to know that there’s a who… Read more
07 May 2014
07 May 2014

Oracle for Absolute Beginners: Part 6 – Procedures and Functions

0
42
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 no one’s saner than a computer programmer*, because programming is executing the same code over and over again and expecting the same results. We’ve already talked about bundling up statements in anonymous PL/SQL blocks; now… Read more
07 April 2014
07 April 2014

Oracle for Absolute Beginners: Part 5 – PL/SQL

0
14
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 on their success or failure, you give them some actions to loop through a number of times. Might sound basic, but that’s what all software code – from Angry Birds to the space shuttle –… Read more
13 January 2014
13 January 2014

Oracle for Absolute Beginners: Part 2 – SQL

0
34
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 Part 1, we are now going to roll up our sleeves and dive in. By the end of this article you will be reading and writing SQL, the lingua franca of databases. [* that wis… Read more
10 December 2013
10 December 2013

Oracle for Absolute Beginners: Part 1 – Databases

0
107
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 back and listen to this: Database, Relational Database, DBMS, RDBMS, SQL, Sub-queries, normalisation. [* that wise man was me.] So now that I’ve established my credentials by bamboozling you with arcane words and capital letters,… Read more