Die Dev Talks sind immer spannend und unterhaltsam.
Am Donnerstag diskutieren @oliverlemm.bsky.social und ich Best Practices und berichten aus unseren aktuellen Projekten und Erfahrungen.
Ich freue mich schon sehr - wer ist noch dabei?
🤖✨ Get ready for Ora2know Noon2noon – AI for the DBA!
Join Oracle ACEs Johannes Michler, @martinklierdba.bsky.social, and @robbie.databee.org for hands-on sessions exploring how AI, vector search, & natural language queries are transforming the Oracle Database world🚀
www.ora2know.de/event/noon2n...
"It doesn't matter if AI spoke to an Agent which spoke to your Uncle Mike whose used his iPad to inscribe COBOL onto a parchment that was attached to a carrier pigeon...It is still your code"
connor-mcdonald.com/2026/01/04/s...
365 new days ahead.
Let's make the best out of it
░░░░░░░░░░░░░░░░░░░░ 0.00%
365 new days.
365 fresh chances.
Previously on @thatjeffsmith... Can I build an Agent & still use SQLcl’s MCP Server? Yes!
Quick tip. When refreshing a materialized view and you get ORA-1031: Insufficient privileges, before you race off granting anything, first thing to do is check you didn't just simply misspell the mview name
Probably old news but a TIL for me. You can pipe your windows CLI output to "clip" to add it to the clipboard
Getting Close to the end of the year.
Time to get Xmas presents...
SQL assertions syntax
Multi row/multi constraint example “controllers must work in finance”
Multi row/multi table constraints “Can’t earn more than your manager” “Can’t have multiple presidents” “Must be a president”
Coming in Oracle AI Database
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS ( <query> )
)
@toonkoppelaars.bsky.social explains at #DOAG2025
Previously on @thatjeffsmith... 23ai ‘trivia’: Domains, Annotations, & Duality Views
🎤 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/
SQL Macros Can factor out common SQL expressions and statements into reusable, parameterized constructs Scalar expressions, used in SELECT, WHERE, GROUP BY and HAVING clauses Table expressions, used in FROM clauses to encapsulate calculations and business logic Scalar macro example
SQL Macros Can factor out common SQL expressions and statements into reusable, parameterized constructs Scalar expressions, used in SELECT, WHERE, GROUP BY and HAVING clauses Table expressions, used in FROM clauses to encapsulate calculations and business logic Table macro example
Macros in Oracle #SQL enable you to define expression templates as text
At parse time the database merges these with the parent query, replacing parameters with the actual values passed
Macros come in two types
Scalar - use in SELECT, WHERE, ORDER BY, etc.
Table - use in FROM
Robert fuchtelt mit dem Pointer herum
Wie man den Logitech Spotlight *eigentlich* benutzt.
Robert + Titelfolie
Der „freundliche Onkel“ @robbie.databee.org erzählt uns jetzt etwas über JSON Duality Views in der #Oracle #Database #23ai #26ai #ora2know
Exciting to see Oracle ACEs featured as speakers at SOUG Day Zurich 2025 on October 23! 🇨🇭✨ Get ready for a day full of expert insights and networking with the Swiss Oracle community.
Discover more:
🔗 soug.ch/event/soug-day-zurich-2025/
@helifromfinland.bsky.social @danischnider.bsky.social
Who doesn't want to be part of the 16th edition of APEX World?
Showcase your expertise in APEX to the community! We are seeking presentations for all skill levels, from novices to seasoned professionals, and everything in between.
👉 Visit buff.ly/dJc3ogC to submit your abstract!
Open until Dec 1
It's always an honor to talk in front of people who should know better. :)
Thank you everybody who did not enjoy the warm sun, but my talk.
@oracleace.bsky.social @ora2know.de @sym42.bsky.social
Martin
Publikum
Maria
#ora2know heute in Frankfurt!
Launige Einführung von @martinklierdba.bsky.social und schon geht’s los mit dem „Oracle AI World 2025 Follow Up“ mit @sqlmaria.com!
Join us for the Database Cloud and Developer Day on November 13th at Oracle HQ in Utrecht.
A few seats are still up for grabs for DC&D! Secure yours now before they're all taken.
Visit nloug.nl/en/events/au... for more information.
#Database @Oracle #Developer #Cloud #DCD26
Maria Colgan
zu Gast bei ora2know
@ora2know.de @sqlmaria.com @oracleace.bsky.social
Sie erzählt von AI Revolution von letzter Woche in Vegas.
Eindücke von der #OracleAIworld in #Frankfurt - @sqlmaria.com first on stage mit Geschichten von der Versionsänderung #23ai auf #26ai. Sind wir #verwirrt? :)
@oracleace.bsky.social @sym42.bsky.social
Previously on @thatjeffsmith... SQL Developer extension for VS Code 25.3: Charts & Diagrams
Getting closer to 80%...
Es gibt noch ein paar freie Plätze.
Das wird super informativ und spannend.
Sehen wir uns in Frankfurt und lernen gemeinsam über die neuesten Dinge aus der Oracle Welt?
No need to use WinGet to install Nano to edit files from the terminal - Just use:
edit filename
in Windows Terminal
Angry ticket from developers, why did "CREATE INDEX IF EXISTS" work in test envs, but not in prod. Chill, I'm just about to patch prod to 19.28. Normally would be excited, that devs actually read database new features guide, but lets be honest, it's LLM generated statement.
Blog post for September 2025
SQL Developer isn't entirely CBO-friendly.
jonathanlewis.wordpress.com/2025/09/24/s...
A small Go module for TLS endpoint monitoring/testing. In addition to what it provides over standard Go functionality, is the ability to talk some STARTTLS protocols - in this release MySQL and PostgreSQL. Was pretty fun to discover the MySQL/PostgreSQL handshake protocols github.com/ilmarkerm/go...
