sql – Learning is not a spectator sport

Get the SQL_ID for a SQL statement BEFORE you run it

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

A friend threw me a puzzle yesterday which I thought would be challenging, but turned out to be easy to

(Familiar with case-insenstive collation already? Skip ahead to the “Side Effects”) A history of failed applications Before Oracle 12, a

I tweeted out this pic yesterday which suggested that by running a SQL query, I could magically keep my OPatch

There are plenty of tools out there that you can use to get DDL scripts for various objects in the

I’m a big fan of giving developers the tools they need to tune their applications in Production if that is

We all know from our data modelling days… (Sidenote: Remember those days? You know…when we used to think about good

As friend Bruno put it so eloquently… …but every day is a good day to do some SQL. So here’s

There has always been that odd conflict between the language you use for SQL versus the language you use for

One of the most commonly hit questions on AskTom is how to count the number of work days (Mon =>