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

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

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

In today’s post, we will cover How to Use Flashback during Export. [crayon-67d4f412e743b531688024/] [crayon-67d4f412e7440856541923/] This value is found as follows; [crayon-67d4f412e7442913744563/]  

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

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-67d4f412e7954310099982/] Here; %u: Let the names of the Dump Files …

In today’s article, we will be learning Who Uses Temp Tablespace in Oracle Database. We can find out using the following code block. [crayon-67d4f412e7aaf840828097/]  

In this article, I will make examples by explaining primary key and foreign key on delete and on update. [crayon-67d4f412e7bf3168689129/] While creating the personnel table …

We use ENCRYPTION as Encryption parameter in Oracle Data Pump. We can use the ENCRYPTION parameter with the values ALL, DATA_ONLY, METADATA_ONLY and ENCRYPTED_COLUMNS_ONLY. [crayon-67d4f412e7d71290777924/]

In today’s article we will be learning How to See Block Session in Oracle Database. We can see the Block Session with the help of …