DML error logging redux
I posted a nice little feature of DML error logging recently, and a comment came in mentioned that caution is
The holistic SQL tuning series
I did a set of articles for Oracle Magazine on a more holistic view of SQL tuning. What do I
The definition of proof
One of the pieces of advice that I often see on the ‘net is that undo space is somehow this
A refreshing look at PIVOT
We had an AskTOM question come in recently where our customer was very excited about the PIVOT operator in SQL
All the OpenWorld 2019 downloads!
Why dig around for hours in the catalog? Here are all of the downloads registered in the OpenWorld catalog! You
Then OpenWorld mega-list
You’ve been to OpenWorld… You’ve seen the great content… Networked with the community… But now you want to keep the
Extending in-lists
A well known “limitation” of Oracle is that you can only have 1000 elements within an IN-LIST style expression in
