In this Oracle tutorial, we will learn how to add foreign key constraints to the oracle database. We are currently working on oracle 19c but this tutorial will work for all the versions of the oracle database. Here is the list of topics that we are going to discuss. Oracle how to add foreign key … Read more >>
In this Oracle tutorial, we will learn about the oracle to_char date format using various examples. Additionally, we will also cover these topics: Oracle to_char date format Oracle to_char date format options Oracle to_char date format milliseconds Oracle to_char date format microseconds Oracle to_char date format am/pm Oracle to_char date form at in where clause … Read more >>
In this MariaDB tutorial, we will learn about the “MariaDB window functions” using some examples. Moreover, we will cover the following topics. MariaDB window functions MariaDB window function rank MariaDB window function count MariaDB columnstore window functions MariaDB window functions The term WINDOW is referred to the set of rows in a MariaDB. The window function … 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 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 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 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 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 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 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 >>