In today’s article, I will explain how you can use the HAVING clause to add conditions in aggregate functions. The HAVING clause is often used …
Read More »Oracle Database Memory Structure
In today’s article, we will be examining the memory structure of the Oracle database. The memory structure of the Oracle database consists of two parts. …
Read More »Oracle Exadata
In this article, we will examine the features of Oracle Exadata and what makes Oracle Exadata so good and unrivaled. Oracle Exadata is often compared …
Read More »PostgreSQL Group By
In today’s article, we will be learning the GROUP BY command, which allows us to perform operations by grouping columns. GROUP BY also has functions …
Read More »Oracle Parameter File
In today’s article, we will cover the features and important parameters of Parameter Files in Oracle. When opening the database, the parameters in this file …
Read More »How To Install Oracle Weblogic Server 14
In today’s article, we will be installing Oracle Weblogic server 14.1.1.0 on Java JDK 1.8 version on Linux 7 operating system. Weblogic is the world’s …
Read More »Order By PostgreSQL
In today’s article, we will learn how to sort data with the Order By command in PostgreSQL. With the Order By command, this order can …
Read More »What Is Password File In Oracle
In today’s article, we will explain what a password file is, how to create it and how to use it. For non-SYS users, a password …
Read More »Oracle Database Grid 19C Upgrade 19.3 To 19.9
In today’s article, I will explain how to upgrade our Oracle Database 19.3 database built on Grid Infrastructure. The database we will upgrade is running …
Read More »PostgreSQL Not Null
In today’s article, we will be explaining what NOT NULL is and how to use it, which is the opposite of IS NULL in PostgreSQL. …
Read More »