Difference between sub query and nested query ?

Answer Posted / sravzzz

Sunbquery is a query within a query where as Nested query
is a subquery which resinde in the WHERE clause.

Is This Answer Correct ?    12 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to rollback the current transaction in oracle?

756


What is the data pump export utility?

832


What is a data dictionary and how can it be created?

801


How will you differentiate between varchar & varchar2?

781


What is a partition in oracle?

762






Why do you create or replace procedures rather that drop and recreate.

733


What is the usage of synonyms?

800


How to create a temporary table in oracle?

917


Can we create trigger on materialized view in oracle?

745


How to define an anonymous procedure with variables?

731


What is user managed backup in Oracle?

814


Describe the types of sub query?

730


How to start instance with a minimal initialization parameter file?

758


What happens to the current transaction if a ddl statement is executed?

761


How to connect to the server with user account: sys?

757