Since 12c we have had the cool IDENTITY column feature which removes the tedium of creating sequences, triggers and the like to maintain a simple surrogate column (typically a primary key). SQL> create table t ( x int generated always as identity , y int); Table created. SQL> insert into t (y) values (10); 1 ..read more

Recently I posted a video about some best practices for adding/enabling database constraints to minimize disruption to other users on the system. Check it out before proceeding with the rest of this post. One of the examples in the video described how you could reduce the time to validate constraint by doing so in parallel ..read more

Lets say someone has sent me a simple text list, and I’d like that to be accessible as SQL. Advanced Security Administrator's Guide Application Developer's Guide - Advanced Queuing (AQ) Application Developer's Guide - Fundamentals Application Developer's Guide - Large Objects (LOBs) Application Developer's Guide - Object-Relational Features Application Developer's Guide - XML Applications InterConnect ..read more

First and foremost, a tip of the hat to Oracle ACE Lucas Jellema, who provided the initial inspiration for digging into the OpenWorld session catalog page to data mine its content. As I posted just before CloudWorld My strictly off the books, strictly unofficial CloudWorld agenda app in APEX is back for another year. The ..read more

We’ve all been there… You head over to the Session Catalog for CloudWorld and you want to download the files for all of the sessions you have been to, and all of the sessions you have missed. Then you discover… you need to click on each session to see the file name to download…. Ugh ..read more

Just a quick heads up for developers and DBAs that are using Text indexes when upgrading to 23ai. In the docs for Text Indexes, we have always mentioned that you will need to do some grants on the appropriate CTXSYS packages in order to perform some of the metadata operations associated with Text indexes. In ..read more

Last year alongside the release of Oracle Database 23c, we made some UI changes to the documentation. Tim Hall did a review of the changes and had one major criticism. A number of people (both internal and external to Oracle) agreed with that sentiment.  If you looked at the way the docs worked before this ..read more

I poke around the internet a little bit, and I often stumble upon content like the following: That kind of stuff absolutely bamboozles me. I’ve been around the IT industry for, well, lets just say “a number of years” ? and a consequence of that duration is that I’ve worked with a lot of languages ..read more

I’m going to have to be up front with you here. If your focus is Database, then Thursday is going to be a nightmare because every timeslot has a plethora of “must not miss” sessions. My best advice to you would to be either bring a friend, or make some new friends at the conference ..read more

Yes folks it’s back! My strictly off the books, strictly unofficial CloudWorld agenda app in APEX is back for another year. The easy, fast and flexible faceted search of APEX that you know and love, combined with the ability to download calendar entries for the sessions you want to see at CloudWorld, and most importantly ..read more