I updated my SQL Assertion article with some maths and added the ALL ... SATISFY syntax that avoids double NOT EXISTS in Oracle Database SQL Assertions dev.to/franckpachot...
01.03.2026 09:50
👍 46
🔁 3
💬 1
📌 0
I updated my SQL Assertion article with some maths and added the ALL ... SATISFY syntax that avoids double NOT EXISTS in Oracle Database SQL Assertions dev.to/franckpachot...
All the news you can handle for all things Oracle database and cloud, TOMORROW
go.oracle.com/LP=152179?el...
Wir machen mit beim Trend:
„Create a caricature of me and my job!“ 🤖
Syntegris = IT-Mission 🚀
Oracle APEX, Java, BI, Security, KI wir bringen alles zusammen.
IT-Probleme? Wir biegen das für Sie. 😎
Welcher Bereich ist für Sie am spannendsten?
Thank you shout out to @jon.cloudnueva.com ! His post about IG selectionStateItem (new in APEX 24.1) just saved me a ton of time! #orclapex
blog.cloudnueva.com/apex-ig-proc...
Previously on @thatjeffsmith... Definitive guide to moving from SQL Developer to VS Code
📚 New Reading List is out!
This week, people dug into all sorts of new 🅾️ #Oracle #AI #Database features - definitely a must read to get you up to speed, and we got a couple of really 🤩 🎉 exciting announcements!
📖 Happy reading!
Top-N queries The table at the top is the input (from) The operation is ORDER BY NUMBER FETCH FIRST ... The results below show which rows are fetched for each of the alternatives ... in FETCH FIRST ...
Top-N queries The table at the top is the input (from) The operation is ORDER BY NUMBER FETCH FIRST ... The results below show which rows are fetched for each of the alternatives ... in FETCH FIRST ...
I'm working on diagrams to visualize how #SQL works
Here are examples comparing different options for FETCH FIRST
The table at the top is the input
Below it are the rows returned for different options for the dots in
ORDER BY NUMBER FETCH FIRST ...
Which diagram do you prefer? Other comments?
Was macht KI in der Datenbank? Was muss ich als DBA zu KI wissen? Und wo kann ich das mal ausprobieren? Antworten auf diese Fragen gibt es beim noon2noon - KI für den DBA am 10./11.02.2026 in Hannover
Weitere Infos: www.ora2know.de/event/noon2n...
🛠️ Oracle APEX 24.2 Patch Set Bundle 12 is available!
Learn More: apex.oracle.com/download
Known Issues: lnkd.in/gF2pJiKB
#orclAPEX
#apexconn26 | Die 12. Ausgabe der #orclapex Konferenz lockt uns diesmal in den Heide Park Soltau – und der Call for Papers läuft noch 8 Tage.
Wir haben für euch und eure Netzwerke & Profile über 30 coole Banner gestaltet. Gerne verwenden & weitersagen 🤩 scomp.ly/AC25media
#plsql #lowcode #nocode
The developer VM has been freshened up! Go get some!
www.oracle.com/database/tec...
Call for Papers for APEX connect 2026 18-20 May in Heidepark has started! This is your chance to share your experience about what you have been building using Oracle APEX, SQL and/or PL/SQL!
CfP ends on 2-DEC EOD.
apex.doag.org/en/home/
#orclapex
🤖 Oracle Datenbank & KI – was hat es damit nun genau auf sich?
Finde heraus worum es sich beim Thema DB und KI dreht, und zwar beim DOAG Dev Talk am 16.10. – kostenlos & garantiert ohne Buzzword-Bingo!
👉 meine.doag.org/event/id.939...
#Oracle #KI #DevTalk #DOAG
IEEE top programming languages for jobs in 2025 The top three are Python SQL Java
#SQL is second in the IEEE Top Programming Languages for jobs in 2025
Good going for a language that's over 50 years old!
spectrum.ieee.org/top-programm...
Joel Kallman Day 2025 : Announcement
oracle-base.com/blog/2025/09...
#JoelKallmanDay
@oracleace @OracleAPEX #orclapex @OracleDatabase
Spanish Food in tapas restaurant in Poznan
After conference meal in beautiful historic city of Poznan. #poug2025
Always a pleasure to meet old friends and make new ones!
@danischnider.bsky.social @oraesque.bsky.social @salvis.com @syntegris.bsky.social
It was a wonderful conference again! Thanks to @ora600pl.bsky.social @luizafrompoland.bsky.social and the whole POUG team for organizing #POUG2025
Such a great idea, I especially like the BY NAME enhancement for Insert .. select !
A very valuable blogpost - describing now only a new feature, but which thought process led to that specific implementation.
Get faster PL/SQL in #SQL with
alter session set sql_transpiler = on
=> database will convert eligible functions to SQL
Read my latest post for details on
What can be transpiled
Transpiler vs scalar macros
Functional differences
Impact of function-based indexes
blogs.oracle.com/sql/post/fas...
OpenAI just launched their first open model! Discover how to run it on your hardware and integrate its AI capabilities into your #orclAPEX apps.
#Ollama #PLSQL #Oracle
youtu.be/_o6jbdDqCR0
You don’t have to wait for 23ai for these features!
oracle-base.com/blog/2025/08...
@OracleDatabase #database #19c
Please welcome Lida Gholizadeh from Germany to the Oracle ACE Program! Lida's focus in APEX makes her a valuable asset to our global community. ♠️
Congratulations! 🎉
ace.oracle.com/ords/ace/pro...
#OracleACE
We found our location for APEX connect next year! CU there 18-20 May 2026 in Heidepark, Soltau! #apexconn26 #orclapex
📣 Friendly Reminder 📆 Morgen um 15:00 Uhr realisiert die DOAG in Zusammenarbeit mit der Low-Code Association e.V. die WebSession Nr. 3 (von 4) zum Thema #LowCode – die WebSession ist gratis 🤩
Agenda & Anmeldung ➡️ scomp.ly/9x4k9vN
Wir freuen uns auf deine Teilnahme 👩💻 👨💻
#LowCodeCreator
9th year of being an Oracle ACE director. Thanks Oracle! Now I need to find a similar bottle like the one from 2016 to celebrate (again). 🤪 #orclapex #aced
Teilnehmerrunde
Frankfurt APEX Meetup!
Nach #SQLDev for VS Code von Jannis Beck 👍
jetzt freudige Erwartung auf @robbie.databee.org’s Vortrag zu API-Entwicklung mit #ORDS.
@oracleace.bsky.social @ora2know.de
#orclAPEX
Diverse Logos
Juhu,
wir haben diese Woche ein Frankfurt APEX Meetup!
Am 22.5. sind wir ab 17:30 bei Syntegris in Neu-Isenburg zu Gast.
Anmeldung über Meetup:
meetu.ps/e/P2Lvm/pMkw...
Wir freuen uns auf Euch!
@oracleace.bsky.social @ora2know.de
#orclAPEX
dbLinter announced in @united-codes.com vendor session by @dgielis.com and demonstrated by @hartenfeller.dev at #apexconn25. VS Code extension is available as preview in the market place marketplace.visualstudio.com/items?itemNa.... More is coming soon. 😎
Eager listening to @salvis.com fighting bad SQL. Philipp supported left and right by famous German Bundespresidents #apexconn25 #orclapex
