Distinct statement is an SQL statement that is used to show only one of several identical records in a table. Let’s reinforce it with an …
Read More »Oracle Create User
In today’s article, I will explain how to create a user. The person who will create a user in the database must have “CREATE USER” …
Read More »Automatic Indexing In Oracle 19c
In this article, we will introduce the DBMS_AUTO_INDEX feature, which acts with the autonomous database policy first on the database side and then in the …
Read More »Select Into In PostgreSQL
In today’s article, we will cover Using Select Into in PostgreSQL. I will use the pagila database for this. Let’s get to know the subject …
Read More »Oracle Database Uptime
In today’s article, we will learn how long the Database software and Server have been running with the help of the uptime command. We can …
Read More »Shrink Table In Oracle
In today’s article, I will be explaining how to shrink the tables in the Oracle database. One of the issues that we, as database administrators, …
Read More »Command To Shutdown Oracle Database
In today’s article, I will explain the Abort, Normal, Immediate, Transactional and Startup Force commands to close the oracle database. Shutdown Abort: 1. It is …
Read More »Where Command In PostgreSQL
In today’s article, we will be cover about pulling a conditional row from the Table with the where command in PostgreSQL. The where command is …
Read More »How To Open Database File
In today’s article, we will be cover the Database Opening Steps, Nomount, Mount and Open. Nomount: 1. The parameters in the spfile parameter file are …
Read More »Oracle Autonomous Health Framework
Today, we will examine the AHF tool offered by Oracle, which offers us the tools we used as orachk and exachk with more advanced features. …
Read More »