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 …
Read More »Remap Schema
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. …
Read More »Most Used SQL Queries
In today’s article we will cover how we can see the Most Used or Executed SQL Queries (Last 20). [crayon-6605f90b40168682923020/]
Read More »Use Sequence of Different Table In PostgreSQL
In today’s article, I will be explaining how to Use Sequence of Different Table in PostgreSQL. We create our first table. [crayon-6605f90b402e1458422170/] Since we gave …
Read More »Oracle Export Flashback_Time
In today’s post, we will cover How to Use Flashback during Export. [crayon-6605f90b404d1454932688/] [crayon-6605f90b404d5717477715/] This value is found as follows; [crayon-6605f90b404d7801380922/]
Read More »Access Control in Oracle
In today’s article, we will learn how to see users who access Oracle Database or users who get an error while accessing. [crayon-6605f90b40658422978824/]
Read More »PostgreSQL Sequence
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 …
Read More »Parallel Export
In today’s article, we will be learning to use Parallel during Export in data pump. [crayon-6605f90b40a1b025010773/] Here; %u: Let the names of the Dump Files …
Read More »Who Are Using Temp Tablespace In Oracle
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-6605f90b40bc4591848815/]
Read More »Primary Key And Foreign Key In PostgreSQL
In this article, I will make examples by explaining primary key and foreign key on delete and on update. [crayon-6605f90b40d62136913647/] While creating the personnel table …
Read More »