New Podcast Episode! Why every DBA should learn APEX

PublishedJanuary 6, 2022

•1 min read

The very name of the product – Application Express (APEX) – suggests that this is a tool solely for building applications, and thus it should belong solely in the realm of developers. But that is underselling the ability of APEX to be a perfect use case for a different IT demographic – the Database Administrator. In this episode I present my reasons for why APEX is a vital part of the DBA toolkit, and how a DBA using APEX can free up their time to more efficiently manage the databases in their organisation.

Enjoy!

#uncategorized

Comments

Join the discussion

No comments yet. Be the first to comment.

More from this blog

Faster operations with CLOBs

Somewhere around version 9 (maybe before, maybe later…all so long ago 😀) the distinction between CLOB and VARCHAR2 became less defined. This was a good thing because the typical operations you would do with a VARCHAR2, for example, SUBSTR, REPLACE, ...

Dec 6, 20224 min read

The cost of DBMS_PARALLEL_EXECUTE

I had an inquiry about the performance of DBMS_PARALLEL_EXECUTE today from a customer. Whilst the utility (as the name suggests) is designed to break up a large task into smaller chunks and then run those in parallel, the customer asked what was the ...

Nov 30, 20224 min read

Google-like search for your entire application

I published a video today showing how to use a Text index to pick up search terms from multiple tables to allow a “Google-like” search across your entire application or even your entire database. The video walks through a lot of background on how Tex...

Nov 23, 20225 min read

I did not write this blog post

In fact…no-one wrote this blog post! Here’s a little bit of fun for you. I was doing my normal doom scrolling through Twitter and came across an advertisement that claimed an AI engine could write my blog posts for me! So I went to the site, typed in...

Nov 11, 20223 min read

From stateful to stateless PL/SQL

I’ve done a lot of talks mainly around the tremendous performance benefits you can get just by employing a little bit of PL/SQL in the core parts of your applications. This advice has been valid for as long as PL/SQL has existed. And PL/SQL has been ...

Nov 9, 20226 min read

Learning is not a spectator sport

28 posts

Hi I'm Connor McDonald. I love playing with and exploring the Oracle database. But most of all I like seeing people succeed with the technology.

Command Palette

Comments

More from this blog