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

In the table, we can use column restrictions on how to keep the data in general, whether to enter a null value in the relevant …

We can use the existing dump file with the same name only once. If we want to use it continuously, reuse_dumpfiles=y is used. [crayon-6766ca7bb3b5b540532186/]

In today’s article, I will answer the question of How to Empty the Trash in Oracle Database. To remove the entire contents of your recycle …

In this article, I explain how we can create the new table to be created based on a different table, with and without data. I …

Today I will be explaining How to Make Copy of Schema in Oracle Data Pump. 1. We take an export backup of the schema to …

In today’s article, I will share with you the solution to the error I got after restoring the backup database from the RMAN backup. Error: …

In today’s article, we will talk about What is a Table in PostgreSQL and How to Create it. We opened our database to collect our …

It may be necessary to temporarily stop a running export/import process for some reason. In this case, we may need to attach it first. 1. …

In today’s article we will learn How to See Active Session in Oracle Database. With the help of the code block below, we can see …

In today’s article, we will learn about integer data types and the last values they will take in the range section. These values are given …