Just a reminder for all those folks that just because we're saving ourselves network latency by working with Oracle Application Express,...

I was talking with Penny Cookson recently about the supplied procedure wwv_flow_utilities.export_application_to_clob to automatically expo...

How many times do you think you've ever written something like this nvl('x',user) Small cost? What if you executed it all the...

In the experience I've had, I've found NVL such a ubiquitous expression. I started my Oracle career on 8.1.7, and it was the only ex...

Today a colleague of mine found some indexes on a system he was working on that didn't look quite right. He checked out the definition a...

Sometimes relating to scale can be difficult for our humble brain. Often in Oracle we talk about millions of rows, terabytes, cartesion jo...

Here is a simple instruction set to get you started on creating an Apex page that interfaces with BI Publisher to produce what's essenti...