Oracle Cloud : Autonomous Data Warehouse (ADW) - Create Service
This article provides a run through of creating a new Autonomous Data Warehouse (ADW) service on the Oracle Cloud.
Upgrade Oracle Enterprise Manager Cloud Control 13c Release 2 (13cR2) to 13c Release 3 (13cR3)
This article describes a simple upgrade of Enterprise Manager Cloud Control 13c Release 2 (13cR2) to 13c Release 3 (13cR3).
Oracle Enterprise Manager Cloud Control 13c Release 3 (22.214.171.124) Installation on Oracle Linux 6 and 7
This article describes the installation of Oracle Enterprise Manager Cloud Control 13c Release 3 (126.96.36.199) on Oracle Linux 6 and 7.
Oracle Database 12c Release 2 (12.2) Installation On Fedora 28 (F28)
A brief guide to installing Oracle 12c Release 2 (12.2) on Fedora 28 (F28).
Fedora 28 (F28) Installation
This article provides a pictorial guide for performing a basic server installation of Fedora 28 (F28).
Oracle REST Data Services (ORDS) : Custom Authentication Schemes
This article gives an example of how you could develop your own custom authentication scheme for Oracle REST Data Services (ORDS).
Oracle REST Data Services (ORDS) : RESTful Web Services Handling Media (Documents and Images)
This article demonstrates how to create RESTful web services that handle media, such as documents and images, using Oracle REST Data Services (ORDS).
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.
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
- 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 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