www.oracle.com Open in urlscan Pro
2a02:26f0:3400:2b4::a15  Public Scan

Form analysis
1 forms found in the DOM

Name: u30searchForm — GET /search

<form name="u30searchForm" id="u30searchForm" data-contentpaths="/content/Web/Shared/Auto-Suggest Panel Event" method="get" action="/search">
  <input type="hidden" name="Nty" value="1">
  <input type="hidden" name="Dy" value="1">
  <!--<input type="hidden" name="Ntk" value="SI-Global">-->
  <input type="hidden" name="Ntk" value="SI-ALL5">
  <input type="hidden" name="cty" value="us">
  <input type="hidden" name="lang" value="en">
  <input type="hidden" name="NoBstNoRec" value="no">
  <div class="u30s1">
    <button id="u30closesearch" aria-label="Close Search" type="button">
      <span>Close Search</span>
      <svg width="9" height="14" viewBox="0 0 9 14" fill="none" xmlns="http://www.w3.org/2000/svg">
        <path d="M8 13L2 7L8 1" stroke="#161513" stroke-width="2"></path>
      </svg>
    </button>
    <span class="u30input">
      <div class="u30inputw1">
        <input id="u30input" name="Ntt" value="" type="text" placeholder="Search" autocomplete="off" aria-autocomplete="both" aria-activedescendant="" aria-label="Search Oracle.com" role="combobox" aria-expanded="false" aria-owns="u30autosuggest"
          aria-haspopup="listbox">
      </div>
      <div id="u30searchw3" style="margin-left: -189px; width: calc(100vw - 0px); max-width: 1600px;">
        <ul role="listbox" id="u30autosuggest" style="padding-left: 1190.62px; padding-right: 0px;">
        </ul>
        <div id="u30results" style="padding-left: 0px; padding-right: 0px;">
          <button id="u30closeresults" aria-label="Close Results" type="button">
            <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
              <path d="M7,7 L17,17"></path>
              <path d="M17,7 L7,17"></path>
            </svg>
            <span>Close</span>
          </button>
          <div id="u30resultsw1">
          </div>
          <div id="u30noresults">
            <div class="u30result noresults">
              <div>We’re sorry. We could not find a match for your search.</div>
              <p>We suggest you try the following to help find what you're looking for:</p>
              <ul class="u30nr1">
                <li>Check the spelling of your keyword search.</li>
                <li>Use synonyms for the keyword you typed, for example, try “application” instead of “software.”</li>
                <li>Start a new search.</li>
              </ul>
            </div>
          </div>
          <ul id="u30skel" style="left: 0px; right: 0px;">
            <li></li>
            <li></li>
            <li></li>
            <li></li>
            <li></li>
            <li></li>
            <li></li>
            <li></li>
            <li></li>
            <li></li>
          </ul>
        </div>
      </div>
      <span class="u30submit">
        <input class="u30searchbttn" type="submit" value="Submit Search">
      </span>
      <button id="u30clear" type="reset" aria-label="Clear Search">
        <span>Clear Search</span>
        <svg width="20" height="20" viewBox="0 0 20 20" fill="none" xmlns="http://www.w3.org/2000/svg">
          <path d="M7 7L13 13M7 13L13 7M19 10C19 14.9706 14.9706 19 10 19C5.02944 19 1 14.9706 1 10C1 5.02944 5.02944 1 10 1C14.9706 1 19 5.02944 19 10Z" stroke="#161513" stroke-width="2"></path>
        </svg>
      </button>
    </span>
  </div>
</form>

Text Content

 * Skip to content
 * Accessibility Policy

Contact Sales Sign in to Oracle Cloud
   
 * About
   
 * Services
   
 * Solutions
   
 * Pricing
   
 * Partners
   
 * Resources
   
   

Close Search

Close

We’re sorry. We could not find a match for your search.

We suggest you try the following to help find what you're looking for:

 * Check the spelling of your keyword search.
 * Use synonyms for the keyword you typed, for example, try “application”
   instead of “software.”
 * Start a new search.

 * 
 * 
 * 
 * 
 * 
 * 
 * 
 * 
 * 
 * 

Clear Search

Search
Menu Menu Contact Sales Sign in to Oracle Cloud

 * Database




DATABASE 23C

Oracle Database 23c delivers the most complete and simple converged database for
developers looking to build new microservice, graph, document, and relational
applications.

Get started today

What’s new in Oracle Database 23c (24:51)

Each week, we'll share a new feature of Oracle Database 23c with examples so you
can get up and running quickly. Save this page and check back each week to see
new highlighted features.


FEATURE HIGHLIGHT


LOCK-FREE COLUMN VALUE RESERVATIONS

Lock-Free Reservations enable concurrent transactions to proceed without being
blocked on updates of heavily updated rows. Lock-Free Reservations are held on
the rows instead of locking them. It verifies if the updates can succeed and
defers the updates until the transaction commit time. Lock-Free Reservations
improves the user experience and concurrency in transactions.





VIDEOS

TikTok: Rethink everything you think you know about row locking in relational
databases (0:29)





BLOGS

ACE Lucas Jellema: Oracle Database 23c—Fine-grained locking—Lock-Free
Reservations

ACE Tim Hall: Lock-Free Reservations to prevent blocking sessions in Oracle
Database 23c





TRY IT

Oracle Schema-Level Privileges and Lock-Free Column Reservations








DOCUMENTATION

Configuring Privilege and Role Authorization

Using Lock-Free Reservations








PREVIOUSLY HIGHLIGHTED FEATURES:

 * SELECT without FROM clause
 * JavaScript stored procedures
 * Schema privileges
 * Boolean data type
 * DB_DEVELOPER_ROLE
 * Kafka APIs
 * SQL Macros
 * JSON Relational Duality views


SELECT WITHOUT FROM CLAUSE

You can now run SELECT expression-only queries without a FROM clause. This new
feature improves SQL code portability and ease of use for developers.


VIDEOS

 * Game-Changing Developer Feature (0:59)


BLOGS

 * SELECT without FROM Clause in Oracle Database 23c
 * Oracle Database 23c Enhanced Querying: Eliminating the “FROM DUAL” Clause


DOCUMENTATION

 * SELECT Without FROM Clause




JAVASCRIPT STORED PROCEDURES

Multilingual engine (MLE) module calls allow developers to invoke JavaScript
functions stored in modules from SQL and PL/SQL. Call specifications written in
PL/SQL link JavaScript to PL/SQL code units. This feature enables developers to
use JavaScript functions anywhere PL/SQL functions are called.


BLOGS

 * Introduction to JavaScript in Oracle Database 23c Free—Developer Release
 * Using JavaScript community modules in Oracle Database 23c Free—Developer
   Release
 * How to import JavaScript ES modules in Oracle Database 23c Free and use them
   in SQL queries


TRY IT

 * APEX + Server Side JavaScript (MLE)
 * Simple Data Driven applications using JavaScript in Oracle Database 23c
   Free-Developer Release


DOCUMENTATION

 * Overview of JavaScript in Oracle Database




SCHEMA PRIVILEGES

Oracle Database now supports schema privileges in addition to existing object,
system, and administrative privileges. This feature improves security by
simplifying authorization for database objects to better implement the principle
of least privilege and keep the guesswork out of who should have access to what.


VIDEOS

 * Security made so much SIMPLER in 23c! (3:55)
 * So much simpler security management in 23c (1:18)


BLOGS

 * ACE Tim Hall: Schema privileges in Oracle Database 23c
 * ACE Peter Finnigan: Oracle 23c schema-level grants
 * ACE Gavin Soorma: Oracle 23c schema-level privileges and schema-only users
 * Schema-level privilege grants with Database 23c


SAMPLE CODE

 * Tutorial on Database 23c schema privilege grants


DOCUMENTATION

 * Configuring Privilege and Role Authorization




BOOLEAN DATA TYPE

Oracle Database now supports the ISO SQL standard-compliant Boolean data type.
This enables you to store True and False values in tables and use Boolean
expressions in SQL statements. The Boolean data type standardizes the storage of
Yes and No values and makes it easier to migrate to Oracle Database.


VIDEOS

 * Boom! Boolean is here in 23c, and it's easy to use (1:36)
 * Oracle 23c - Unlock the Power of Boolean Data Types (0:59)


BLOGS

 * Boolean data type in Oracle Database 23c (Oracle-Base)
 * Oracle 23c - Tipo de Datos BOOLEAN en SQL (Spanish language)
 * Oracle 23c Boolean support in SQL
 * More Boolean features in 23c
 * Boolean data type in Oracle Database 23c (Medium)


DOCUMENTATION

 * SQL Boolean Data Type




DB_DEVELOPER_ROLE

Oracle Database 23c includes the new role DB_DEVELOPER_ROLE, which provides an
application developer with all the necessary privileges to design, implement,
debug, and deploy applications on Oracle Databases. By using this role,
administrators no longer have to guess which privileges may be necessary for
application development.


BLOGS

 * DB_DEVELOPER_ROLE in Oracle Database 23c
 * Comparing the RESOURCE, CONNECT, and DEVELOPER roles


DOCUMENTATION

 * Use of the DB_DEVELOPER_ROLE Role for Application Developers




KAFKA APIS

Oracle Database 23c provides even more refined compatibility for Apache Kafka
applications with Oracle Database. This new feature provides easy migration for
Kafka Java applications to Transactional Event Queues (TxEventQ). Kafka Java
APIs can now connect to Oracle Database server and use TxEventQ as a messaging
platform.

Developers can easily migrate an existing Java application that uses Kafka to
Oracle Database using the JDBC thin driver. And with the Oracle Database 23c
client-side library feature, Kafka applications can now connect to Oracle
Database instead of a Kafka cluster and use TxEventQ's messaging platform
transparently.


TRY IT

 * Simplify Event-driven Apps with TxEventQ in Oracle Database (with Kafka
   interoperability)


ARTICLES

 * Kafka interopability in Oracle Database 23c


BLOGS

 * New 23c version of Kafka-compatible Java APIs for Transactional Event Queues
   published
 * Playing with Kafka Java Client for TxEventQ – creating the simplest of
   producers and consumers
 * Oracle REST Data Services 22.3 brings new REST APIs for Transactional Event
   Queueing


DOCUMENTATION

 * Interoperability of Transactional Event Queue with Apache Kafka (Java APIs)
 * Kafka Java Client Interface for Oracle Transactional Event Queues (Java APIs)
 * Kafka Java Client for Oracle Transactional Event Queues (Java APIs)
 * Kafka Connectors for TxEventQ (Connectors)
 * Oracle Transactional Event Queues REST Endpoints (REST APIs)




SQL MACROS

Create SQL macros to factor out common SQL expressions and statements into
reusable, parameterized constructs that can be used in other SQL statements. SQL
macros can be scalar expressions that are typically used in SELECT lists as well
as WHERE, GROUP BY, and HAVING clauses. SQL macros can also be used to
encapsulate calculations and business logic or can be table expressions,
typically used in a FROM clause. Compared to PL/SQL constructs, SQL macros can
improve performance. SQL macros increase developer productivity, simplify
collaborative development, and improve code quality.


VIDEOS

 * Create reusable SQL expressions with SQL macros (1:01:29)
 * Pattern Matching + SQL Macros = Pure SQL Awesomeness! (58:03)


TRY IT

 * Using SQL Macros Scalar and Table Expressions
 * How to Make Reusable SQL Pattern Matching Clauses with SQL Macros
 * SQL Macros: Creating Parameterized Views


BLOGS

 * How to create a parameterized view in Oracle
 * SQL macros have arrived in Autonomous Database
 * How to Make SQL Easier to Understand, Test, and Maintain


DOCUMENTATION

 * SQL_MACRO Clause




JSON RELATIONAL DUALITY VIEWS

JSON Relational Duality, an innovation introduced in Oracle Database 23c,
unifies the relational and document data models to provide the best of both
worlds. Developers can build applications in either relational or JSON paradigms
with a single source of truth and benefit from the strengths of both models.
Data is held once but can be accessed, written, and modified with either
approach. Developers benefit from ACID-compliant transactions and concurrency
controls, which means they no longer have to make trade-offs between complex
object-relational mappings or data inconsistency issues.


TRY IT

 * Explore all LiveLabs workshops on JSON Relational Duality


ARTICLES

 * Medium: ODP.NET and JSON Relational Duality and Oracle Database 23c Free


BLOGS

 * Key benefits of JSON Relational Duality
 * Use JSON Relational Duality with Oracle Database API for MongoDB
 * REST with JSON Relational Duality
 * JSON Relational Duality: The Revolutionary Convergence of Document, Object,
   and Relational Models


DOCUMENTATION

 * JSON Relational Duality Views Overview

RESOURCES FOR

 * Careers
 * Developers
 * Investors
 * Partners
 * Startups
 * Students and Educators

WHY ORACLE

 * Analyst Reports
 * Cloud Economics
 * with Microsoft Azure
 * vs. AWS
 * vs. Google Cloud
 * vs. MongoDB

LEARN

 * What is AI?
 * What is Cloud Computing?
 * What is Cloud Storage?
 * What is HPC?
 * What is IaaS?
 * What is PaaS?

WHAT’S NEW

 * Oracle Supports Ukraine
 * Oracle Cloud Free Tier
 * Cloud Architecture Center
 * Cloud Lift
 * Oracle Support Rewards
 * Oracle Red Bull Racing

CONTACT US

 * US Sales: +1.800.633.0738
 * How can we help?
 * Subscribe to emails
 * Events
 * News
 * OCI Blog

--------------------------------------------------------------------------------

 * Country/Region

 * © 2023 Oracle
 * Privacy/Do Not Sell My Info
 * Cookie-Einstellungen
 * Ad Choices
 * Careers

 * 
 * 
 * 
 * 



Oracle Chatbot

Disconnected

 * Close widget
 * Select chat language
   




 * Detect Language
 * undefined
 * Español
 * Português