Database Size in Oracle 21c

database size in oracle

In this Oracle tutorial, we will learn how to check database size in oracle 21c. We are working on the latest version of oracle i.e. 21c but the steps shared will work on other versions as well. Also, we will cover these topics. Database size in oracle 21c DB size in oracle 11g Full database …

Read more

Oracle Drop Database

write sql query to drop database in oracle 21c

In this Oracle tutorial, we will learn how to drop databases in oracle 19c & 21c. Also, we will cover these topics. Oracle drop database Oracle SQL drop database Oracle drop database link Oracle grant drop database link Oracle sql developer drop database Oracle dbca drop database silent Oracle drop database including backups Oracle drop database …

Read more

Oracle how to copy a table

Oracle how to copy a table without data

In this Oracle tutorial, we will learn how to copy a table in oracle databases 19c and 21c. Also, we will cover these topics. Oracle how to copy a table Oracle how to copy a table without data Oracle how to copy a table with data Oracle fastest way to copy a table Oracle how to …

Read more

Oracle Create User – Detailed Guide

Oracle create user with dba privileges

In this Oracle tutorial, we will learn how to create a user in the oracle database 21c & 19c. Also, we will cover these topics: Oracle create user Oracle create a user with all privileges Oracle create a user and grant all privileges Oracle create a user with dba privileges Oracle create a user with …

Read more

How to convert rows into columns in Oracle

Oracle how to convert rows into columns

In this Oracle tutorial, we will learn how to convert rows into columns in oracle databases 19c & 21c. Also, we will cover these topics. Oracle how to convert rows into columns Oracle how to transpose rows into columns Oracle turn rows into columns Oracle function to convert rows into columns How to convert rows …

Read more

Oracle check database status

Oracle check database status

In this Oracle tutorial, we will learn how to check database status in oracle databases 19c & 21c. Also, we will cover these topics. Oracle check database status Oracle check database status windows Check Oracle database status shell script How to check oracle database status in Unix Oracle check pluggable database status Oracle check standby …

Read more

How to Install Oracle on Docker

Set up Oracle enterprise image on docker

In this Oracle tutorial, we will learn how to install oracle on docker. The entire tutorial is divided into the following two parts: Install docker on windows Install Oracle on docker How to Install Oracle on Docker Docker is a containerization tool used to install a light version of any application. Docker is a part …

Read more

Connect to oracle database

Connect to oracle database from Docker container

In this Oracle tutorial, we will learn how to connect to oracle databases 19c & 21c. Also, we will cover these topics in this tutorial. Connect to oracle database command line Connect to oracle database in Linux Connect to oracle database from Docker container Connect to oracle database using SQL developer Connect to oracle database …

Read more

Oracle get database name

Oracle get database name from dual

In this Oracle tutorial, we will learn about the oracle get database name in oracle database 19c & 21c. Also, we will cover these topics. Oracle get database name sql Oracle get database name from dual Oracle get database name from sys_context Oracle get global database name Oracle get database instance name Oracle get database …

Read more

Oracle Add Row Number

what is row number in oracle database

In this Oracle tutorial, we will learn how to add row numbers to the oracle database. We are working on Oracle database 19c but the steps shared in this tutorial will work on all the versions of the oracle database. What is Add Row Number in Oracle database Oracle how to add row number Oracle …

Read more