Bijay 
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 >>
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 >>
In this SQL Server tutorial, we will understand how to get the latest record for each user from a table in a SQL Server. There are 2 ways to fetch the latest record for each user in SQL Server. And in this tutorial, we will discuss both methods: Here is a sample table: EMPLOYEE_ACCESS which … Read more >>
In this Oracle tutorial, we will learn about the Varchar2 datatype in the oracle database. Also, we will demonstrate how to use it to create varchar2 columns for a table. Introduction to Oracle Varchar2 Datatype The character values are stored using the VarChar2 data type. Because it is a variable-length data type, we can alter … Read more >>
In this oracle tutorial, we will learn how to delete duplicate rows in oracle database 21c. Moreover, we will take multiple examples where we need to delete duplicate rows in the oracle database. A table holds duplicate rows when the two or more rows in the tables are identical and the values of the bother … Read more >>
In this Oracle tutorial, we will learn how to use the Char datatype in oracle database 21c. Moreover, we will take a look at multiple examples and we will check with the use of char datatype. Introduction to Oracle Char datatype The character values are stored using the char data type. It is a fixed-length data … Read more >>
In this Oracle tutorial, we will learn about the float datatype in the oracle database. Also, we will demonstrate how to use it to create float columns for a table. Introduction to Oracle FLOAT datatype Floating-point numbers of the FLOAT datatype have a binary precision of b. This datatype’s default precision is 126 binary or 38 decimals. … Read more >>
In this SQL Server tutorial, we will learn and understand how to use the SQL Server LEFT OUTER JOIN on multiple tables by query. In one of our previous tutorials on SQL Server Outer Join, we have seen how to use the Outer join on 2 tables in SQL Server. However, there could be a … Read more >>
In this SQL Server tutorial, we will learn the use of SQL Server RIGHT OUTER JOIN on multiple tables by the query. In SQL Server, different types of JOINS can be used on tables. And there isn’t a difference between the SQL Server RIGHT JOIN and RIGHT OUTER JOIN. Both clauses have the same method … Read more >>
In this SQL Server tutorial, we will learn and understand how to use the SQL Server EQUI JOIN on tables by query. The SQL Server EQUI JOIN is quite different from other types of SQL Server JOINS. In EQUI JOIN, we have used the WHERE condition for joining both tables. Thus EQUI JOINS in SQL … Read more >>
Download A 40 pages PDF And Learn Now.