Quoted Identifiers #JoelKallmanDay
This post was originally published on this siteBackground and TL;DR Connor McDonald wrote a blog post named Cleaner DDL than DBMS_METADATA. Back then he asked me if it would be possible to let the formatter remove unnecessary double quotes from quoted identifiers. Yes, of course….
DOAG2022 Highlights
This post was originally published on this siteNobody knows what kind of restrictions we will experience later this year. That’s why the DOAG Conference + Exhibition 2022 took place in September instead of November. The organizers wanted an in-person event. While you can access some…
Azure Tip 13: How to delete an Azure Tenant and a painful error message “Unable to delete tenant”
This post was originally published on this siteWARNING: Following the instructions in this post will delete a lot of things that can not be recovered! If you really want to delete a tenant, MAKE SURE YOU ARE WORKING ON THE CORRECT ONE! The author of…
Book Review: “Faster: How to Optimize a System” by Cary Millsap
This post was originally published on this siteThere are many books on performance optimization, but this one differs in a few ways. It is more of an entertaining collection of short stories, but with many educational messages. My travel plans for the Kscope22 conference in…
Deleting Rows With Merge
This post was originally published on this siteThe merge statement allows you to insert, update and delete rows in the target table in one go. This is great. However, the delete part does not work as expected. Is it a bug? No, it works exactly…
Testing With utPLSQL – Made Easy With SQL Developer
This post was originally published on this siteNowadays, everything is about automation. Software testing is no exception. After an introduction, we will create and run utPLSQL tests with Oracle SQL Developer for a fictitious user story. Our tests will cover a PL/SQL package, a virtual…
plscope-utils for SQL Developer 1.0 – What’s New?
This post was originally published on this siteIntroduction PL/Scope is an SDK for source code analysis. It is available since Oracle Database 11g Release 1 and has been significantly improved in 12c Release 2. plscope-utils for SQL Developer is a SQL Developer extension that simplifies…
Last Week in Stream Data Integration & Stream Analytics – 13.7.2022
This post was originally published on this siteThis is the 247th edition of my blog series blog series around Stream Data Integration and Stream Analytics! As usual, find below the new blog articles, presentations, videos and software releases from last week. Happy reading and stay…
Housekeeping in Oracle: How to Get Rid of Old Data
This post was originally published on this siteHave you ever tried to delete a few million rows from a table with several hundred milllions of rows with a DELETE statement? If yes, then you know that this is a very bad idea. With Oracle Partitioning…