sql – Learning is not a spectator sport

The Fractional Part of a TIMESTAMP. Be careful.

This discovery came in from an AskTom customer but I figured it’s worth passing on to any PL/SQL programmers out

So after my post yesterday about PL/SQL being a no-brainer to get an easy boost to application performance, there was

I rarely blog about PLSQL for a very simple reason. It quickly becomes like Halloween night because all the ghouls

Handling default values on columns has been an age old problem that we solved in 12c with extensions to the

Just a re-post of something I put on StackOverflow last year so I can refer back to it easily. What

Just a quick tip for this post today. I had a question come in asking how to detect whether a

The more you play with SQL macros, the more you find simple but powerful use cases which will make life

Just an addenda to what I posted last week about downloading the Formula 1 motor racing data where I provided

Thanks for attending my talk on Futuristic SQL during Database World.If you missed it, or want to rewatch it at

An AskTom customer asked the question recently: “We often use the SQL_ID to dig into the performance views once we