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

In today’s article, we will be talking about Adding a Record to a PostgreSQL Table with the Insert Statement. In order to add data to …

In today’s article I will be explaining how we can Authorize the User with ‘WITH GRANT OPTION’. When Grant is given with Grant Option, the …

In today’s article, I will introduce the “Virtual Private Database” feature, which is one of the security policies offered by Oracle. With Virtual Private Database, …

Distinct statement is an SQL statement that is used to show only one of several identical records in a table. Let’s reinforce it with an …

In today’s article, I will explain how to create a user. The person who will create a user in the database must have “CREATE USER” …

In this article, we will introduce the DBMS_AUTO_INDEX feature, which acts with the autonomous database policy first on the database side and then in the …

In today’s article, we will cover Using Select Into in PostgreSQL. I will use the pagila database for this. Let’s get to know the subject …

In today’s article, we will learn how long the Database software and Server have been running with the help of the uptime command. We can …

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 …