(Saurabh K. Gupta) Consolidation is a key enabler for Oracle database deployments on both public and private clouds. Consolidation reduces the overall IT costs by optimizing the operational and capital expenses.

(Dominic Brooks) Why you might want to think twice about using INSERT ALL.

(Jared Still) Here’s a common Oracle troubleshooting scenario when a SQL statement needs tuning and/or troubleshooting:

(boniest) In a recent release that I’ve been working on, we had to drop and recreate some of the unique/primary key constraints (due to columns being added into the constraint) on some of our tables.

(Ben) The CURRENT_TIMESTAMP function is one of the many time and date-related functions in Oracle. Learn how to use it and see some examples in this article.

(Richard Foote) For something that’s generally considered an extremely bad idea, I’ve lost count of the number of times I’ve come across applications that insist on storing date values as characters within the database. We’ve all seen them …

(David Fitzjarrell) Recently a PL/SQL blog post was illustrating the difference between MOD() and REMAINDER() and the results from REMAINDER looked … suspicious. The example, modified here to provide some context in the output, shows the ‘problem’ that some remainders are negative.

(Scott Wesley) Last month I wrote a post about CSS performance, including some performance test results.

(mdinh) This is really messed up. I chose GoldenGate because I did not want to mess around with streams.

(Hemant K Chitale) In my previous blog post, I have demonstrated using DBMS_SERVICE to create and start services.