8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Latest Articles
CEIL and FLOOR Support DATE, TIMESTAMP, and INTERVAL Data Types in Oracle Database 23c
In Oracle database 23c the CEIL and FLOOR functions support the DATE, TIMESTAMP and INTERVAL data types.
Loading SODA Collections with SQL*Loader in Oracle Database 23c
In Oracle 23c we can use SQL*Loader to load JSON data into a Simple Oracle Document Access (SODA) collection.
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.
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.
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.
Oracle Database 21c Installation On Fedora 38 (F38)
This article describes the installation of Oracle Database 21c 64-bit on Fedora 38 (F38).
Oracle Database 19c Installation On Fedora 38 (F38)
This article describes the installation of Oracle Database 19c 64-bit on Fedora 38 (F38).
Fedora 38 (F38) Installation
This article provides a pictorial guide for performing a basic server installation of Fedora 38 (F38).
JSON Schema in Oracle 23c
In Oracle 23c a JSON Schema can validate the structure and contents of JSON documents in your database.
JSON_TRANSFORM Enhancements in Oracle Database 23c
In Oracle 23c the JSON_TRANSFORM function has lots of new operations, conditional control and richer path support.
Aggregation over INTERVAL Datatypes in Oracle Database 23c
Oracle 23c allows us to use the SUM and AVG aggregate and analytic functions with INTERVAL datatypes for the first time.
Oracle REST Data Services (ORDS) : AutoREST of JSON-Relational Duality Views
This article gives an overview of the AutoREST functionality of Oracle REST Data Services (ORDS) against JSON-relational duality views in Oracle 23c.
Automatic PL/SQL to SQL Transpiler in Oracle Database 23c
The automatic SQL transpiler in Oracle 23c allows some functions to be converted into SQL expressions to reduce the overhead of function calls in SQL.
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.
DEFAULT ON NULL FOR INSERT AND UPDATE in Oracle Database 23c
In Oracle 23c we can define a column as DEFAULT ON NULL FOR INSERT AND UPDATE. This replaces explicit null values with the default value in update statements.
DML RETURNING Clause Enhancements in Oracle Database 23c
This article demonstrates the enhancements to the DML RETURNING clause introduced in Oracle database 23c.
Latest Videos
Check out my YouTube channel here.
- Data Pump LOGTIME
- Data Pump Checksums in Oracle Database 21c
- RANK and DENSE_RANK Aggregate Functions
- SQLcl : Data Pump (Part 2)
- Ansible Playbooks : Vault
- Ansible Playbooks : Roles
- Ansible Playbooks : Users and Groups
- Ansible Playbooks : Tags
Quick Links
- SQL for Beginners
- Multitenant Articles
- ORDS Articles
- JSON Articles
- Docker/Container Articles
- Writing Tips
- Public Speaking Tips
- Learning New Things
- What Employers Want
- Why Automation Matters
You can follow me on these networks:
Oracle Documentation
12cR1,
12cR2,
18c,
19c,
21c,
23c
ORDS 19,
ORDS 20,
ORDS 21,
ORDS 22,
ORDS 23
APEX 22.1,
APEX 22.2,
APEX 23.1,
APEX Old Releases
ADW,
ATP
EM 13c,
Middleware,
VirtualBox
Oracle Resources
Oracle Developer Community,
Technology Network,
Oracle Support,
Oracle Certification,
Oracle Magazine,
Ask Tom,
Products,
Downloads,
Documentation,
Forums,
VirtualBox,
VirtualBox Developer VMs,
CPUs/PSUs/BPs/RUs/RURs,
Release Schedule of Current Database Releases (Doc ID 742060.1)