-
Kris Kringle the Database – WIDTH_BUCKET
Whether you call it “Kris Kringle” or “Secret Santa“, there’s much pleasure in giving small gifts to people over the Christmas period. So rather than fully fledged blog posts, I’ll wrap up this year with a series of daily quick tips on the Oracle Database. Ho Ho Ho ! If you are ever looking for Read more
-
Kris Kringle the Database! – Truncate and Indexes
Whether you call it “Kris Kringle” or “Secret Santa“, there’s much pleasure in giving small gifts to people over the Christmas period. So rather than fully fledged blog posts, I’ll wrap up this year with a series of daily quick tips on the Oracle Database. Ho Ho Ho! If you are loading a table, often Read more
-
UPDATE SET ROW – Convenience Might Be Costly
A cool feature in PL/SQL is the ability to perform common DML operations without needing to reference the individual columns of a table. The ability to do a “SELECT *” into a ROWTYPE variable dates as far back as Oracle 7, but the benefits of that were limited because the moment the needed to issue Read more
-
Highlights from the EMEA tour
Just a quick snapshot of the EMEA tour, which I hope inspires you to get involved next year as either a speaker, user group volunteer or even as simply as attending and supporting your local user group. Poland I couldn’t quite understand why my flight to Poland left on time, but still landed 90 mins Read more
-
SQL*Plus access without an OS login
When it comes to unloading data, often we would like to run SQL*Plus directly on the database server to avoid the network latency cost of dragging the resultant data down to your client. But (quite correctly) you probably do not have permissions to login to the server, because that opens up a giant security issue. Read more
-
Better JSON – from CLOB to BLOB
When many of us jumped into the JSON soup and started playing with all of the JSON goodies in the Oracle Database, because JSON is just plain text, we naturally assumed that the logical place for storing our JSON data was in a CLOB column. The database understood JSON so we could ensure that our Read more
-
PL/SQL and mistaken IDENTITY
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
-
Validating Constraints – An alternative approach to the alternative approach!
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
-
Quick 23ai Tip – Simple list to SQL
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
-
How I scraped the CloudWorld catalog
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
-
The CloudWorld 2024 mega download!
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
-
Oracle Text in 23ai
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
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Learning is not a spectator sport 