In today’s article, we will discuss the Age function in PostgreSQL, which calculates the difference in days, months, and years between two points in time. …
Read More »Background Process In Database
In today’s article, I will be explaining how we can learn about background processes running in the database. Background processes are kept in the v$process …
Read More »Oracle Cloud Database Backup With RMAN
In today’s article, we will be learning how to Backup a Database on Oracle Cloud with RMAN. Backup services are the most important insurance for …
Read More »AVG Function In PostgreSQL
In today’s article, we will discuss the AVG Function, which helps us calculate the average value of a set in PostgreSQL. The syntax of the …
Read More »Process Structure In Oracle
In today’s article, we will be examining the process structure in Oracle, which is a mechanism used by the operating system. Processes, a mechanism used …
Read More »Admin Option Oracle
In today’s article, we will learn how to find Assigned Users using the ADMIN_OPTION role in Oracle Database. We will perform a security scan on …
Read More »PostgreSQL MIN() Function
In today’s article, we will explain and give an example about the MIN() Function, which returns the minimum value in PostgreSQL. PostgreSQL MIN() function is …
Read More »PostgreSQL Database Patch
In today’s article, we will be implementing the Patch process in the PostgreSQL database. Patching the PostgreSQL database is easier than other databases. We can …
Read More »What Is a Shared Pool In Oracle?
In today’s article, we will examine the Shared Pool and its subcomponents, which are involved in almost every event that occurs in the database. Parsed …
Read More »Single Instance 19C Database Installation Part 3
In this part of our article series, we will install Oracle Database 19C, which is the last step of the Single Instance (Standalone) 19C Database …
Read More »