TL;DR No, SYSDATE is not deterministic. However, it behaves very similarly to a deterministic function within an Oracle Database SQL statement. Background On a customer site, we used faketime on the O...

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

Learn how data engineers can leverage AI for Oracle automation using PL/SQL. Discover structured output, file analysis, reasoning, and tool calling with the open-source UC AI SDK.

Event streaming is extremely popular in modern application architectures, providing high-throughput, real-time data flow in microservices architectures. However, ensuring data consistency in distributed systems is challenging — Traditional two-phase commit (2PC) implementations can be costly and slow, making them impractical for high-throughput environments. In this article, we’ll solve data consistency challenges in event streaming systems using Oracle Database Transactional Event Queues…

Background I have written many blog posts detailing how to run containerised Oracle database workloads using Docker, Podman and Kubernetes on a Mac. But we now have another new exciting, simpler and potentially faster option. At WWDC 2025, Apple announced its containerisation framework platform. Apple’s Containerisation framework runs each Linux container inside its own lightweight virtual machine (VM), providing hardware-level isolation instead of relying on traditional namespace-based container runtimes, such as…

YouTube video by United Codes

Aggregating data is now easier than ever before with the newest version of Oracle database 23ai. Oracle version 23.9 supports the GROUP BY ALL syntax.

Oracle Database 23.9 Free multi-platform images are now available on container registries docker.io/gvenzl/oracle-free and ghcr.io/gvenzl/oracle-free. With this release, 23.7 images have now gone into Unsupported. See the support matrix for more information.