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

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 …

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 …

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

In today’s article, we will be learning how to Control File Location and size information in Oracle. The information kept in the control file is …

In today’s article, we will be explaining the introduction and features of Oracle Database 21C. Oracle Database 21C can be used in Cloud environment such …

In today’s article, we will explain what Is Null and how to use it in PostgreSQL. Null is not a value, so NULL should not …

In today’s article, we will be explaining Add Member to Redo Log Group and Increasing the Size of a Redo Log Group. A new member …

In this topic we will see how can we change our database name using Oracle NID tool. Use the syntax bellow to change the Dtabase …

In today’s article, I will be explaining What is PostgreSQL Coalesce and how to use it. The Coalesce function is used to replace a NULL …

In today’s article, we will be explaining Redo Log Switching, Redo Log Switch Frequency and Determining Redo Log Switch Duration. Redo Log Switching [crayon-677376ab90371751641694/] Redo …