Unlimited data-driven collaboration with Data Sharing of Oracle Autonomous Database

Data Sharing is making data available to other users – inside or outside your organization – to facilitate collaboration, improve business processes, expand business opportunities, or just make data available across siloed systems. Data Sharing is as old as computer technology and an essential component of any IT...

Continue reading

MAX_COLUMNS : Increase the Maximum Number of Columns for a Table (Wide Tables) in Oracle Database 23c

Oracle 23c introduced the MAX_COLUMNS initialization parameter, which allows us to have up to 4096 columns in a table. This is sometimes described as wide tables.The ProblemBy default the maximum number of columns allowed for a table is 1000. The following code creates a table called T1 with...

Continue reading

Full Text Indexing using Oracle Text

Oracle Text, previously know as interMedia Text and ConText, is an extensive full text indexing technology allowing you to efficiently query free text and produce document classification applications. In this article I'll only scratch the surface of this very complex feature.◉ SetupThe examples in this article require access...

Continue reading

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

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

Benefits of 1Z0-931-22 Certification for Your Career Development

What Is 1Z0-931-22 Certification?The 1Z0-931-22 certification is a prestigious credential offered by Oracle, and it specifically focuses on the Oracle Autonomous Database Cloud 2022 Professional. This certification validates an individual's expertise in managing and leveraging data effectively using the latest advancements in data management technology.By obtaining the 1Z0-931-22...

Continue reading

SELECT Without FROM Clause in Oracle Database 23c

From Oracle 23c onward we can use a SELECT without a FROM clause in some circumstances.◉ SELECT Without FROM ClauseFrom Oracle 23c onward, rather than selecting expressions from the DUAL table, we can just omit the FROM clause completely. So these are functionally identical.select sysdate;SYSDATE---------04-APR-23SQL>select sysdate from dual;SYSDATE---------04-APR-23SQL>◉...

Continue reading

Schema Privileges in Oracle Database 23c

Schema privileges allow us to simplify grants where a user or role needs privileges on all objects in a schema.◉ SetupThe examples in this article require the following setup.Create two test users and a role.conn sys/SysPassword1@//localhost:1521/freepdb1 as sysdbadrop user if exists testuser1 cascade;drop user if exists testuser2 cascade;drop...

Continue reading

Removal of Touch-Once Restriction after Parallel DML (Unrestricted Direct Loads) in Oracle Database 23c

Oracle database 23c makes parallel DML more flexible by removing the touch-once restriction after parallel DML. This is also know as unrestricted direct loads.◉ The Problem : Touch-Once RestrictionIn releases prior to Oracle database 23c we can't select or modify an object after it has been modified using...

Continue reading

Precheck Constraints using JSON Schema in Oracle Database 23c

In Oracle database 23c we can use the PRECHECK keyword to mark check constraints as being validated externally by an application. The DBMS_JSON_SCHEMA package allows us to describe objects in the form of a JSON schema, which can be passed to an application to define how the data...

Continue reading