If you try and add: A mandatory column Without a default To a table containing data It's null for every row => you'll get an error @nakdimon.bsky.social checks how Oracle AI Database optimises this to error instantly ...and notes an edge case to be aware of

Optimization of NOT NULL Constraint Creation - @DBoriented

Several years ago I wrote a series of 8 posts about constraint creation optimization. I think it’s time to add some more posts to the series. I showed there, among other things, that Oracle does a…

buff.ly

@nakdimon.bsky.social helps our SQLs to find pattern in our data with MATCH_RECOGNIZE #AOUG2026 #OracleACE

New in Oracle Database #26ai - Aggregation Filters using the FILTER clause in #SQL. db-oriented.com/2026/02/06/a... @oracleace.bsky.social @sym42.bsky.social

The promise … … the secret: #DOAG2025 @nakdimon.bsky.social

Tomorrow I will give a presentation about EBR at #DOAG2025 in the Sydney room. I'm excited because my first-ever presentation abroad, 11 years ago, was at the same conference, in the same room, on the same topic (but a different presentation, and a bit more experienced speaker).

🎤 Don’t miss DOAG Konferenz + Ausstellung 2025 — Nov 18–21, the premier event for database technologies in the German-speaking region! Join #OracleACE experts and industry leaders for in-depth sessions on Oracle tech, modern IT trends, open source, and more. 👉 anwenderkonferenz.doag.org/de/home/

A huge thank you to all who made this #DCD25 possible: the speakers and the organizers! #nloug

🇳🇱 Mark your calendar for nlOUG Database Cloud & Developer Day—Nov 13 in Utrecht! Join #OracleACE experts and the Oracle tech community for inspiring keynotes, hands-on sessions, and the latest in Database, Cloud, and AI. Info & registration 👉 nloug.nl/en/events/au...

A little pre fun for (some of) our speakers and organisation for the #dcd25 day at our speakers dinner. They all can't wait for tomorrow! #thankyou #oracle #octemea25

Are you ready for the Database Cloud and Developer Day next week? Download the app on your mobile and make sure you add your favorite presentations to your schedule now! App: apps.nloug.nl/ords/r/nloug... Check out more details at: nloug.nl/en/events/au...

Today marks the countdown of two weeks until the Database Cloud and Developer Day. Will you be joining us there? Visit: nloug.nl/en/events/au...

Edition-based redefinition enables zero-downtime app upgrades for Oracle AI Database @nakdimon.bsky.social discusses why it's worth using when offline upgrades are OK: Any time or length upgrades Separate database & app upgrades Flexible release of new versions

EBR - Even If Downtime Is Acceptable - @DBoriented

So, You Don’t Need Online Upgrades EBR is a set of features that enables patching and upgrading live Oracle-based applications in an online fashion, with zero downtime. If you are responsible for an…

buff.ly

Looking forward to be at #HrOUG2025 🤩 A great conference, with excellent venue, content, speakers and attendees! See all the details here: 2025.hroug.hr/eng

Joel Kallman Day 2025 : Announcement oracle-base.com/blog/2025/09... #JoelKallmanDay @oracleace @OracleAPEX #orclapex @OracleDatabase

* SAVE * THE * DATE * Mark your calendars! On Nov 13th, join us for a day packed with Database, Cloud, and Developer excitement. Esteemed speakers from across the #EMEA region will be participating. Check out more details at nloug.nl/events/najaa.... #orclAPEX #oracle #DC&D2025

Honored to be chosen as "Speaker of the Day" by @sessionize.com . I'm grateful for the opportunities to share knowledge, learn from others, and engage with the amazing tech community. #PublicSpeaking #KnowledgeSharing #Oracle #Moovit @oracleace.bsky.social @sym42.bsky.social @iloug.bsky.social

I've just written a SQL query that uses GROUPING SETS and the COLLECT function, and it fails with ORA-3001 (unimplemented feature). I googled it and the first result showed that I had already discovered it 6 years ago 😳 db-oriented.com/2019/06/29/g...

📰 Check out my reading list for the 2nd week of July 2025

Reading List – July 2025 #1

📰 Mixed Feelings About MERGE - DBoriented talks about his "like-dislike" relationship with the MERGE statement and demonstrates some of the statement's nuances. 📰 SQL Plus and SQLcl Formatation Tip for Macbook users - Maicon Carneiro highlights a productivity tip for copy/pasting SQL prompt outputs. 📰 Better support for JavaScript’s console.log() in ORDS handlers - Martin Bach demonstrates Oracle REST Data Services' better handling of JavaScript…

geraldonit.com

A new post (about an old feature) - "Mixed Feelings About MERGE" db-oriented.com/2025/07/12/m... @oracleace.bsky.social #ACED @sym42.bsky.social

Excited to have my article on Oracle Constraint Creation Optimization in the latest issue of @nloug.bsky.social 's magazine, alongside articles by @thtech.bsky.social and Luc Bors: nloug.nl/en/nloug-vis... #database #optimization #performance #availability @oracleace.bsky.social @sym42.bsky.social

A proud member of the #OracleACE program for another year 😊 Thanks @oracleace.bsky.social 🙏

New video! In the age of internet applications, is PL/SQL no longer required? youtu.be/6T3U3D23Z60

Is PL/SQL dying?

YouTube video by SQL and Database explained!

youtu.be

The CfP for #octemea25 is open for 2 more weeks. Have you submitted yet? tinyurl.com/octemea25 @oracleace.bsky.social

Join ITOUG Tech Day 2025 this week in Milan. The streams will include Database, APEX, and Analytics & AI. Register for free and hear from many great ACE speakers ♠️ 👉 itoug.it/eventi/itoug... #OracleACE

I'm looking forward to the upcoming weeks. I'll be presenting at 3 conferences in 2 weeks - something I haven't done in a while, but I couldn't miss out on any of these excellent conferences. #OUGN2025 #itougtd2025 #MakeIT2025 @oracleace.bsky.social #ACED @sym42.bsky.social

מפגש איילוג הקרוב ביום שלישי 25/3/25. מספר המקומות מוגבל. אנא הקפידו להירשם. bit.ly/iloug-25-03-25 @iloug.bsky.social @oracleace.bsky.social

Excited to renew my #EBR blog post series after a 6-year break! The new post is about an exception to one of the fundamental rules of Edition-Based Redefinition. @oracleace.bsky.social #ACED @sym42.bsky.social db-oriented.com/2025/01/08/e...

A different point of view on Edition-Based Redefinition. Even if you don't *need* #EBR, using it may improve your quality of life. db-oriented.com/2024/12/30/e... @oracleace.bsky.social @sym42.bsky.social

EBR - Even If Downtime Is Acceptable - @DBoriented

So, You Don’t Need Online Upgrades EBR is a set of features that enables patching and upgrading live Oracle-based applications in an online fashion, with zero downtime. If you are responsible for an O...

db-oriented.com

Happy New (Square) Year 🤩 db-oriented.com/2025/01/01/h...

A different point of view on Edition-Based Redefinition. Even if you don't *need* #EBR, using it may improve your quality of life. db-oriented.com/2024/12/30/e... @oracleace.bsky.social @sym42.bsky.social

EBR - Even If Downtime Is Acceptable - @DBoriented

So, You Don’t Need Online Upgrades EBR is a set of features that enables patching and upgrading live Oracle-based applications in an online fashion, with zero downtime. If you are responsible for an O...

db-oriented.com