Anyone that follows me on the socials knows that I m pretty keen on security. Whilst all those other day-to-day things like performance and uptime etc etc are all important, rest assured; people will generally forgive you for being down for a while; they will forgive you for being slow for a while, but they will [ ]
I wrote a post a few years back (well, actually it was 2018!) but I ll paraphrase briefly. There are two common schools of thought when it comes to automatic generation of values for a surrogate key in the Oracle database. The first one is using a SEQUENCE, referencing it either directly in your table definition/SQL, [ ]
I posted recently about the usage of APEX collections, a generic structure in APEX that lets you easily store a set of results without having to create a table in advance. It s easy to use and useful but I think it may have fallen into overuse. Good friend Jon Dixon replied on my post saying [ ]
I have a presentation that I ve given from time to time over the years and it s called the bullet point myth . The main thrust of the presentation is that if you look at a high enough level then all databases can be considered equal. At the highest and most generic levels, it s easy to claim [ ]
What would you do if everything in your environment looked perfectly fine, the data looked correct and yet every time you query a table, the query crashes with some sort of error? Yes, here I am back banging the drum about taking care with your data types 😊. In today s example I m going to show [ ]
I m currently here in India for the Sangam conference, and I m always a fan of coming to India, because there is always an adventure. Coincidentally at breakfast this morning, I was telling one of the first-timer speakers that India is so good for repeat trips, because something is different every time. Now truth be told, [ ]
I had a question the other day that constantly pops up on my feed whether it s on social media or people asking Q A at a conference etc. And that question is What is the best tool I should be using for my database management and app development? And it s fair to say I generally get [ ]
In all recent versions of the database you can call DBMS_UTILITY.EXPAND_SQL_TEXT to get the true version of a SQL that the database will run. It takes your SQL as input and returns a CLOB, which means its all a bit fiddly if you have a SQL statement already sitting in your SQLcl/SQLPlus buffer. Using a [ ]
By way of background, a while back I did video called My New Favourite Join on the LATERAL clause. The reason I like it is that it lets you solve a problem by composing little pieces together rather than writing one enormous query. Now this post is not about LATERAL, but I ll show a quick [ ]
I m sure you ve all heard the tale of Goldilocks and the Three Bears, but I d like to apply the Goldilocks principle to a database object-namely, a materialized view. You might be thinking, how does that apply to database objects when it comes to things like not too cold, not too hot, or not too heavy, [ ]
Many years ago, before I joined Oracle, I was working on a major modernisation project. We were replacing an existing non-Oracle system with an entirely new Oracle database application written from scratch. Not long after deploying a new version into our test environment, the results came back and a large number of tests had failed. [ ]
In my usual twitter doom scrolling, I came across this post the other day Now it s pretty obvious to me that this is one of the standard engagement bait posts that are commonplace nowadays. It s designed to polarize opinions and thus the resultant discussion becomes a lot more inflammatory and thus succeeds the goal of [ ]
Obviously there are plenty of folks in the Oracle APEX team with waaaayy more experience in APEXlang than I have, so this isn t an in-depth expose into all of the nuts and bolts of APEXlang. For that, I recommend you check out the AskTOM Live sessions where the APEX team are holding regular deep-dives on [ ]
In the previous post we saw that even though we had done an exchange partition mid-flights through a query execution, the query kept on running to successful completion. The database managed to find the data from the exchanged partition and keep on executing. The logical next question is is that always the case? What [ ]
Some times I m blown away by how the database will try very hard to save you from yourself :-). Consider the following example: I ve got a table called T. It s got two columns, X and Y, and it s partitioned into four partitions, the values being based on X, 1, 2, 3 and 4 for the [ ]
Here s a little secret APEX performance hack if you are running on the Autonomous database. As background, I m running an Autonomous database with six CPUs and a terabyte of storage. Let me grab a good sized chunk of that terabyte with a single table. I just kept duplicating copies of DBA_OBJECTS until my table got [ ]
Its never been easier to analyze an AWR report. With our new oracle skills repository, your favourite agent can do a respectable job giving some insights into the AWR report you created for your database. In my case, once codex has churned through the report using its various skills, the driving recommendation was as below [ ]
For about the last hmmm maybe decade or more, when you downloaded a release update from MOS for your database, the patch would consist of a single folder which was the patch number. You would unzip that to temporary location, download a fresh copy of OPatch and then patch your database. OPatch would take the [ ]
Hopefully you have just seen that APEX patchset bundle 16 has just been released for 24.2. Of particular note is that a well-publicised Chrome change to deprecate the unload event created some issues in APEX. I regularly create fresh databases to handle questions on AskTOM or for demos in my videos or at conferences, and [ ]
So I jumped onto an LLM and asked it to give me some PL/SQL to handle a 3-step series of DML statements and out popped the following code: That all looks fine, and the coding style is definitely not unique to LLMs. I see it everywhere. It is always the familiar pattern: begin [dml] [dml] [ ]