$in MongoDB Example

$in MongoDB

In this MongoDB tutorial, we will discuss the $in operator MongoDB. Additionally, we will also discuss the various examples where we will use the $in operator in MongoDB. $in MongoDB The $in operator in MongoDB is used to select the documents where the value of a field is equal to any value in the specified array. Syntax: … Read more >>

SocketException: Address already in use MongoDB

Steps to schedule a stored procedure using SSMS

In this MongoDB tutorial, I will explain how I managed to resolve the error “Failed to set up listener: socketexception: address already in use MongoDB”. Socketexception: address already in use MongoDB When I run the command mongod in my terminal I get the following error message: From the error, It is clear that the address or … Read more >>

Select the first element in an array in MongoDB

Select the first element in an array in MongoDB example

In this MongoDB tutorial, we are going to learn to “select the first element in an array in MongoDB” with a few examples. We will cover this by performing various operations with examples. The following list topics we are going to cover in this tutorial: How to select the first element in an array in MongoDB query … Read more >>

How to delete documents in MongoDB

How to delete the documents in MongoDB example

In this MongoDB tutorial, we are going to learn to “delete the documents in MongoDB” with a few examples. We will cover this by implementing various operations with examples. The following list topics we are going to cover in this tutorial: How to delete the documents in MongoDB query The MongoDB shell provides the following method to delete … Read more >>

SQL Operand data type real is invalid for modulo operator

Operand data type real is invalid for modulo operator

In this SQL Server article, I will share my experience with the error “SQL Operand data type real is invalid for modulo operator“. We will see, how to fix the error, sql operand data type float is invalid for modulo operator. The modulus operator behaves differently with different data types. Recently, I was trying to … Read more >>

How to Get List all Tables in Oracle Database

Get list of all tables in Oracle

In this Oracle tutorial, we will learn how to write a query to list all tables in oracle database. Also, we will cover these topics. Query to List all Tables in Oracle Database In this section, we will learn how to write a query to list all tables in oracle database. This is how to … Read more >>

Oracle 19c installation on Windows 10 + Video Tutorial

Oracle 19c installation on windows 10

In this Oracle tutorial, we will see a complete step-by-step on Oracle 19c installation on Windows 10. Also, we will see, how to install oracle database 21c on windows 10. Also, we will cover these topics. Brief History of Oracle database & its versions Oracle database is a powerful and safe relational database software created … Read more >>

How to Check Oracle Database Version

How to Check Oracle Database Version in SQL Developer

In this Oracle tutorial, we will learn how to check oracle database version. Also, we will cover these topics. How to Check Oracle Database Version in Linux In this section, we will learn how to check the oracle database version in Linux using the command line or Terminal. Using the below command on a terminal … Read more >>

View in SQL Server

How to create a view using a script in SQL Server

In this SQL Server tutorial, we are going to learn about a view in SQL Server. And we also cover various methods to create a SQL Server View. Here is the complete list of topics that we will discuss. What is a view in SQL Server In SQL Server, a VIEW is just like a virtual table … Read more >>

Comparison Operators in SQL Server

Comparison Operators in SQL Server

In this SQL Server tutorial, I will explain the various comparison operators supported by SQL Server including the non-ISO standard operators. I will explain various operators along with their usage and examples. SQL Server Comparison operators check if any two expressions are the same or not and return a boolean value. In SQL Server there … Read more >>