Oren Nakdimon
@DBoriented
Followers
2K
Following
8K
Media
373
Statuses
2K
Oracle ACE Director; Fellow, Database Architecture at @moovit; Opinions are my own.
Joined August 2013
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
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...
0
0
4
RT @GeraldVenzl: ๐ฐ Check out my reading list for the 2nd week of July 2025.
geraldonit.com
๐ Oracle Database@AWS Now Generally Available โ Oracle announced the General Availability of Oracle Database on AWS. ๐ฐ Mixed Feelings About MERGE โ DBoriented talks about his โlikโฆ
0
3
0
Excited to have my article on Oracle Constraint Creation Optimization in the latest issue of @nl_OUG 's magazine, alongside articles by @thtechnology and @lucb_. Check it out: @OracleDatabase #optimization #performance #availability.@oracleace @sym_42
0
2
7
ืืืคืืฉ ืืงืจืื ืฉื #ilOUG - ืงืืืืช ืืฉืชืืฉื ืืืจืงื ืืืฉืจืื - ืืชืงืืื ืืืื ืฉืืืฉื 17/6/2025 ืืื ืืฉืขืืช 14:00 ื-18:00, ืืืฉืจืื ืืืจืงื ืืคืชื ืชืงืืื. ืืืฉืชืชืคืืช ืืืคืืฉ ืืื ื ืืจืืื ืืชืฉืืื, ืืืื ืืืืืืช ืจืืฉืื ืืจืืฉ, ืขื ืืกืืก ืืงืื ืคื ืื. ืืคืจืืื ืืืจืฉืื: @oracleace @oracleugs @OracleIL.
docs.google.com
*** ืขืืืื: ืืืืจ ืืืฆื, ืืืคืืฉ ืืชืงืืื ืืืื, ืืื ืืคื ืฉืคืืจืกื ืืชืืืื. ืงืืฉืืจ ืืืื ืืืฉืื ืืืืื ืื ืจืฉืืื ืืืืคืก ืื *** ืฉืืื ืจื. ืื ืื ื ืฉืืืื ืืืืืื ืืืชื ืืืคืืฉ ืืงืจืื ืฉื ืงืืืืช ืืฉืชืืฉื ืืืจืงื ืืืฉืจืื. ืืืคืืฉ ืืชืงืืื...
0
0
1
RT @Mirela_RoOUG: The CfP for #octemea25 is open for 2 more weeks. Have you submitted yet?. @oracleace @oracleugs hโฆ.
0
9
0
RT @oracleace: Join ITOUG Tech Day 2025 this week in Milan. The streams will include Database, APEX, and Analytics & AI. Register for freeโฆ.
0
5
0
RT @oracleace: OUGN 2025 is right around the corner! Join the largest Oracle conference in the Nordics from 14 to 16 May. Join the speakeโฆ.
0
2
0
RT @IT_OUG: ๐ขOggi presentiamo una delle speakers del nostro ITOUG Tech Day 2025 a Milano.@signal006 OracleAPEX24.2 sblocca nuove funzionaliโฆ.
0
3
0
RT @IT_OUG: ๐ฃEcco un altro speaker del nostro evento a Milano .๐@SpatialHannes ci spiega SpatialStudio attraverso uโฆ.
0
1
0
RT @IT_OUG: ๐ขSiamo lieti di iniziare a presentare gli speakers del nostro ITOUG Tech Day 2025 a Milano!.๐#itougtd20โฆ.
0
2
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. @OUGNorway #OUGN2025.@IT_OUG #itougtd2025.@sioug_si #MakeIT2025. @oracleace @sym_42.
1
0
12
RT @IT_OUG: Manca meno di un mese al Tech Day. per maggiori info.
it.linkedin.com
โฐ Manca meno di un mese al nostro ITOUG Tech Day 2025! ๐
Giovedi 22 maggio 2025 ๐ Via Massimo D'Azeglio, 4, 20154 Milano - Italia ๐ L'evento รจ gratuito, ma non dimenticarti di iscriverti ๐...
0
4
0
0
0
2
ืืคืืฉ #ilOUG ืืงืจืื ืืืื ืฉืืืฉื 25/3/25, ืืืฉืจืื ืืืจืงื ืืคืชื ืชืงืืื. ืืกืคืจ ืืืงืืืืช ืืืืื. ืื ื ืืงืคืืื ืืืืจืฉื: @iloug_org @OracleIL @oracleace @oracleugs
1
0
3
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 #ACED.@sym_42 .@OracleDatabase #EBR.
db-oriented.com
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...
0
4
9
RT @DBoriented: A different point of view on Edition-Based Redefinition. Even if you don't *need* #EBR, using it may improve your quality oโฆ.
db-oriented.com
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...
0
10
0
Happy New (Square) Year ๐คฉ.
db-oriented.com
Using SQL to see that 2025 is the only year in the 21st century that is a square number
0
0
4