Bijay 
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 MariaDB tutorial, we will study the use of the MariaDB Set Variable statements and we will also cover some examples. There are lists of the topic that comes under discussion: MariaDB set variable MariaDB set variable from select MariaDB set global variable permanently MariaDB set environmental variable MariaDB set user variable MariaDB set … Read more >>
In this MariaDB tutorial, we will learn about MariaDB Select Into statement by using multiple examples. Additionally, we will cover the following topics. MariaDB Select Into MariaDB Select Into Table MariaDB Select Into Outfile MariaDB Select Into Dumpfile MariaDB Select Into Temporary Table MariaDB Select Into Multiple Variables MariaDB Select Into CSV MariaDB Select Into … 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 MariaDB tutorial, we are going to learn about the “MariaDB regexp” using various examples in MariaDB. Additionally, we will cover the following topics. MariaDB regexp_replace MariaDB regexp MariaDB regexp_substr MariaDB regexp_like MariaDB regexp_instr MariaDB regexp_replace does not exist MariaDB regexp_substr multiple MariaDB regexp_replace multiline MariaDB regexp in where clause MariaDB regexp_replace space MariaDB … 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 MariaDB tutorial, we will learn about MariaDB Case Statement. Here we will illustrate various examples related to the MariaDB case statement. Additionally, we will cover the following topics MariaDB Case Statement MariaDB Case Statement With Select MariaDB Case Statement Examples MariaDB Case When Multiple Conditions MariaDB Case When Like MariaDB Case With Where … 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 >>
In this MariaDB tutorial, we will study the use of the MariaDB on duplicate key update statements and we will also cover some examples. There are lists of the topic that comes under discussion: MariaDB on duplicate key update MariaDB on duplicate key update multiple value MariaDB on duplicate key update not working MariaDB on duplicate … Read more >>
Download A 40 pages PDF And Learn Now.