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