This article presents how to install Oracle 23AI Release on Oracle Enterprise Linux 9 (OEL9) using RPM.

Continue reading →

This article presents how to install Oracle Enterprise Linux 9.

I assume you have already downloaded Oracle Enterprise Linux 9 64 bit(about 4 G) and you know how to use VirtualBox 64 bit(100M). Create virtual machine with default settings for Oracle Linux 64 bit. You can set 8GB for future Oracle database software installation and 64G for disk. Rest of options you can keep default.

Continue reading →

To avoid errors and extra errors handling in script or PL/SQL code Oracle extended CREATE/DROP DDL with IF[NOT]EXISTS clause

CREATE TABLE IF NOT EXISTS test_tbl
(
id1 NUMBER
);

DROP TABLE IF EXISTS test_tbl;

it’s real game changer for coding. Life is more simple now.

Continue reading →

This article describes nice new feature SQL_MACRO that allows to simplify coding in PL/SQL for table expressions.

Continue reading →

This article shows new columns HIGH_VALUE_CLOB type CLOB, HIGH_VALUE_JSON type JSON in dictionary views DBA|ALL|USER_TAB_PARTITIONS

Continue reading →

This article presents how to install Oracle 23C developer Release on Oracle Enterprise Linux 8 (OEL8) using RPM.

Continue reading →

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.

Continue reading →

This article presents how to install and configure Apex 21.2 with standalone ORDS 21.2

Continue reading →

This article presents how to install Oracle 21C on Oracle Enterprise Linux 8 (OEL8) in silent mode.

Continue reading →

This article presents how to install Oracle 21C on Oracle Enterprise Linux 8 (OEL8) using rpm

Continue reading →