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.
Oracle HTTP Server (OHS) 11g and 12c : Configure SSL
This article describes how to configure SSL for Oracle HTTP Server (OHS) 11g and 12c.
Oracle HTTP Server (OHS) 12cR2 (12.2.1) Installation on Oracle Linux 6 and 7
This article demonstrates how to perform an installation of Oracle HTTP Server (OHS) on Oracle Linux.
Oracle REST Data Services (ORDS) : Use SQLcl to Display ORDS Web Service Definitions
SQLcl is a lightweight Java-based replacement for SQL*Plus, which amongst other things allows you to display ORDS web service definitions using theREST command
Docker : Docker Compose - Defining Multi-Container Applications
This article describes how to use Docker Compose to create multi-container applications.
JSON Data Guide in Oracle Database 12c Release 2 (12.2)
Simplify the interaction with JSON data stored in the database using the JSON Data Guide functionality introduced in Oracle Database 12c Release 2 (12.2).
Docker : Upgrade an Oracle Database on Docker
This article discusses the issues related to upgrading an Oracle Database running on a Docker container.
Docker : Clean Up Unwanted Containers, Images, Volumes and Networks
It's easy for Docker to consume large amounts of space holding things you are no longer using. This article shows how to identify and clean up unused containers, images, layers, volumes and networks.
Docker : Oracle REST Data Services (ORDS) on Docker
This article describes a simple build for running Oracle REST Data Services (ORDS) on Docker.
Docker : Oracle Database on Docker
This article describes a simple build for running an Oracle database on Docker.
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