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

In today’s article, I will be explaining how to shrink the tables in the Oracle database. One of the issues that we, as database administrators, …

In today’s article, I will explain the Abort, Normal, Immediate, Transactional and Startup Force commands to close the oracle database. Shutdown Abort: 1. It is …

In today’s article, we will be cover about pulling a conditional row from the Table with the where command in PostgreSQL. The where command is …

In today’s article, we will be cover the Database Opening Steps, Nomount, Mount and Open. Nomount: 1. The parameters in the spfile parameter file are …

Today, we will examine the AHF tool offered by Oracle, which offers us the tools we used as orachk and exachk with more advanced features. …

In today’s article, we will cover What is Select and How to Write a Basic Select Statement. Select is a postgresql sentence used to convey …

In today’s article, I will cover you about the Data Import process and the parts to pay attention to in this process. IMPORT PROCESS 1. …

In today’s article, we will free the RedHat operating system by converting it to the Oracle Linux operating system. In this way, you will be …

The combination of select, insert, update and delete operations is called DML (Data Manipulation Language). If you are dealing with databases, it is definitely something …

In today’s article, I will give information about the Data Export and Export processes. In order for us to export with the expdp tool: We …