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 …
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…
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…
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…
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…