Development
-
Downloading AutoUpgrade in Ansible playbooks
Mike Dietrich just announced a new AutoUpgrade release. If you haven’t heard about AutoUpgrade yet, you…
-
Setting initialisation parameters in Oracle AI Database Free container image
I recently had to troubleshoot a vector index creation problem on Oracle AI Database Free. To…
-
Generating SQL scripts using the VALUES clause
Oracle AI Database 26ai adds a table value constructor to SELECT, allowing VALUES to act as…
-
Did you know about schema-only accounts?
Oracle 18c introduced schema-only accounts, and they are great for ISVs and anyone else who wants…
-
LiveLab Updates for Multilingual Engine
Oracle Multilingual Engine allows you to write server-side JavaScript code, use (license-compliant, security-vetted, etc.) third-party JavaScript…
-
Solving a common “permission denied” error in rootless podman
Podman is different from docker in that it typically runs its containers rootless. Just as any…
-
Enabling outbound network connections in APEX
Modern applications frequently need to access external services from within the database. In distributed architectures, those…
-
Storing & retrieving sensitive data for your CI/CD pipelines securely
On-premises edition. See below for a great article by Jeff Smith covering the other scenario where…
-
Observations concerning PostgreSQL transactional DDL and concurrency
Recently, while browsing my feed on LinkedIn I came across a post dealing with PostgreSQL transactional…
-
Connecting to Oracle AI Autonomous Database with SQLcl the Easy Way
Third-party tools don’t always offer much flexibility when connecting to Oracle AI Autonomous Database. In many…