Shivam Dogra 
In this SQL Server tutorial, we will discuss how to drop a stored procedure in SQL Server. I will explain what are the various methods to drop stored procedures with the help of some examples. Prerequisite for this tutorial: What is a stored procedure in sql server How to drop stored procedure SQL Server? If you want … Read more >>
In this SQL Server tutorial, we will understand the difference between table and view in SQL Server. Moreover, we will also discuss the following topics in this tutorial. Is a view a table in SQL Server? A view in SQL Server is just like a virtual table created from a result set of a SQL query. A view … Read more >>
In this SQL Server tutorial, we will learn how to insert a row in a view in SQL Server. Additionally, we will also cover the following set of topics. Can we insert data into view in SQL Server In SQL Server, a VIEW is just like a virtual table that holds data from one or more than … Read more >>
In this Oracle tutorial, we will cover the use of Alter table add column in Oracle. Here we will learn how to perform alter table columns in the oracle database. Also, we will cover these topics. Note: All the dataset used in this tutorial is from Kaggle and we do not guarantee accuracy. The dataset is … Read more >>
While working on the SQL Query, I needed to call a function in view in SQL Server. I researched and found a simple method to do so. In this SQL Server tutorial, we will learn how to call a view in SQL Server using some examples. Additionally, we will also cover the following set of topics. How to … Read more >>
In this SQL Server tutorial, we will discuss the indexed views in SQL Server. I will explain what are indexed views, how to create them, and when to use them. What is an indexed view in SQL Server? An indexed view in SQL Server is a view on which a unique clustered index is created. We … Read more >>
In this Oracle tutorial, we will learn about how to create table in oracle database 19c. Also, we will cover these topics. Note: Ideally we should create a table on the Pluggable database (PDBs) But to keep things simple we have demonstrated it on a common user (c##). Oracle Create Table In this section, you … Read more >>
In this SQL Server tutorial, we will learn how to use union in view SQL Server. Moreover, we will also cover the following topics. Before we cover the use of union or union all in a SQL Server View, we should have a clear understanding of the UNION operator and a View in SQL Server. View in SQL … Read more >>
In this SQL Server tutorial, you will get to know about the various logical operators in SQL Server. I will explain how to use the logical operators with the help of some examples. Different logical operators return different outputs. Let us see what are the various logical operators and how to use them. List of … Read more >>
In this Oracle tutorial, we will learn about the number datatype in oracle database. Also, we will cover these topics apart from the oracle numeric data type. Number Datatype in Oracle Size In this section, we will learn about the size of Number data type in oracle database. Read How to create a database in … Read more >>