📰 rowlen surprise - Jonathan Lewis explains the avg_row_len and num_rows columns in user_tables 📰 Oracle DB 23ai supports external Apache Iceberg tables - Bryan Grenn shows how you can query Apache Iceberg files with Oracle Database 23ai 🏆 Governor Hochul Announces $218 Million Investment to Improve Patient Care - The NY State Office of Mental Health awards Oracle Health the funding to create a comprehensive statewide electronic health record system…

🎉 Oracle Corporation Announces Promotion of Clay Magouyrk and Mike Sicilia to CEOs - Oracle announced a change in leadership 📰 Pub/Sub with a NodeJS Oracle Database App - Anders Swanson gives you a practical example for Pub/Sub with Oracle Database and JavaScript applications 📰 How To Upgrade 100 PDBs And Move Them To Another Server - Daniel Overby Hansen shows how you can move hundreds of PDBs with just a few commands…

📰 FIO Benchmarks Highlight Performance Gains with Hammerspace Tier 0 Architecture on OCI - Oracle Cloud shows new storage benchmark results 🎉 Oracle Database@Google Cloud: Expanding Services and Regions - Oracle announces new regions for Oracle Database@Google Cloud 🎉 Oracle Cloud Infrastructure and Microsoft Azure Expand Oracle Database Services - Oracle announces new regions for Oracle Database@Azure 📰 How to update columns in one table with data from another using Oracle SQL…

📰 🤖 Exadata AI Smart Scan Deep Dive - Alex Blyth drills into the Exadata Smart Scan enhancements for AI workloads 📰 Inline JavaScript and some further details about code delimiters - Martin Bach shares insights into the Multilingual Engine code delimiters 📺 OCI Network Firewall – Tunnel Inspection - Arvind Bassan explains the Tunnel Inspection feature for OCI Network Firewall…

Oracle Database 23.9 implements the non-positional INSERT statement. In my social media posts, I called out that Oracle Database is the first and only database to support this functionality, and by…

Oracle's Multitenant architecture allows you to unplug a Pluggable Database (PDB) from one Container Database (CDB) and plug it into another, simplifying database migration and management. This quick guide walks through the process of unplugging a PDB into a .pdb archive file and replugging it into another CDB. We will be using the gvenzl/oracle-free images to demonstrate multiple Oracle Database environments.

📰 Oracle Master Encryption Key Management: Wallets, OKV, and HSM Explained - Bryan Grenn shows practical examples of Oracle Database Master Encryption Keys 🎉 Oracle Data Masking and Subsetting expands to discover 150+ new sensitive data types - Oracle adds 150+ new sensitive data types to its Data Masking and Subsetting product 📰 The Magical NVL Function - Więcej Postów demonstrates enhancements for optional SQL query parameters…

My recent blog post about Oracle Database 23.7 has generated significant interest in one particular feature: materialized columns. In this post, I’ll dive deeper into what materialized columns are,…

📰 💡 Using a modern database? You might not need that ORM anymore - Anders Swanson shares his thoughts on potential ORM alternatives 📰 ZDLRA - How to manually register databases - Byran Grenn gives step-by-step instructions to manually register an Oracle Database with Zero Data Loss Recovery Appliance 📺 OCI Network Firewall - SSL Inspection - Oracle Learning demonstrates the SSL Inspection feature of the OCI Network Firewall…

Oracle Database 23.9 implements the non-positional INSERT statement. In my social media posts, I called out that Oracle Database is the first and only database to support this functionality, and by that, I mean not only the SET clause but the entirety of that feature set. There is a lot that can be done now, and this blog post provides the backstory of how this feature came about, what it does, and when you should use it.

📖 Autonomous DB and OCI: Exporting a Schema to Object Storage + Retention Policy - Marcus Vinicius gives you a detailed guide to back up your ADB schema to object storage 📖 Application and AI Scalability with Oracle Active Data Guard - Ludovico Caldara highlights the many advantages of Oracle Active Data Guard, the leading solution for data protection and more…

What happens? Using a non-deterministic function as a non-aggregate column, the results produced by GROUP BY ALL and GROUP BY <alias> differ. The documentation does not define the semantics of GROU...

My recent blog post about Oracle Database 23.7 has generated significant interest in one particular feature: materialized columns. In this post, I’ll dive deeper into what materialized columns are, how they work, and when you might want to use—or avoid—them.

📖 Were you aware of the two hidden columns in CDB-Views? - Mike Dietrich shares some interesting insights regarding the CDB_* views 🎉 Exadata System Software Updates - August 2025 - Oracle announces the general availability of Exadata System Software 📖 How To Downgrade a PDB from Oracle Database 23ai - Daniel Overby Hansen demonstrates that an Oracle Database upgrade isn't a one-way street&hellip;

DuckDB is an analytical in-process SQL database management system - duckdb/duckdb