Shivam Dogra 
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 Oracle tutorial, we will learn how to use the datatype in oracle database 21c. Moreover, we will take a look at multiple tables where the Oracle data types, including character, NUMBER, DATE, binary (LOB, RAW, and LONG RAW), ROWID and UNROWID, and XML data types, will be briefly discussed. Oracle Database Datatypes are utilized … Read more >>
As part of this SQL Server tutorial, we will learn and understand how to use the SQL Server SELECT TOP 1 statement with the INNER JOIN clause. This will enable us to retrieve data from a table. Recently, I got an update from the client while working on the Country’s Geography project. The SQL Server … Read more >>
Three stores times four months gave me exactly 12 rows. A SQL Server CROSS JOIN pairs every row of one table with every row of the other: a x b rows, no ON clause. SELECT s.Store, m.MonthStart FROM dbo.Stores s CROSS JOIN dbo.Months m; I used it to find each store’s zero-sales months. Here’s what … Read more >>
In this SQL Server tutorial, we will learn and understand how to use the SQL Server INNER JOIN clause on multiple tables. We have already discussed how to use the SQL Server Inner Join on 2 tables in SQL Server. However, there are many cases when we need to apply Inner join on more than … Read more >>
In this SQL Server tutorial, we will learn and understand how to use the SQL Server LEFT OUTER JOIN with the WHERE clause on tables by the query. Recently, I got a requirement to join multiple tables and even filter records based on the condition for the resultset in the SQL Server. So, I came … Read more >>