Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

In today’s article, we will examine how to use Limit and Offset clauses and their syntax structures in PostgreSQL. Offset Clause: Offset clause is used …

In today’s article, I will be explaining how we can learn the size of the SGA (System Global Area) in Oracle. Size of SGA area; …

In today’s article, I will be explaining Oracle Exadata 2, which is a continuation of my previous article. Active Storage – Cell Offload Oracle Exadata …

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 …

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. …

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 …

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 …

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 …

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 …

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 …