In this MariaDB tutorial, we will understand the usability of the MariaDB Truncate Table statement using various examples. Moreover, we will discuss the following topics. MariaDB Truncate Table In MariaDB, the TRUNCATE TABLE statement is utilized to simply delete all the data from a MariaDB table. Utilizing the MariaDB TRUNCATE TABLE is quite similar to using the … 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 MariaDB tutorial, we will learn about the MariaDB reset root password and cover the following topics. MariaDB reset root password windows MariaDB reset root password ubuntu MariaDB reset root password mac MariaDB reset root password docker MariaDB reset root password Linux MariaDB reset root password xampp MariaDB reset root password Debian 9 MariaDB … Read more >>
In this MariaDB tutorial, we will learn about the “MariaDB Variables” which is the type of variables, and how to set the variable. Additionally, cover the following topics. MariaDB variables type First, we need to know ‘What is variable?’, a variable is used to store different kinds of values or information that can change over … 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 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 MariaDB tutorial, we will look at how to rename a view in MariaDB and we will also look at several examples related to it. There are lists of the topic that comes under discussion: MariaDB rename view MariaDB rename view example MariaDB rename view error MariaDB rename view exists MariaDB rename view foreign … Read more >>
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 how to create a table using stored procedures in oracle 21c. Also, we will cover these topics: Oracle stored procedure create table In this section, we will learn how to write a stored procedure to create a simple table in oracle database 21c. A stored procedure is created … Read more >>
A SQL Server Trigger is a specific kind of stored procedure that executes automatically whenever a database server event occurs. So, in this SQL Server tutorial, we will discuss how to define and use a SQL Server Trigger. As a Database Administrator, I usually get requirements where I need to maintain the integrity constraints in … Read more >>