Please practically plan your prezi presentation

At the 2011 AUSOUG Conference I gave a presentation on simply called Oracle Apex 4.1 Security.The exciting thing was (well, I thought it was exciting) I gave powerpoint the flick and used Prezi instead. I’ve got oraclenerd to thank for putting me onto …

ASCII table listing from SQL

Today I was chasing the relevant ASCII code for certain characters… I know there are plenty of ASCII tables on the net, but this is an interesting SQL solution, nonetheless.select rownum “dec” ,chr(rownum) “char” ,to_char(rownum,’XXXX’) “he…

My name is Scott and I have a pet tiger

It seems I drafted this one about 18 months ago, worth sharing…Me (back in 2000):”Hi, my name’s Scott. I’m your new developer”My First DBA:”Here’s your db account, just don’t change your password to ‘tiger’”Well, it wasn’t quite like that, but it was…

Compound primary keys in Application Express

| Jan 24, 2012 17:00 +0000

As many Apex developers are aware, there is a limitation on the number of columns in a compound primary key when creating forms out of the box.This was alleviated in 4.1 by the ability to use ROWID to identify the record.I was asked the question recent…

Mr Amazing, is gone…

| Jan 23, 2012 05:33 +0000

Random co-incidences happen all the time. Sometimes we notice them, other times we don’t. Sometimes they are remembered for a lifetime.Today I arrived at work to do some on-site training and noticed an ambulance roaring along the other way. The recepti…