Difference between sub query and nested query ?
Answer Posted / dinesh sahoo
The query inside a query is known as a subquery.
When we have another query again query inside subquery then
it is known as nested subquery, which resinde in the WHERE
clause.
| Is This Answer Correct ? | 12 Yes | 9 No |
Post New Answer View All Answers
Why is oracle database so popular?
What is dynamic proxy?
What is a system tablespace?
What is the difference between $oracle_base and $oracle_home?
How to convert raw data type into text in oracle? Explain
How to divide query output into groups in oracle?
What is difference between cartesian join and cross join?
How to connect to oracle using service name instead of sid?
Explain temporal data types in oracle
What language does oracle use?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How to resolve the ORA-39133 error in Oracle?
How to run create database statement again?
How to define a variable of a specific record type?
How can Oracle users be audited?