This article describes nice new feature SQL_MACRO that allows to simplify coding in PL/SQL for table expressions.
HIGH_VALUE_CLOB, HIGH_VALUE_JSON for Partitioning in Oracle Database 23C
This article shows new columns HIGH_VALUE_CLOB type CLOB, HIGH_VALUE_JSON type JSON in dictionary views DBA|ALL|USER_TAB_PARTITIONS
Install Oracle Database 23C Developer Release on Oracle Linux OEL8
This article presents how to install Oracle 23C developer Release on Oracle Enterprise Linux 8 (OEL8) using RPM.
Blockchain Tables in Oracle Database 21c
Oracle 21c introduces a new feature called Blockchain Tables, which allows users to store and query data stored on a blockchain network directly in the database. This feature makes it easy to integrate blockchain data into Oracle-based applications, and enables users to leverage the security and immutability of blockchain technology while still using familiar SQL commands to access and manipulate the data.
Install Oracle APEX 21 with standalone ORDS
This article presents how to install and configure Apex 21.2 with standalone ORDS 21.2
Install Oracle Database 21C in silent mode on OEL8
This article presents how to install Oracle 21C on Oracle Enterprise Linux 8 (OEL8) in silent mode.
Install Oracle Database 21C using rpm on OEL8
This article presents how to install Oracle 21C on Oracle Enterprise Linux 8 (OEL8) using rpm
Coding standards PL/SQL SQL 2022
This article show simple coding standard that I use for coding. Simple rules clean code.
Oracle Add filter to already opened cursor in PL/SQL
In this article I show simple trick how to add extra filter to already opened cursor in PL/SQL. Continue reading
Install Oracle Database 19C in silent mode on OEL8
This article presents how to install Oracle 19C on Oracle Enterprise Linux 8 (OEL8) in silent mode.