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

In today’s article, we will learn how we can create a Oracle Remap Table in three steps. 1. The table is exported from the first …

Today, I will be sharing with you the reasons for the ORA-39070 error we received on Oracle Database and how to solve it. Error; ORA-39070: …

PostgreSQL Generated Column (Computed Column) is an operation on two or more columns and printing them into a different column. Computed Column is available with …

In some cases, it may be desirable to make a copy of an existing schema or to transfer a schema from one database to another. …

In today’s article we will cover how we can see the Most Used or Executed SQL Queries (Last 20). [crayon-6a0aa52e0e4ce952155820/]

In today’s article, I will be explaining how to Use Sequence of Different Table in PostgreSQL. We create our first table. [crayon-6a0aa52e0e67d962950249/] Since we gave …

In today’s post, we will cover How to Use Flashback during Export. [crayon-6a0aa52e0e8be630787360/] [crayon-6a0aa52e0e8c2121180604/] This value is found as follows; [crayon-6a0aa52e0e8c4891614232/]  

In today’s article, we will learn how to see users who access Oracle Database or users who get an error while accessing. [crayon-6a0aa52e0ea9f756798281/]

In today’s article, I will tell you what postgresql sequence is and how it was created. Sequence is a tool created for self -increasing numbers …

In today’s article, we will be learning to use Parallel during Export in data pump. [crayon-6a0aa52e0ee4a037461800/] Here; %u: Let the names of the Dump Files …