Oracle Database 23c: The Ultimate Guide to Seamless Cloud Integration

In the ever-evolving landscape of technology, businesses are increasingly turning to cloud solutions to optimize their operations. This paradigm shift extends to the realm of database management, and Oracle has responded with its groundbreaking Oracle Database 23c. In this comprehensive guide, we will navigate the intricate features and...

Continue reading

Oracle Graph Server REST API

• 
• 
• 
• 
• 
• 
• 
• 

PrevNext

Oracle Graph is a powerful tool designed to uncover hidden relationships within your data. By representing information in a graph structure, Oracle Graph enables organizations to gain valuable insights from interconnected data entities. The Oracle Graph offering includes the Graph Server REST API, a gateway to utilize the...

Continue reading

Unlocking the Power of Data: How Oracle Database Revolutionizes Business Insights

In the ever-evolving landscape of modern business, data has emerged as the lifeblood that fuels growth, innovation, and strategic decision-making. Oracle Database stands as a formidable champion in this realm, empowering enterprises to harness the true potential of their data and drive unprecedented business insights. As we delve...

Continue reading

Predicates for JSON_QUERY and JSON_VALUE in Oracle Database 23c

In Oracle database 23c the JSON_QUERY and JSON_VALUE functions can include multiple predicates in a single JSON path expression, and use the PASSING clause to support variables.In previous versions some simple predicates were possible with the JSON_VALUE function, but not to the extent we see in Oracle 23c.◉...

Continue reading

Read-Only PDB Users in Oracle Database 23c

Oracle database 23c allows us to make PDB users read-only, which makes a connected session act like the database is opened in read-only mode, preventing the session from performing write operations.Read-Only UsersWe create a new test user and make it read-only. We grant DB_DEVELOPER_ROLE to the user, which...

Continue reading

Table Values Constructor in Oracle Database 23c

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 (id));INSERTThe...

Continue reading

Using JSON documents and don’t know what you’re looking for? 23c Search Indexes to the rescue

• 
• 

PrevNext

IntroductionOracle has powerful capabilities for handling JSON. It also has flexible capabilities for full-text searching, like keyword search, phrase search, or proximity search. We're going to see how these capabilities meet in the JSON search index to provide the powerful functionality of full text search in an optimized...

Continue reading

Third Quarterly Update on Oracle Graph (2023)

• 
• 
• 
• 
• 
• 
• 
• 

PrevNext

The graph features of Oracle Database enables developers to store and navigate relationships between entities. Oracle Graph Server and Client enables developers, analysts, and data scientists to use graphs within Oracle Database, while Graph Studio in Oracle Autonomous Database removes barriers to entry by automating setup and management,...

Continue reading

Integrating Helidon and WebLogic Microservices with Oracle MicroTx

• 
• 
• 

PrevNext

IntroductionMore and more businesses are adopting microservices. This may be for green field developments where everything can start as a microservice. Or it may be building microservices that need to interact with or leverage existing, typically monolithic applications. Few companies can afford to build completely net new microservice...

Continue reading

Introducing the Oracle Database Error Help Portal

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

PrevNext

In a continuous effort to increase user productivity, we are pleased to introduce the new Error Help Portal for Oracle Database, which will help users gain faster and improved insights into Oracle Database errors.You can easily access the new portal via https://docs.oracle.com/error-help/db/ and the Oracle Database Documentation landing...

Continue reading