Advertisement · 728 × 90

Posts by Ottmar Gobrecht

Thank you for all the contributions to the project. Good work and much appreciated.

2 weeks ago 0 0 0 0
New console v1.3 release Adding unit tests for logging

Today, @ogobrecht.com and I have released version 1.3.0 of the great console logging framework. It includes many new unit tests and a breaking change to the "assert"-procedure.

Check out what's new in my latest blog post:
seedandpublish.com/blog/console...

2 weeks ago 2 1 1 0

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

2 months ago 6 2 0 0
Preview
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...

1 year ago 14 8 1 0

🚨 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

1 year ago 12 4 0 0
Release Notes

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 🏆

1 year ago 17 6 0 0
Preview
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...

1 year ago 17 4 0 0
Advertisement
Post image

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

1 year ago 32 17 0 0

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

#orclAPEX

1 year ago 10 3 0 0
New console v1.2 release Parameter logging has never been easier!

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

1 year ago 4 0 0 0
Preview
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

1 year ago 8 4 1 0
Preview
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

1 year ago 56 31 0 0
API Reference

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

1 year ago 4 1 1 0
Preview
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...

1 year ago 8 4 1 0
Advertisement

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!

1 year ago 21 8 2 0
Preview
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...

1 year ago 8 1 1 1
Preview
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

1 year ago 19 7 1 0

Thank you Niels!

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

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

1 year ago 10 6 2 0