Latest Articles
Oracle REST Data Services (ORDS) : Database Authentication
Use database authentication to provide basic authentication for your calls to PL/SQL from Oracle REST Data Services (ORDS).
JSON Support Enhancements in Oracle Database 18c
Oracle 18c includes several enhancements to the JSON functionality in the database. This article details some of them, as well as linking to separate articles on others.
SODA for PL/SQL in Oracle Database 18c
This article gives an overview of the Simple Oracle Document Access (SODA) for PL/SQL functionality in Oracle Database 18c.
TO_UTC_TIMESTAMP_TZ Function in Oracle Database 18c
Oracle 18c introduced the new TO_UTC_TIMESTAMP_TZ function to help deal with ISO 8601 date strings.
JSON_TABLE Enhancements in Oracle Database 18c
This article covers the enhancements to the JSON_TABLE function in Oracle Database 18c.
JSON Data Guide Enhancements in Oracle Database 18c
This article covers the enhancements to the JSON Data Guide functionality in Oracle Database 18c.
JSON_EQUAL Condition in Oracle Database 18c
The JSON_EQUAL condition was introduced in 18c to allow JSON documents to be compared regardless of member order or document formatting.
TREAT(... AS JSON) in Oracle Database 18c
In Oracle 18c the TREAT function can be used in SQL to change the declared type of an expression to JSON, where the expression is an object containing JSON data.
Schema Only Accounts in Oracle Database 18c
Schema only accounts don't allow direct connections, so administration of their objects is done via a DBA user or a proxy user.
Qualified Expressions in PL/SQL in Oracle Database 18c
Qualified expressions provide and alternative way to define the value of complex objects, which in some cases can make the code look neater.
DBMS_SESSION.SLEEP Replaces DBMS_LOCK.SLEEP in Oracle Database 18c
The SLEEP procedure is added to the DBMS_SESSION package and deprecated from the DBMS_LOCK package in Oracle Database 18c.
ALTER SYSTEM CANCEL SQL : Cancel a SQL Statement in a Session in Oracle Database 18c
The ability to cancel a SQL statement using the ALTER SYSTEM CANCEL SQL statement was introduced in Oracle Database 18c as an alternative to killing a rogue session.
Inline External Tables in Oracle Database 18c
Oracle Database 18c allows you to access data in flat files using an inline external table defined in a SELECT statement.
Approximate Top-N Query Processing (APPROX_RANK, APPROX_SUM, APPROX_COUNT) In Oracle Database 18c
The APPROX_RANK, APPROX_SUM and APPROX_COUNT functions were introduced in Oracle 18c to allow approximate top-n query processing.
Online MERGE PARTITION and MERGE SUBPARTITION in Oracle Database 18c
In Oracle Database 18c the MERGE PARTITION and MERGE SUBPARTITION operations on heap tables can be performed online so they don't block DML.
Private Temporary Tables in Oracle Database 18c
Oracle 18c introduced the concept of a private temporary table, a memory-based temporary table that is dropped at the end of the session or transaction depending on the setup.
Latest Videos
Check out my YouTube channel here.
- Table Point In Time Recovery (PITR) in 12c
- Oracle Data Guard Broker
- CASE Expressions and CASE Statements
- Indexing JSON Data in Oracle Database 12c
- JSON Support in Oracle Database 12c
Quick Links
- SQL for Beginners
- Multitenant Articles
- ORDS Articles
- JSON Articles
- Docker Articles
- Writing Tips
- Public Speaking Tips
- Learning New Things
- What Employers Want
You can follow me on these networks:
You can get an oracle-base.com t-shirt here.
Oracle Documentation
8iR3,
9iR1,
9iR2
10gR1,
10gR2,
11gR1,
11gR2
12cR1,
12cR2,
18c
ORDS 3.0,
ORDS 17,
ORDS 18
EM 10g,
EM 11g,
EM 12c,
EM 13c
AS10g R2,
AS10g R3,
FMW 11gR1,
FMW 12cR1,
FMW 12cR2
Oracle VM,
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