Ottmar Gobrecht

I've used AI for APEX and PL/SQL for a year, but this week something changed. ⚡ I generated 100s of lines of production-ready PL/SQL in one shot. It’s all about metadata, specs, and agent instructions. #orclAPEX #AI
blog.cloudnueva.com/an-ai-shift-...

Avoid Implicit Type Conversion in JSON Access - Philipp Salvisberg's Blog Discover why explicit JSON value conversion in SQL is essential for best performance and how to apply it in your code.

I have stumbled across some implicit data conversions that I was unaware of, causing poor performance when querying JSON-relational duality views.

I demonstrate what I mean using a simplified example in this blog post.

www.salvis.com/blog/2025/01...

🚨 APEX 24.2.1 is here! 🚨
This update addresses several bugs in APEX 24.2.

👉 Learn more & download: apex.oracle.com/download

🛠️ Check Known Issues: apex.oracle.com/known-issues

#orclapex

This release of APEX looks like another hit. Lots of new features, AI integrations, RAG, Vector search, JSON duality views, new APIs and Utilities and core component enhancements. Will share more as I explore in the next days and weeks💡

docs.oracle.com/en/database/...

#orclAPEX 24.2 for the win 🏆

My favorite new features in APEX 24.2 at a glance Low-Code, Rapid Application Development, APEX, Oracle Application Express, Oracle Database, Rapid Prototyping, Consultancy, IT, PL/SQL

Great new features in #orclapex 24.2! Congrats to the whole team!

Here are my favorites: nielsdebr.blogspot.com/2025/01/my-f...

Oracle APEX 24.2 is now generally available!

This release unlocks new capabilities for AI-powered apps 🤖, configure RAG data for AI calls🧠, automate Fusion Applications integration🔁, work directly with JSON data ✨, and much more!

apex.oracle.com/go/242-is-no...

#orclAPEX #LowCode

The wait is over and the version is... 24.2 🤓

#orclAPEX

Jakob Drees and I have just released version 1.2.0 of my #Oracle #PLSQL logging tool “console”. This tool also contains some #orclAPEX goodies. Read his blog post to find out what's new seedandpublish.com/blog/console...

GitHub - ogobrecht/ploc: npm package to convert PL/SQL code into Markdown docs npm package to convert PL/SQL code into Markdown docs - ogobrecht/ploc

Just released a new version of my npm package to convert #Oracle PL/SQL code into Markdown docs: github.com/ogobrecht/ploc

Oracle Database 23.6 Free multi-platform images now available on gvenzl/oracle-free Oracle Database 23.6 Free multi-platform images are now available on container registries docker.io/gvenzl/oracle-free and ghcr.io/gvenzl/oracle-free.

#Oracle #Database 23.6 Free multi-platform images now available on gvenzl/oracle-free

Have a look here:

APEX_INSTANCE_ADMIN.SET_WORKSPACE_PARAMETER (
p_workspace IN VARCHAR2,
p_parameter IN VARCHAR2,
p_value IN VARCHAR2 )

Parameters:
MAX_SESSION_IDLE_SEC
MAX_SESSION_LENGTH_SEC
...

docs.oracle.com/en/database/...

Loading MLE modules into the database got a lot easier with SQLcl 24.3.2 Oracle Database 23ai running on Linux x86-64 and aarch64 allows you to write server-side JavaScript code, stored and executed directly within the database. Multilingual Engine (MLE), powered by Gra…

Many thanks to @thatjeffsmith.com and his team for greatly simplifying the way you deploy MLE/JavaScript modules to Oracle database 23ai. The most recent SQLcl release introduces the create-module command. You can find more details here: martincarstenbach.com/2024/12/02/l...

The Oracle DB Docker images are awesome! Since 23.5 there are ARM images available and they start super fast. oracle-free:23-slim-faststart starts in 3.6 sec on my M4 Pro.
Thanks, @gvenzl.bsky.social for doing an amazing job!

Your local development environment: Oracle Database 23ai Free on WSL2 Recently I posted a few tweets about my experience developing on windows. That’s something new to me, typically I’d use either Linux or MacOS. Some of you wanted to know how that went, …

Some of you wanted to know how I set up my lab environment on windows using wsl2. Strictly no serious use, I'm just dabbling with the technology. How does the saying go? It works for me, on my machine. Details here: martincarstenbach.com/2024/11/30/y...

Part5: SQLcl Project (It will forever change your Database & APEX deployments) Welcome to part 5 of "A whirlwind tour of Database Schema Changes Tracking Tools" In this article, I will provide a general overview and test the basic functionalities of the Oracle SQLcl “Project” command. I will cover only CI/CD for database change...

Part 5 of my "Whirlwind Tour of Database Schema Changes" is live! I reviewed Oracle SQLcl's "Project" feature - a game changer for Database & APEX deployments.
Kudos to @thatjeffsmith.com and his Database Tools team!

rafal.hashnode.dev/part5-sqlcl-...

#oracle #orclAPEX #cicd

Thank you Niels!

Screenshot of the running app which shows network visualization of a data model and some reports with data model related meta data

New in an #Oracle project? Visually explore unknown data models with an #orclAPEX app!

github.com/ogobrecht/da...