26ai_en Oracle GoldenGate 23ai Operations Guide: Startup/Shutdown Procedures and Permission Settings
This document outlines the standard startup and shutdown procedures for Oracle GoldenGate 23ai (Microservices Architectu...
oracle master
26ai_en 26ai_en [Verification] Tried Installing Oracle AI Database 26ai (Single) on OL8
Oracle AI Database 26ai was released the other day. I was able to download it immediately, so this time I tried installi...
26ai_en [Breaking News] Oracle AI Database 26ai On-premises Download Available! OSDC Availability and GI Support
Updated Jan 28, 2026: The highly anticipated on-premises version (Linux x86-64) of Oracle AI Database 26ai and Oracle Gr...
26ai_en [Diagram] Oracle GoldenGate Process Architecture Mechanics | Classic vs MA
When handling Oracle GoldenGate (OGG) in practice, the most important thing is to accurately understand the "Data Flow" ...
26ai_en Oracle GoldenGate 19c/23ai Overview: Differences Between MA and Classic
Oracle GoldenGate is the de facto standard tool for real-time data integration between Oracle Databases. Its importance ...
26ai_en Oracle GoldenGate 23ai Setup | DB 26ai Free Replication
This article explains the procedure for performing data replication between Oracle Database 26ai Free environments using...
26ai_en Oracle AWR Usage Guide: Steps to Generate Reports and Basics of Analysis [26ai Compatible]
Oracle AWR (Automatic Workload Repository) is the de facto standard for performance analysis in Oracle Database Enterpri...
26ai_en Oracle Statspack Usage: Installation and Automatic Snapshot Configuration in 26ai Free (PDB) Environment
Oracle Statspack is a powerful free tool for performance analysis in Standard Edition (SE2) and the latest Oracle Databa...
English Applied Oracle SQL Aggregation! Re-aggregating GROUP BY Results and ROLLUP
"I was able to calculate the total salary for each department. But how do I get the average of those department totals?"...
English A Comprehensive Guide to NULLIF and COALESCE Functions: Practical Applications
1. IntroductionHandling NULL values is unavoidable when working with Oracle databases. This article provides a detailed ...
English Oracle SQL: The Difference Between WHERE and HAVING! Execution Order and Usage
When writing SQL for Oracle Database, the difference between the WHERE clause and the HAVING clause is one of the most c...
English Oracle SQL Aggregate Functions: Handling NULLs and Using DISTINCT
"The total sum is less than expected." "The average value doesn't match my manual calculation."When performing data anal...
English How to Use Oracle SQL GROUP BY and HAVING! Aggregation and Conditions
"I want to calculate the total salary for each department." "I want to extract only classes with an average score of 80 ...
Data Types_en Explicit Data Type Conversion: The Basics and Applications for Error-Free SQL
In Oracle Database, the need to handle different data types arises frequently. When this happens, it is crucial to perfo...
26ai_en Oracle AI Database 26ai: Usage of BOOLEAN Data Type and New SQL Common Sense
Oracle AI Database 26ai, the latest Long Term Support (LTS) release, was announced in October 2025.In this version, the ...
26ai_en Oracle 26ai SQL Firewall Implementation and Verification Guide
Oracle AI Database 26ai / SQL Firewall / Injection Countermeasures / SecurityIn this article, I will explain the impleme...
English [Oracle SQL] Why is Deeply Nested Code Disliked? Learning “Appropriate Single-Row Function Nesting”
Single-row functions provided by Oracle Database are convenient tools that make data transformation and processing easy....
English 5 Essential Oracle SQL Aggregate Functions! How to Use SUM, AVG, and COUNT
Aggregate functions are essential for data analysis and report creation in Oracle Database. This article explains the us...
English [Oracle SQL] Replacing NULL with NVL/NVL2 Functions! Preventing Calculation Errors
In Oracle Database, the biggest cause of discrepancies in SQL aggregation and calculation results lies in the handling o...
26ai_en [Definitive Guide] The World’s Easiest Explanation of Oracle AI Vector Search & Hands-on
Hello everyone. Have you tried the currently trending "Oracle Database 26ai (and 23ai)" yet? Today, I will explain the n...