An occasional question in the forums relates to issues ordering a particular column. It's one of those things that will probably keep coming up, so it's worth having another reference out here on the web.
The basic example stems from the need to order data that might contain characters.
with data as (select '1' vc from dual union all select '11' vc from dual union all select '2' vc from dual union all select 'a' (more...)
My sister sent me this video not long after my daughter was born earlier this year - I finally watched it while cleaning up e-mails and I'm glad I did - I highly recommend you all take 2 minutes aside and just let these images of history wash through your brain.
If you think the first half had an air of familiarity, you might be thinking of this video from Carl Sagan - I certainly (more...)
I stumbled across a blogging milestone while fact checking what I was going to open this post with - for me this month represents 5 years of blogging.
In that time I've learnt heaps, met new people, changed blog name, visited other cities to speak, and dived deep into APEX after a long time in Oracle Forms, published a video series & was recognised as an Oracle ACE.
Turns out Packt Publishing are celebrating (more...)