Introducing Oracle Exadata Database Service on Exascale Infrastructure

• 
• 
• 
• 

PrevNext

We are pleased to announce the general availability of Oracle Exadata Database Service on Exascale Infrastructure. Exadata Database Service provides customers around the world with extreme performance, reliability, availability, and security benefits they depend on for their Oracle Database workloads. With the introduction of highly scalable and affordable...

Continue reading

Table Values Constructor in Oracle Database 23ai

The table values constructor allows us to define multiple rows using a single constructor for use in SQL statements.◉ SetupThe following table is 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...

Continue reading

Transport Layer Security (TLS) Connections without a Client Wallet in Oracle Database 23ai

In previous releases HTTPS callouts from the database required the use of a client wallet. From Oracle database 23ai onward we can use the operating system certificate store instead.Operating systems usually have a certificate store containing the root certificates of popular certificate authorities. This allows the operating system...

Continue reading

XML, JSON and Oracle Text Search Index Enhancements in Oracle Database 23ai

In Oracle 23ai the CREATE SEARCH INDEX statement allows us to create search indexes on XML, JSON and text data, making the syntax consistent between them.◉ XML Search IndexesThe index type of XDB.XMLIndex was introduced in a previous release to allow us to index XML data.drop table if...

Continue reading

Oracle Database 23ai Free RPM Installation On Oracle Linux 8 (OL8)

Oracle Database 23ai free can be installed on Oracle Linux 8 using an RPM. This article describes the RPM installation of Oracle Database 23ai free 64-bit on Oracle Linux 8 (OL8) 64-bit. The article is based on a server installation with a minimum of 2G swap and secure...

Continue reading

Oracle Database 23ai Free RPM Installation On Oracle Linux 9 (OL9)

Oracle Database 23ai free can be installed on Oracle Linux 9 using an RPM. This article describes the RPM installation of Oracle Database 23ai free 64-bit on Oracle Linux 9 (OL9) 64-bit. The article is based on a server installation with a minimum of 2G swap and secure...

Continue reading

Unlock the Power of Your Data: Seamlessly Create and Refresh Datasets from Files Stored in OCI Object Storage

• 
• 
• 
• 
• 
• 
• 
• 

PrevNext

In this post, I provide an overview and examples of creating datasets from files stored in Oracle Cloud Infrastructure (OCI) Object Storage. I also explore the new capabilities with centralized file storage that enables the ability to schedule periodic reloads of the data stored in Object Storage. I...

Continue reading

Announcing New Spatial Machine Learning Algorithms in OML4Py on Autonomous Database Serverless

• 
• 

PrevNext

We are pleased to announce the general availability of a new feature of Oracle Machine Learning for Python (OML4Py), Spatial AI. OML4Py Spatial AI provides specialized machine learning algorithms that incorporate the effects of location. Using machine learning with spatial algorithms can improve model quality and prediction accuracy...

Continue reading

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