Anas Darkal

-->

Latest Posts

Upgrade Oracle 19c Autonomous Database to 26ai

Introduction:

Read More

Create OCI Kubernetes Cluster (OKE)

Introduction:

Read More

Securing Oracle Database with Industry Standards and Best Practices

Introduction Oracle Enterprise Manager (OEM) provides a solution to secure and ensure compliance with security policies defined by security officers and auditors. With the Audit..

Read More

Enable and Review OCI Cloud Advisor

Introduction:

Read More

Create and Test OCI Security Zone

Introduction:

Read More

Oracle 23ai: Lock Free Reservations Capability

Overview: In previous database releases when a column value of a row is updated by adding or subtracting from it, all other updates to that row are blocked until the transaction..

Read More

Oracle 23ai: Unrestricted Parallel DMLs

Overview: Oracle database allows DML statements to be executed in parallel mode by breaking the DML statements into exclusive smaller tasks. However, in releases prior to Oracle..

Read More

Oracle Database 23ai: Fetch Top-N Rows Per Group Queries

Overview: Oracle 23ai introduces partition by clause in fetch first clause to get top-N rows per group. A query’s syntax SELECT …….. FROM …….. ORDER BY , FETCH FIRST , ROWS ONLY..

Read More

Oracle 23ai: Enumeration Domains – List of Values in the Database

Overview: Oracle Database 23ai introduces a new way to create lists of values: enumeration (enum) domains Benefits: Create lists of name-value pairs in the database Query the enum..

Read More

Oracle 23ai: Quick Overview

Oracle Database 23ai Oracle Database 23ai is the next long-term support release of Oracle Database It brings AI to your data with the addition of AI Vector search to Oracle’s..

Read More