In my previous article I have given the examples of what is mean by hint in SQL and how those are used in tuning the…
View More What is NOCOPY hint with real examples? | NOCOPY hint examplesCategory: SQL Complex Queries
What are conversion functions in SQL? | OCA Preparation-7
In my previous articles i have given multiple examples of different functions in SQL. In this article i would like to focus on conversion functions…
View More What are conversion functions in SQL? | OCA Preparation-7How to write complex sql queries?
I have already given the multiple complex sql queries as well as complex sql queries for interview purpose. I have got so many questions and…
View More How to write complex sql queries?What are important Advanced SQL Exercises?
In my previous article i have already given multiple complex sql queries with answers. In this article i would like to give some most important…
View More What are important Advanced SQL Exercises?What are most common SQL Queries?
In this article I would like to give the best and quality content which is useful for all the database engineers and software engineers. The…
View More What are most common SQL Queries?How to create duplicate table in SQL? | Creating duplicate table
In previous article i have given the basic idea about how to create a table in SQL. In this article i would like to give…
View More How to create duplicate table in SQL? | Creating duplicate tableHow to remove oracle table lock?
In my previous articles i have given so many real life SQL scenarios in which are useful. In this article i would like to give…
View More How to remove oracle table lock?How to find out the table was last modified in Oracle?
In my previous article i have given idea about the how to find out backup of table? and questions like that. In this article i…
View More How to find out the table was last modified in Oracle?What is query to find First day and last day of month?
In my previous articles i have given multiple queries which will clearly gives us knowledge about SQL. I have given multiple solutions about query to…
View More What is query to find First day and last day of month?How to recover the expired user in Oracle?
In my previous articles i have given idea about the different questions related to oracle. In this article i would like to throw light on…
View More How to recover the expired user in Oracle?