Data quality issues plague even the most meticulously maintained databases. Typos, misspellings, and phonetic variations can create duplicate records, hindering analysis and decision-making. Fortunately, Oracle Database 23c delivers two powerful tools for fuzzy string matching: FUZZY_MATCH and PHONIC_ENCODE.
Using Fuzzy Matching in Oracle Database 23c Read More »
Oracle Database 23c introduces a powerful enhancement to the RETURNING clause for DML statements, enabling developers to retrieve both old and new values directly within UPDATE statements. This feature streamlines application development, improves performance, and simplifies tasks like auditing and change data capture (CDC).
RETURNING Clause in Oracle Database 23c Read More »
Oracle Database 23c introduces significant enhancements to the simple CASE statement and expression, offering increased flexibility and alignment with the SQL:2003 standard. These enhancements include: Dangling Predicates and Multiple Choices or Conditions in a Single WHEN Clause. We will demonstrate those enhancements in this article.
Introducing Annotations: A New Frontier for Metadata Read More »
Oracle Database 23c introduces significant enhancements to the simple CASE statement and expression, offering increased flexibility and alignment with the SQL:2003 standard. These enhancements include: Dangling Predicates and Multiple Choices or Conditions in a Single WHEN Clause. We will demonstrate those enhancements in this article.
Enhanced Control Flow with CASE in Oracle Database 23c Read More »
In Oracle Database 23c, schema privileges provide an easy way to simplify grants when users or roles require access to all objects within a schema. This guide will walk through the setup, granting, testing, and revoking of schema privileges, accompanied by new and diverse code examples.
Navigating Schema Privileges in Oracle Database 23c Read More »
Oracle Database 23c introduces a significant advancement in auditing capabilities with the ability to create audit policies on individual columns of tables and views. This granular control empowers organizations to fine-tune their audit trails, focusing on the most sensitive data elements and reducing audit overhead.
Enhanced Auditing in Oracle 23c: Granular Control at the Column Level Read More »
SQL Firewall is a powerful tool embedded in the Oracle Database 23c engine that delivers real-time protection against common database attacks. By limiting database access to authorized SQL statements or connections for specified users, SQL Firewall enhances the security posture of Oracle databases. This article provides an overview of the key concepts and demonstrates the essential steps for implementing SQL Firewall.
Implementing SQL Firewall in Oracle Database 23c Read More »
With the introduction of Oracle Database 23c, a new contender joins the arena: Unified Memory Management (UMM).
Unified Memory Management (UMM): A New Approach in Oracle Database 23c Read More »
Oracle Database 23c introduces significant enhancements to read-only controls, offering greater flexibility and security in managing user access and session behavior. This article explores these new features and demonstrates their advantages over previous approaches.
Setting Read-Only Users and Sessions Read More »
