Category: SQL Tutorials
How to connect to Oracle database using Sys user?
How to connect to Oracle database using Sys user? In my previous article I have given multiple SQL queries. In this article I would like…
View More How to connect to Oracle database using Sys user?How to take backup of Oracle database Schema?
In my previous articles i have given the basic idea about multiple oracle interview questions and advanced interview questions. In this article i would like…
View More How to take backup of Oracle database Schema?Is SQL a Programming Language?
In my previous articles i have given so many complex sql queries for reference. I have seen that the common question is in mind of…
View More Is SQL a Programming Language?Difference between %type and %rowtype
I have written so many articles on SQL difference between subject. I would like to focus on Difference between %TYPE and %ROWTYPE in this article.…
View More Difference between %type and %rowtypeHow to check database uptime?
In my previous articles i have given many answers about how to related to oracle and sql server as well. In this article i would…
View More How to check database uptime?Oracle DATEDIFF function examples
In my previous article I have provided the different date functions and its real life industry examples. In this article i would like to give…
View More Oracle DATEDIFF function examplesHow to set oracle_home path?
In my previous article i have given the detailed description of multiple queries related to oracle. In this article i would like to throw light…
View More How to set oracle_home path?How to create duplicate table in SQL?
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?How 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?