IF [NOT] EXISTS DDL Clause in Oracle Database 23c

Prevent errors during object creation and removal using the IF [NOT] EXISTS DDL clause in Oracle Database 23c.◉ SetupThe following objects are required by the examples below.-- Test user.conn sys/SysPassword1@//localhost:1521/freepdb1 as sysdbacreate user testuser1 identified by testuser1;grant connect, resource to testuser1;-- Test objects.conn testuser1/testuser1@//localhost:1521/freepdb1create table t1 (id number);create...

Continue reading

Property Graphs in SQL Developer release 23.1

• 
• 
• 

PrevNext

The Property Graph feature of Oracle Database offers powerful graph support to explore and discover complex relationships in data.Oracle Database 23c Free - Developer Release is the first release of the next-generation Oracle Database, allowing developers a head-start on building applications with innovative 23c features that simplify the...

Continue reading

Database links in Autonomous Database Shared are the past - Cloud links are the future

• 
• 
• 
• 
• 
• 

PrevNext

As many of you know, database links are an established mechanism to allow other remote databases to access specific tables or views in your database.Database links have been around for decades and always require a two-way interaction in one of two ways: The remote (accessing) side contacts you,...

Continue reading

DML RETURNING Clause Enhancements in Oracle Database 23c

This article demonstrates the enhancements to the DML RETURNING clause introduced in Oracle database 23c.◉ 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...

Continue reading

DB_DEVELOPER_ROLE Role in Oracle Database 23c

Oracle database 23c 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 23c introduced a new DB_DEVELOPER_ROLE role, to provide the basic roles and privileges Oracle believe are necessary for a database developer....

Continue reading

CASE Statement and CASE Expression Enhancements in Oracle Database 23c

In Oracle database 23c 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 following...

Continue reading

Annotations in Oracle Database 23c

This article describes the use of annotations to document our database objects in Oracle database 23c.What's the Point?We can think of annotations as an extension of database comments. With comments we were able to add free text to objects such as tables and columns, allowing us to describe...

Continue reading

Operational Property Graphs in Oracle Database 23c Free - Developer Release

• 
• 

PrevNext

Oracle Database 23c Free - Developer Release is the first release of the next-generation Oracle Database, allowing developers a head-start on building applications with innovative 23c features that simplify the development of modern data-driven apps. The entire feature set of Oracle Database 23c is planned to be generally...

Continue reading

Key benefits of JSON Relational Duality: Experience it today using "Oracle Database 23c Free--Developer Release"

Oracle Database 23c JSON Relational Duality revolutionizes appdev by converging the benefits of the relational and document worlds within a single database. The new feature that enables this convergence is called JSON Relational Duality View (Will be simply referred below as Duality View).

With Duality View, while data gets stored in relational tables in a normalized way, it can be exposed to apps as JSON documents. Storing the data in relational tables delivers all the benefits of the relational model, whereas by exposing the same data as JSON documents, apps get schema flexibility and other benefits of the document model.

Continue reading

What Careers Require 1Z0-149 Certification?

If you are an Oracle Database Application Development certified professional, you have already gained a competitive edge over others. The next step is to pursue advanced certifications to enhance your value in the job market. One such certification is the Oracle Database Program with PL/SQL 1Z0-149 certification, which...

Continue reading