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 What is 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 What are 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 What is Second Normal Form with examples | 2NF with Examples

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 What isFirst Normal Form | Normalization 1NF with 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 What is SQL Normalization?| SQL Normalization examples