RajKishore 
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 MongoDB tutorial, we are going to learn about MongoDB return specific fields with a few examples. We will cover this by executing various operations with examples. The following index topics we are going to cover in this tutorial: MongoDB query return specific fields MongoDB provides the find() method that is used to select documents in … 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 >>
In this SQL Server tutorial, we will discuss the use of SQL Server View Order By. Here we will illustrate the use of the ORDER BY clause in a SQL Server View. Moreover, we will cover the following topics. SQL Server View ORDER BY In SQL Server, a VIEW is just like a virtual table that holds data … Read more >>
In this SQL Server tutorial, we will understand how to view table in SQL Server. Additionally, we will cover the following set of topics. How to view table in SQL Server In SQL Server, we can easily view a table using a SELECT statement. And the main usage of the SELECT statement is to fetch data from database … Read more >>
In this tutorial, we will learn how to fetch data from the oracle database in python. Also, we will cover these topics. Pre Requisites – Database details In this tutorial, we are going to use a table gift_store that has 6 columns with different data types. Here is the data that we inserted in the … Read more >>