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?
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?
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 What is Difference between %type and %rowtype with examples?
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?
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 What is Oracle DATEDIFF function with examples?
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?
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 table
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?
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?
There is always a question in mind that how to connect to the oracle?I already given information about Oracle database management system in my previous…View More How to connect Oracle without tnsnames.ora