EMPTY STRING ON NULL for JSON Generation in Oracle Database 23ai

Oracle database 23ai has introduced the ability to convert nulls to empty strings during JSON generation.◉ SetupWe create and populate a table. Notice each row has a different combination of values with regards to null.conn testuser1/testuser1@//localhost:1521/freepdb1drop table if exists t1 purge;create table t1 (  col1 VARCHAR2(10),  col2 VARCHAR2(10));insert...

Continue reading

Announcing Globally Distributed Autonomous Database Support for Oracle Database 23ai Enabling Raft Replication

• 
• 

PrevNext

Over the last four years, the Oracle Database Development team has diligently worked to deliver the next long-term support release: Oracle Database 23ai, with a focus on AI and enhancing developer productivity.Today, we are thrilled to announce support for Oracle Database 23ai on the Oracle Globally Distributed Autonomous...

Continue reading

Oracle Spatial Studio 24.1 Available Now

• 
• 
• 
• 

PrevNext

We’re pleased to announce the release of Oracle Spatial Studio 24.1, a no-code web tool for working with the spatial features of Oracle Database. In this release we've focused on enchancing existing features and including new support for a popular file type, 3D tiles. This blog post will...

Continue reading

OCI AI Vision Facial Detection in Oracle Analytics Cloud

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

PrevNext

This post explores the OCI service AI Vision Facial Detection exposed directly in Oracle Analytics. With prebuilt models available, developers can easily build image recognition and text recognition into their applications without machine learning (ML) expertise.  This post will walk users through registering their AI Vision Face Detection...

Continue reading

Direct Joins for UPDATE and DELETE Statements in Oracle Database 23ai

From Oracle database 23ai onward we are allowed to use direct joins to tables to drive UPDATE and DELETE statements.◉ SetupThe following tables are necessary to run the examples in this article.drop table if exists t1 purge;drop table if exists t2 purge;drop table if exists t3 purge;create table...

Continue reading

DML RETURNING Clause Enhancements in Oracle Database 23ai

• 
• 

PrevNext

This article demonstrates the enhancements to the DML RETURNING clause introduced in Oracle database 23ai.SetupThe following tables are required to run the examples in this article.drop table if exists t1;create table t1 (  id number,  code varchar2(6),  description varchar(25),  constraint t1_pk primary key (id));insert into t1 values (1,...

Continue reading

CASE Statement and CASE Expression Enhancements in Oracle Database 23ai

In Oracle database 23ai the simple CASE statement and expression are more flexible, allowing dangling predicates and multiple choices in a single WHEN clause.This brings the PL/SQL simple CASE statement and expression in line with the SQL:2003 Standard [ISO03a, ISO03b] standard.◉ SetupThe examples in this article use the...

Continue reading

DB_DEVELOPER_ROLE Role in Oracle Database 23ai

• 
• 

PrevNext

Oracle database 23ai introduced a new DB_DEVELOPER_ROLE role to provide the basic roles and privileges Oracle believe are necessary for a database developer.◉ DB_DEVELOPER_ROLE Role BasicsOracle database 23ai introduced a new DB_DEVELOPER_ROLE role to provide the basic roles and privileges Oracle believe are necessary for a database developer....

Continue reading

Bigfile Tablespace Defaults in Oracle Database 23ai

Bigfile tablespaces were introduced in Oracle 10g. In Oracle database 23ai bigfile tablespaces are the default.◉ BIGFILE Default for SYSAUX, SYSTEM, and USER TablespacesIn Oracle database 23ai most of the Oracle provided tablespaces are bigfile tablespaces by default.We connect to the root container and check out the tablespaces...

Continue reading

DBMS_JOB Jobs Converted to DBMS_SCHEDULER Jobs in Oracle Database 19c

The DBMS_JOB package has been deprecated since 12cR2. Oracle 19c takes the demise of the DBMS_JOB package a step further by converting any DBMS_JOB jobs to DBMS_SCHEDULER jobs.◉ Create a Job Using DBMS_JOBIn Oracle 19c jobs created using the DBMS_JOB package are implemented as DBMS_SCHEDULER jobs, as demonstrated...

Continue reading