Shivam Dogra

Shivam Dogra is a cloud database developer and Team Lead at TSInfo Technologies, where he has worked since June 2021. He writes the SQL Server and Oracle tutorials on DatabaseFAQs.com, covering queries, joins, stored procedures, triggers and permissions. Shivam holds a Master of Computer Applications (MCA) from Chandigarh University.

Oracle raw Datatype

by
Using raw datatype in sql developer tool

In this Oracle tutorial, we will learn about the raw datatype in the oracle database. Also, we will illustrate how to use it to create raw columns for a table in oracle. Introduction to Oracle raw Datatype The RAW datatype in Oracle 21c is a variable-length binary data type used to store binary data. It … Read more >>

Oracle nclob Datatype

by
use nclob datatype in sql

In this Oracle tutorial, we will learn about the nclob datatype in the oracle database. Also, we will demonstrate how to use it to create nclob columns for a table in oracle. Introduction to Oracle nclob Datatype The NCLOB data type is a variable-length data type that can store up to 4 GB of Unicode … Read more >>

Dec Datatype in Oracle Database

by
Created student table in oracle 21c

In this  Oracle tutorial, we will learn about the dec datatype in the oracle database. Also, we will demonstrate how to use it to create dec columns for a table in oracle. Introduction to Oracle Dec datatype The DEC data type in Oracle 21c is a fixed-point decimal data type that is used to store … Read more >>

Clob Datatype in Oracle Database

by
use clob datatype in sql developer tool

In this Oracle tutorial, we will learn about the Clob datatype in the oracle database. Also, we will illustrate how to use it to create Clob columns for a table in oracle. Introduction to Oracle Clob datatype The CLOB (Character Large Object) datatype in Oracle 21c is used to store character data that can be … Read more >>

Oracle Blob Datatype

by
blob datatype in oracle

In this Oracle tutorial, we will learn about the Blob datatype in the oracle database. Also, we will demonstrate how to use it to create Blob columns for a table in oracle. Introduction to Oracle Blob Datatype The BLOB (Binary Large Object) data type in Oracle 21c is used to store binary data such as images, audio, … Read more >>

Select last 10 records in SQL Server without sorting

by
Select last 10 records in SQL Server without sorting

In this SQL Server tutorial, we will learn how to fetch or select the last 10 records from a table in SQL Server without sorting. Before we see how to fetch the last 10 records in SQL Server without sorting. Here is the image of the EMPLOYEE_ACCESS table which is used in the SQL Server. … Read more >>

Oracle Timestamp Datatype

by
use the timestamp datatype in sql developer tool

In this Oracle tutorial, we will learn about the Timestamp datatype in the oracle database. Also, we will demonstrate how to use it to create Timestamp columns for a table in oracle. Introduction to Oracle Timestamp Datatype In Oracle 21c, the TIMESTAMP datatype is used to store date and time data in the database. The TIMESTAMP datatype … Read more >>

Date Datatype in Oracle Database

by
use date datatype in sql developer tool

In this Oracle tutorial, we will learn about the date datatype in the oracle database. Also, we will illustrate how to use it to create date columns for a table in oracle. Introduction to Oracle Date datatype Date and time values are stored in Oracle 21c using the DATE data type. Using this widely used data type, … Read more >>

Decimal Datatype in Oracle Database

by
decimal datatype in sql developer

In this Oracle tutorial, we will learn about the decimal datatype in the oracle database. Also, we will illustrate how to use it to create decimals columns for a table in oracle. Introduction to Oracle Decimal datatype A decimal data type with fixed precision and scale is called DECIMAL in Oracle 21c. It is used … Read more >>

Nchar Datatype in Oracle Database

by
nchar datatype use in sql developer tool

In this Oracle tutorial, we will learn about the Nchar datatype in the oracle database. Also, we will demonstrate how to use it to create Nchar columns for a table in oracle. Introduction to Oracle Nchar datatype A word string that can store Unicode information is known as an n-char and the nchar stands for … Read more >>