Oren Nakdimon nakdimon - Bluesky Statics

Aggregation Filters - @DBoriented New in Oracle 26ai: the FILTER clause allows to restrict the rows considered by aggregate functions

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

06.02.2026 13:48 — 👍 1 🔁 1 💬 0 📌 0

How I Stopped Upgrading at Nights and Weekends, and Became More Relaxed and Productive

Edition-Based Redefinition

The promise …

… the secret:

#DOAG2025 @nakdimon.bsky.social

20.11.2025 09:06 — 👍 2 🔁 1 💬 0 📌 0

Here is a snippet from a post I wrote a year ago (db-oriented.com/2024/11/25/m...)

@doagev.bsky.social @oracleace.bsky.social @sym42.bsky.social

19.11.2025 13:03 — 👍 4 🔁 0 💬 0 📌 0

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).

19.11.2025 13:03 — 👍 9 🔁 1 💬 1 📌 0

🎤 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/

14.11.2025 09:43 — 👍 21 🔁 13 💬 0 📌 0

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

13.11.2025 14:20 — 👍 7 🔁 2 💬 0 📌 0

🇳🇱 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...

11.11.2025 11:23 — 👍 6 🔁 4 💬 0 📌 0

Speaker dinner dcd25

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

12.11.2025 20:35 — 👍 11 🔁 5 💬 0 📌 0

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...

06.11.2025 11:02 — 👍 3 🔁 3 💬 0 📌 0

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...

30.10.2025 08:13 — 👍 5 🔁 5 💬 0 📌 0

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…

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

30.10.2025 12:03 — 👍 1 🔁 1 💬 0 📌 0

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

30.09.2025 04:43 — 👍 4 🔁 2 💬 0 📌 0

Joel Kallman Day 2025 : Announcement

oracle-base.com/blog/2025/09...

#JoelKallmanDay

@oracleace @OracleAPEX #orclapex @OracleDatabase

24.09.2025 06:21 — 👍 20 🔁 13 💬 1 📌 5

* 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

27.08.2025 07:33 — 👍 7 🔁 7 💬 0 📌 2

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

14.08.2025 03:45 — 👍 8 🔁 0 💬 0 📌 0

Use dsinterval_unconstrained.
It is defined as interval day(9) to second(9).

31.07.2025 12:58 — 👍 2 🔁 0 💬 1 📌 0

GROUPING SETS and COLLECT Don't Get Along - @DBoriented I’ve recently got reminded that assuming something will work, just because it makes sense, doesn’t mean it will really work. While reviewing some code a few days ago, I saw a query of the following fo...

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...

21.07.2025 14:11 — 👍 2 🔁 0 💬 0 📌 0

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…

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

14.07.2025 00:52 — 👍 4 🔁 2 💬 0 📌 0

Mixed Feelings About MERGE - @DBoriented Why Oracle's MERGE Statement Fails Where INSERT/UPDATE Succeeds

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

12.07.2025 08:58 — 👍 8 🔁 1 💬 1 📌 1

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

08.07.2025 05:30 — 👍 8 🔁 3 💬 0 📌 0

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

28.06.2025 06:00 — 👍 11 🔁 1 💬 0 📌 0

YouTube video by SQL and Database explained! Is PL/SQL dying?

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

03.06.2025 03:47 — 👍 9 🔁 7 💬 0 📌 0

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

@oracleace.bsky.social

19.05.2025 19:41 — 👍 6 🔁 4 💬 0 📌 0

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

19.05.2025 15:21 — 👍 7 🔁 4 💬 0 📌 0

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

28.04.2025 19:17 — 👍 11 🔁 2 💬 0 📌 0

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

03.03.2025 18:14 — 👍 1 🔁 2 💬 1 📌 0

EBR – Part 13: The Trouble with Foreign Keys with ON DELETE Clause and Related Triggers - @DBoriented Yet another reason to avoid triggers. A specific case where triggers should be defined on tables rather than editioning views, when using EBR. This case involves foreign keys with the ON DELETE clause...

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...

08.01.2025 07:31 — 👍 3 🔁 1 💬 0 📌 0

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...

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

30.12.2024 09:08 — 👍 11 🔁 3 💬 0 📌 0

Happy New Square Year - @DBoriented Using SQL to see that 2025 is the only year in the 21st century that is a square number

db-oriented.com/2025/01/01/h...
🙂

01.01.2025 12:41 — 👍 1 🔁 0 💬 0 📌 0

Happy New Square Year - @DBoriented Using SQL to see that 2025 is the only year in the 21st century that is a square number

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

01.01.2025 08:16 — 👍 10 🔁 0 💬 1 📌 0

Posts by Oren Nakdimon (@nakdimon.bsky.social)