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?Category: SQL Tutorials
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?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?