Category: SQL Tutorials

In my previous articles I have given multiple examples of regular expressions in detail. In this article I would like to give you explanation about…

View More How to Split comma separated string in to rows?

In my previous articles I have clearly given you idea about different systems tables in oracle with its use.In this article I would like to…

View More Oracle Database Name | How to Find oracle database name

In my previous article I have given you the idea about the Pivot statement in SQL with multiple real life examples.In this article I would…

View More SQL Pivot Multiple Columns | Multiple column Pivot Example

In my previous articles i have given information about the different datatypes in SQLIn this article I will try to give you difference between char…

View More Difference Between Char and varchar | Examples of Char and Varchar

In my previous articles i have provided information about different types of SQL Queries with multiple examples.In this article I would like to give you…

View More How to Write SQL Queries with Simple Steps

In my previous article i have given the basic idea about the scalar subqueries as well as correlated subqueries.In this article i would like to…

View More SQL Nested Queries | SQL Nested Queries Examples

In my previous article i have given the information about First Normal Form with real life examples.In this article i would like to give you…

View More Second Normal Form | 2NF with Examples | 2nd Normal Form

In my previous article i have explained the normalization with examples.In this article i would like to explain First Normal Form of data. We need…

View More First Normal Form | Normalization 1NF with real life examples

In my previous articles i have given idea about normalization techniques as well as its examples. In this article i would like to give you…

View More SQL Normalization| SQL Normalization with Examples