How to create table in Oracle

create oracle table using sql developer tool - create table

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 >>

How to use union in view SQL Server

How to use union in view SQL Server

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 >>

SQL Server logical operators and example

AND operator in SQL Server if statement

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 >>

MongoDB return specific fields

MongoDB return specific fields with any value

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 >>

Number Datatype in Oracle

precision in oracle database

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 >>

SQL Server view order by

SQL Server View ORDER BY

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 >>

How to view table in SQL Server

How to view table in SQL Server

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 >>

How to Fetch Data from Oracle Database in Python

How to Fetch Data from Oracle Database in Python

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 >>

How to get id from mongodb after insert

How to get id from mongodb after inserting document

In this MongoDB tutorial, we are going to learn “How to get id from MongoDB after insert” with a few examples. We will cover this by executing different operations with examples. The following list topics we are going to cover in this tutorial: How to get id from mongodb after insert In this topic, you will … Read more >>

MongoDB date format – Complete Tutorial

MongoDB date format dd-mm-yyyy

In this MongoDB tutorial, we are going to learn “MongoDB date format” with examples. We will cover this by implementing different operations with examples. The following list topics we are going to cover in this tutorial: MongoDB date format query The date query in MongoDB displays the current date as a string in the mongo shell. The current … Read more >>

Top 200 SQL Server Interview Questions and Answers

Free PDF On Top 200 SQL Server Interview Questions And Answers

Download A 40 pages PDF And Learn Now.