Run top-N queries with FOR UPDATE in Oracle #SQL from 23.26.4:
SELECT ...
FETCH FIRST n ROWS ONLY
FOR UPDATE
Add SKIP LOCKED to enable many batch processes get and lock the next N rows in parallel
All the tools updated for 26.3.1 today, ORDS, SQLcl, and of course SQL Developer for VS Code.
Lots of bug fixes, some important security updates including 3rd party library updates, and a new feature here and there.
Oh, and a new logo. SQLDev is your APEXlang IDE. That's logo-worthy.
Is fighting with duplicate rows in #SQL a common challenge for you?
Dani Schnider shows options you can use to detect and remove them
DISTINCT
GROUP BY HAVING COUNT (*) > 1
QUALIFY RANK () OVER ( ... ) = 1
And covers their pros & cons https://t.co/7SsqlW21N2
What does trusted AI require?
At #OracleAIWorld, @jrloaizam unveiled Oracle’s Deep Trust AI Architecture—bringing to AI what Maximum Availability Architecture brings to resilience.
Watch the replay: https://t.co/98WaWAj4Ya
(بين يدي الساعة: #الجمعة كاليوم)
رأيتم كيف يمرُّ الأسبوع مَرَّ السَّحاب.
ثبت عن النبي ﷺ قوله: «لا تقوم الساعة حتى يتقارب الزمان، فتكون السنة كالشهر، ويكون الشهر كالجمعة، وتكون الجمعة كاليوم، ويكون اليوم كالساعة، وتكون الساعة كاحتراق السعفة». أخرجه أحمد.
⦿ تسارع الأيام المذهل، وانصرام الأوقات الخاطف، أمرٌ واقعٌ مشاهدٌ محسوسٌ.
⦿ وهكذا عمر الإنسان: تمضي أيامه وسنواته وعقوده سراعًا، وكأنها حلم.
⦿ والموفَّق السعيد من عقل وتبصَّر، وتخفَّف من أشغال الدار الفانية، وتزوَّد للدار الباقية، وسارع في الخيرات، وبادر بالصالحات، واستكثر من القربات، قبل هجوم المدهشات.
Enable blocked Oracle #SQL DML statements to timeout with the [NO]WAIT clause, e.g.:
INSERT ... NOWAIT
UPDATE ... WAIT 42 SECONDS
DELETE ... WAIT 42 MILLISECONDS
Added in 23.26.2, this raises an ORA-54 if the DML is blocked by another transaction
No more waiting forever!
خطيب في خطبة الجمعة اليوم بالكويت:
- صاحت فلسطين، فلبّت السعودية النداء وأرسلت أبناءها.
- صاحت الكويت، فلبّت السعودية، فأرسلت جيشها وفتحت قلوبها قبل بيوتها.
- وقعت قطر ودبي في أزمة مالية بالستينيات الميلادية، فالتفتوا للسعودية ومنحتهم الأموال.
- وقعت البحرين في أزمة أمنية، فأرسلت السعودية جيشها.
-
One of the most powerful performance tuning methods is clustering data: storing the rows you want together
Neil Chandler shows how to do this in Oracle Database with the
CLUSTERING BY LINEAR ORDER ( ... )
table property physically sort rows on disk
https://t.co/G1z43Y94b4
Production AI automation takes more than connecting a few apps.
In this course, you’ll learn how to use n8n for AI workflows, agents, multi-agent systems, APIs, and self-hosted automation.
It also cover retries, human approvals, observability, and other patterns for running automations reliably.
https://t.co/4GbNwxjh5X
Get a #JSON description of Oracle Database tables, views, and indexes with
DBMS_DEVELOPER.GET_METADATA
This is a simple and fast way to get their details
Control the detail with the level parameter
BASIC => Essential info
TYPICAL => Standard
ALL => Comprehensive
The easy way to plan your AI World...use AI!
Here's the database-focussed itinerary it suggested. If you're coming to AI World, pop over to the demo booths and say Hi! If you want a copy of the itinerary, you can grab it from my blog https://t.co/XPFAYILSt3
The 2026 Developer Survey results are almost here! To help you prepare, we’re diving into 15 years of survey results to see how software development has changed over time. We’re looking back at everything from the evolution of AI to how work has changed to the tools technologists are using to create software.
Explore findings from the last 15 years of the Annual Developer Survey: https://t.co/9GVwS7Un4k