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 Difference between %type and %rowtype
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 Oracle DATEDIFF function 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?
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
In my previous articles i have given the detailed level idea about the multiple types of errors in oracle.I would like to give you detailed…View More How to check Oracle client is 32 bit or 64 bit?