Robert Marz
@robbie.databee.org
Software Architect with a database-centric view of the the world.
Oracle ACE Pro. Sym42 Member. ora2Know.
Living in Frankfurt, Germany.
Oracle ACE Pro. Sym42 Member. ora2Know.
Living in Frankfurt, Germany.
Reposted by Robert Marz
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
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
November 10, 2025 at 12:02 PM
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
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
Reposted by Robert Marz
Wie man den Logitech Spotlight *eigentlich* benutzt.
October 22, 2025 at 1:15 PM
Wie man den Logitech Spotlight *eigentlich* benutzt.
Reposted by Robert Marz
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
Discover more:
🔗 soug.ch/event/soug-day-zurich-2025/
@helifromfinland.bsky.social @danischnider.bsky.social
October 22, 2025 at 6:28 AM
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
Discover more:
🔗 soug.ch/event/soug-day-zurich-2025/
@helifromfinland.bsky.social @danischnider.bsky.social
Reposted by Robert Marz
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
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
October 22, 2025 at 7:17 AM
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
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
Reposted by Robert Marz
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
Thank you everybody who did not enjoy the warm sun, but my talk.
@oracleace.bsky.social @ora2know.de @sym42.bsky.social
Basic knowhow that every Oracle developer and DBA should know: how do transactions work in an Oracle database. @martinklierdba.bsky.social explains it in detail at #HrOUG2025
October 16, 2025 at 4:00 PM
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
Thank you everybody who did not enjoy the warm sun, but my talk.
@oracleace.bsky.social @ora2know.de @sym42.bsky.social
Reposted by Robert Marz
#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!
Launige Einführung von @martinklierdba.bsky.social und schon geht’s los mit dem „Oracle AI World 2025 Follow Up“ mit @sqlmaria.com!
October 22, 2025 at 7:51 AM
#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!
Launige Einführung von @martinklierdba.bsky.social und schon geht’s los mit dem „Oracle AI World 2025 Follow Up“ mit @sqlmaria.com!
Reposted by Robert Marz
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
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
October 22, 2025 at 7:27 AM
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
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
Reposted by Robert Marz
Maria Colgan
zu Gast bei ora2know
@ora2know.de @sqlmaria.com @oracleace.bsky.social
Sie erzählt von AI Revolution von letzter Woche in Vegas.
zu Gast bei ora2know
@ora2know.de @sqlmaria.com @oracleace.bsky.social
Sie erzählt von AI Revolution von letzter Woche in Vegas.
October 22, 2025 at 8:13 AM
Maria Colgan
zu Gast bei ora2know
@ora2know.de @sqlmaria.com @oracleace.bsky.social
Sie erzählt von AI Revolution von letzter Woche in Vegas.
zu Gast bei ora2know
@ora2know.de @sqlmaria.com @oracleace.bsky.social
Sie erzählt von AI Revolution von letzter Woche in Vegas.
Reposted by Robert Marz
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
@oracleace.bsky.social @sym42.bsky.social
October 22, 2025 at 7:55 AM
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
@oracleace.bsky.social @sym42.bsky.social
Reposted by Robert Marz
Previously on @thatjeffsmith... SQL Developer extension for VS Code 25.3: Charts & Diagrams
SQL Developer extension for VS Code 25.3: Charts & Diagrams
Previously on @thatjeffsmith... SQL Developer extension for VS Code 25.3: Charts & Diagrams
www.thatjeffsmith.com
October 21, 2025 at 8:39 PM
Previously on @thatjeffsmith... SQL Developer extension for VS Code 25.3: Charts & Diagrams
Getting closer to 80%...
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░ 79.93%
October 19, 2025 at 6:44 PM
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?
Das wird super informativ und spannend.
Sehen wir uns in Frankfurt und lernen gemeinsam über die neuesten Dinge aus der Oracle Welt?
Nächste Woche findet die Oracle AI World in Las Vegas statt und am 22. Oktober gibt es in Frankfurt den ora2know-Oracle AI-World Follow Up mit den aktuellsten News aus der Oracle-Welt. Weitere Infos und Anmeldung: www.ora2know.de/2025/08/13/o...
October 13, 2025 at 11:52 PM
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?
Das wird super informativ und spannend.
Sehen wir uns in Frankfurt und lernen gemeinsam über die neuesten Dinge aus der Oracle Welt?
Reposted by Robert Marz
No need to use WinGet to install Nano to edit files from the terminal - Just use:
edit filename
in Windows Terminal
edit filename
in Windows Terminal
October 10, 2025 at 9:16 PM
No need to use WinGet to install Nano to edit files from the terminal - Just use:
edit filename
in Windows Terminal
edit filename
in Windows Terminal
Reposted by Robert Marz
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.
October 2, 2025 at 5:04 AM
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.
Reposted by Robert Marz
Blog post for September 2025
SQL Developer isn't entirely CBO-friendly.
jonathanlewis.wordpress.com/2025/09/24/s...
SQL Developer isn't entirely CBO-friendly.
jonathanlewis.wordpress.com/2025/09/24/s...
September 24, 2025 at 12:29 PM
Blog post for September 2025
SQL Developer isn't entirely CBO-friendly.
jonathanlewis.wordpress.com/2025/09/24/s...
SQL Developer isn't entirely CBO-friendly.
jonathanlewis.wordpress.com/2025/09/24/s...
Reposted by Robert Marz
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...
GitHub - ilmarkerm/go_tls_probe: Module for GO that does TLS handshake and returns information about the endpoint with support for some STARTTLS services
Module for GO that does TLS handshake and returns information about the endpoint with support for some STARTTLS services - ilmarkerm/go_tls_probe
github.com
September 27, 2025 at 8:22 AM
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...
Reposted by Robert Marz
Previously on @thatjeffsmith... Adding Custom Snippets in VS Code for SQL Developer
Adding Custom Snippets in VS Code for SQL Developer
Previously on @thatjeffsmith... Adding Custom Snippets in VS Code for SQL Developer
www.thatjeffsmith.com
September 25, 2025 at 4:36 AM
Previously on @thatjeffsmith... Adding Custom Snippets in VS Code for SQL Developer
Reposted by Robert Marz
Previously on @thatjeffsmith... On REST APIs and Oracle Database 23ai JSON native types
On REST APIs and Oracle Database 23ai JSON native types
Previously on @thatjeffsmith... On REST APIs and Oracle Database 23ai JSON native types
www.thatjeffsmith.com
September 9, 2025 at 8:40 PM
Previously on @thatjeffsmith... On REST APIs and Oracle Database 23ai JSON native types
Reposted by Robert Marz
+++ Wichtiger Hinweis für alle Fußballfans: Wir haben den Ablauf der #Mondfinsternis morgen Abend so organisiert, dass die spektakulärste Phase mit dem Kernschatten rechtzeitig vor dem Anstoß stattfindet. +++ #Service
September 6, 2025 at 3:13 PM
+++ Wichtiger Hinweis für alle Fußballfans: Wir haben den Ablauf der #Mondfinsternis morgen Abend so organisiert, dass die spektakulärste Phase mit dem Kernschatten rechtzeitig vor dem Anstoß stattfindet. +++ #Service
Reposted by Robert Marz
Different approaches to monitoring, according to @jasminfluri.bsky.social at #POUG2025
(The Poland version is applicable in many countries 😇)
(The Poland version is applicable in many countries 😇)
September 6, 2025 at 8:04 AM
Different approaches to monitoring, according to @jasminfluri.bsky.social at #POUG2025
(The Poland version is applicable in many countries 😇)
(The Poland version is applicable in many countries 😇)
Reposted by Robert Marz
This is the #POUG essence. You can drink beer, you can party late, but you will also show up at 9 am the next day in the venue because the sessions are that good.
September 6, 2025 at 7:17 AM
This is the #POUG essence. You can drink beer, you can party late, but you will also show up at 9 am the next day in the venue because the sessions are that good.
Reposted by Robert Marz
Why take an outage to deploy applications when you don't need to
September 6, 2025 at 8:38 AM
Why take an outage to deploy applications when you don't need to
Reposted by Robert Marz
Previously on @thatjeffsmith... Navigating your schemas/databases in SQLDev for VS Code
Navigating your schemas/databases in SQLDev for VS Code
Previously on @thatjeffsmith... Navigating your schemas/databases in SQLDev for VS Code
www.thatjeffsmith.com
September 5, 2025 at 8:41 PM
Previously on @thatjeffsmith... Navigating your schemas/databases in SQLDev for VS Code
Reposted by Robert Marz
Insulting the AI.
September 3, 2025 at 6:57 AM
Insulting the AI.