@robbie.databee.org

🎙️ DOAG DevTalk Insight: #ORDS als Schnittstelle

Wie werden Berechtigungen beim Bereitstellen einer ORDS-Schnittstelle geregelt? 🤔
@robbie.databee.org erklärt das grundsätzliche Vorgehen im Clip aus unserem letzten DevTalk.
📅 Morgen (05.03., 17 Uhr): nächster DevTalk zu Upgrade nach 26ai.
#DOAGdevs

There are many #JSON enhancements in Oracle 26ai

Join #OracleACE @robbie.databee.org at 2pm UTC 15 April 2026 to learn about

The JSON datatype
JSON constructors
JSON_mergepatch and JSON_transform functions
Using flexible domains for JSON Schema validation

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

Software quality – Grok and my friend’s boat You might be wondering how a friend’s boat has any relation to the topic of software quality, but bear with me – we’ll get there in a second. But first, if you’ve got a Twit…

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

Can I build an Agent & still use SQLcl’s MCP Server? Yes! Previously on @thatjeffsmith... Can I build an Agent & still use SQLcl’s MCP Server? Yes!

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

23ai ‘trivia’: Domains, Annotations, & Duality Views Previously on @thatjeffsmith... 23ai ‘trivia’: Domains, Annotations, & Duality Views

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

SQL Developer extension for VS Code 25.3: Charts & Diagrams Previously on @thatjeffsmith... SQL Developer extension for VS Code 25.3: Charts & Diagrams

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