Check out Oracle tutorials.
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 >>
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? A stored procedure is the block of oracle SQL statements that are compiled once and then can be used multiple times. … Read more >>
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 Backup plays an important role in saving up the company data during an emergency. … Read more >>
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 drop database means removing or deleting the oracle database. In an organization, test databases are dropped after the purpose is served. Apart from that, there are very rare chances that … Read more >>
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 Copy a table in oracle means duplicating the columns and values in a new table. This new table can be inside the same schema or a … Read more >>
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 provides a Pivot clause using which we can convert rows into columns. This clause helps in displaying huge data nicely on the … Read more >>
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 Before you start working with the database in oracle it is important that the database is in an active state. Oracle object V$INSTANCE keeps the record of … Read more >>
In this Oracle tutorial, we will learn how to install oracle on docker. The entire tutorial is divided into the following two parts: How to Install Oracle on Docker Docker is a containerization tool used to install a light version of any application. Docker is a part of DevOps (Development & Operations) which facilitates the … Read more >>
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 Using v$database, you can get the name of all the databases in oracle database 19c & 21c. SQL developer tool displays more information than sqlplus. … Read more >>
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. Run the below script to create a table with records. Moving forward, we will use … Read more >>
Download A 40 pages PDF And Learn Now.