In my previous article I have provided multiple complex sql queries for interviews and subqueries as well. In this article I would like to give…
View More correlated subqueries in SQL | How to write correlated subqueries in SQL?Category: SQL Tutorials
How to use execute immediate statements in oracle? | Dynamic SQL -1
In my previous article I have given the details about Oracle PL SQL in detail. In this article i would like to brief about the…
View More How to use execute immediate statements in oracle? | Dynamic SQL -1How to connect to oracle database using sql developer
In my previous article i have already given the difference between the Oracle anonymous block and subprogram with real life examples. In this article I…
View More How to connect to oracle database using sql developerHow 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?What is Difference between %type and %rowtype with examples?
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?How 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?What is Oracle DATEDIFF function with 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 What is Oracle DATEDIFF function with examples?How 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?