Learning is not a spectator sport

PL/SQL performance in 19c

I gave a talk at Kscope21 yesterday about common mistakes that we make during the database development cycle. To kick

I posted late last year about how to query APEX patch updates directly from the database. Now that APEX 21

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

If you have worked with Oracle technology you will be familiar with Oracle Magazine. For many of us, it was

Generally speaking, if you have a giant chunk of data over “here”, and you need to load it into a

It’s a return to the focus of “Back to basics” in my latest episode. Pick up a reference book and

Why interval partitioning is cool Before 11g, partitioning a table immediately stepped up the responsibilities of the database administrator, because

If you’d like to share a memory of Joel, please head over to http://apex.oracle.com/joel Joel’s kind-heartedness can best be seen

Glance through any text book, blog post, video tutorial etc on the topic of database indexes and you’ll typically chance

The Oracle documentation set is my bread and butter for day to day work. With AskTom questions, StackOverflow question, Einstein