(Dbaharrison) It’s been a long while since my last post, workload has been crazy this past couple of months. Everything has gone cloud, we are in full on “cloudification” mode and it’s consuming all of my time to the point where hands on oracle is something of a rarity these days…..

(Jeff Smith) I’ve talked about keyboard shortcuts before…

(Kris Rice) Oracle REST Data Services 3.0.7 went out yesterday. There’s an important change that went in to better secure installations by default. It has always been the case that we recommend customers set the validations for the plsql gateway.

(Lucas Jellema) One of the interesting tidbits, somewhat hidden away in Thomas Kurian’s keynote presentation last week at Oracle OpenWorld 2016, is a new member of the Oracle PaaS Cloud Services family called Oracle Functions (or at least that seems to be the working title). Oracle Functions are ser

(Ben) In this article, I’ll explain what the Oracle NCHR function is and show some examples.

(Uwe Hesse) A logical error happened in one Pluggable Database. A PDB Point-In-Time-Recovery rewinds it while the others remain available and stay as they are.

(Natik Ameen) Question: When executing a procedure I am getting “ORA-04031 Unable to Allocate Shared Memory” error. How do I avoid this error?

(Ben) Calculating the mean, median, and mode in Oracle SQL is a task often performed by report developers or anyone else working with SQL. Learn how to calculate these three values from a range of data in this article.

(Martin Bach) Does this question sound familiar? “We are running the exact same workload in UAT as we do in production, but it behaves completely different. Can you help?”

(Christian Antognini) Today I started having a look to the Oracle Database Exadata Express Cloud Service announced last week at Oracle OpenWorld. Note that since the amount of resources provided (in summary, 1 OCPU, 20 or 50 GB of database storage) is very limited, in general, in my opinion that ser