In today’s article, What is a PostgreSQL Temporary Table? and How to Create? We will inform you about the subject. Most of the things I …
Read More »Oracle Remap Table
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 …
Read More »ORA-39070: Unable To Open The Log File
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: …
Read More »PostgreSQL Generated Column
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-67abdd893add2786286008/]
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-67abdd893af6f716139991/] Since we gave …
Read More »Oracle Export Flashback_Time
In today’s post, we will cover How to Use Flashback during Export. [crayon-67abdd893b165495047635/] [crayon-67abdd893b169708427644/] This value is found as follows; [crayon-67abdd893b16b589357060/]
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-67abdd893b31e308413881/]
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 »