SQL Server String_agg [With 12 Useful Examples]

SQl Server string_agg

In this SQL Server tutorial, we will learn and understand how the SQL Server String_Agg function works in the table. We will discuss and learn some examples so that you can understand the concept much better: SQL Server String_Agg Function SQL Server String_Agg Example SQL Server String_Agg Distinct SQL Server String_Agg Within Group SQL Server String_Agg Multiple …

Read more

SQL Server Date Format [10 Amazing Examples]

Sql Server date format mm-dd-yyyy example

This SQL Server tutorial will teach us how SQL Server Date Format dd mm yyyy works. Moreover, we will discuss and learn some examples so that you can understand the concept much better. Here is the complete list of topics that we will cover. SQL Server Date Format mm/dd/yyyy SQL Server Date Format mm/dd/yyyy hh:mm:ss SQL …

Read more

Introduction to SQL Server Trigger

Sql Server create a trigger example

In this SQL Server tutorial, we will learn and understand how SQL Server TRIGGER works. Moreover, we will discuss and learn some examples so that you can understand the concept much better. Here is the complete list of topics that we will cover. SQL Server Trigger SQL Server Trigger Types SQL Server Triggers List SQL Server …

Read more

SQL Server First Day Of Month

Sql Server first day of the month example

In this SQL Server tutorial, we will learn about “SQL Server First Day Of Month” where we will discuss how to get the first day of the month from the table. We will understand and learn some examples so that you can understand the concept much better. Here is the complete list of topics that we …

Read more

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