Oracle stored procedure create table

Oracle stored procedure create table as select

In this Oracle tutorial, we will learn how to create a table using stored procedures in oracle 21c. Also, we will cover these topics: Oracle stored procedure create table Oracle stored procedure create table as select Oracle stored procedure create table if not exists Oracle stored procedure create table insufficient privileges Oracle stored procedure create … Read more >>

Oracle Install sample schemas 21c

unable to open file __SUB__WD__ mksample.sql

After the successful installation of oracle 19c or 21c on your windows 10 operating system. You have to create databases, tables, views, stored procedures, etc before you can start practicing the oracle. If you are an absolute beginner then, a sample database might be a great help in the journey of learning the oracle database. … Read more >>

Oracle Stored Procedure

What is recursive stored procedure in oracle-21c

In this Oracle tutorial, we will learn what are stored procedures and how to create and execute them in oracle 21c. Also, we will cover these topics: What is stored procedure in oracle SQL? What is recursive stored procedure in oracle? What is type in stored procedure in oracle 21c? What is out parameter in … Read more >>

How to backup table in Oracle

How to create backup table in oracle sql developer

In this Oracle tutorial, we will learn how to take backup in oracle database 21c. Steps shared in this tutorial, will work on oracle 11g, 12c, 19c & 21c. Also, we will cover these topics: How to backup table in oracle How to create backup table in oracle using rman How to take backup of … Read more >>

Oracle Change Database Name

change database in oracle error ora-01127

In this Oracle tutorial, we will learn how to change the database names in oracle database 21c, 19c, and 12c. Also, we will cover these topics. Oracle change database name Oracle change database name 21c, 19c, 12c Oracle change db_unique_name 19c How to check database name in oracle 19c RAC Oracle change database name control … Read more >>

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 >>