Lightnews — Scholar-powered news

Oren Nakdimon @nakdimon.bsky.social · 15d

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

2 4

Reposted by Oren Nakdimon

Tim Hall @oraclebase.bsky.social · 21d

Joel Kallman Day 2025 : Announcement

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

#JoelKallmanDay

@oracleace @OracleAPEX #orclapex @OracleDatabase

1 13 20

Reposted by Oren Nakdimon

nlOUG @nloug.bsky.social · Aug 27

* 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

7 7

Oren Nakdimon @nakdimon.bsky.social · Aug 14

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

8

Oren Nakdimon @nakdimon.bsky.social · Jul 31

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

1 2

Oren Nakdimon @nakdimon.bsky.social · Jul 21

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

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

db-oriented.com

2

Reposted by Oren Nakdimon

Gerald Venzl @gvenzl.bsky.social · Jul 14

📰 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…

www.geraldonit.com

2 4

Oren Nakdimon @nakdimon.bsky.social · Jul 12

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

Mixed Feelings About MERGE - @DBoriented

Why Oracle's MERGE Statement Fails Where INSERT/UPDATE Succeeds

db-oriented.com

1 1 8

Oren Nakdimon @nakdimon.bsky.social · Jul 8

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

3 8

Oren Nakdimon @nakdimon.bsky.social · Jun 28

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

1 11

Reposted by Oren Nakdimon

Connor McDonald on Database and SQL @connormcd.bsky.social · Jun 3

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

7 9

Reposted by Oren Nakdimon

Mirela Ardelean @mirelarooug.bsky.social · May 19

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

@oracleace.bsky.social

4 6

Reposted by Oren Nakdimon

Oracle ACE Program @oracleace.bsky.social · May 19

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

4 7

Oren Nakdimon @nakdimon.bsky.social · Apr 28

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

2 11

Oren Nakdimon @nakdimon.bsky.social · Mar 3

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

1 2 1

Oren Nakdimon @nakdimon.bsky.social · Jan 8

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

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

db-oriented.com

1 3

Reposted by Oren Nakdimon

Oren Nakdimon @nakdimon.bsky.social · Dec 30

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

3 11

Oren Nakdimon @nakdimon.bsky.social · Jan 1

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

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

1

Oren Nakdimon @nakdimon.bsky.social · Jan 1

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

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

1 10

Oren Nakdimon @nakdimon.bsky.social · Dec 30

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