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 many categories of data types?

582


How many types of auditing in Oracle?

573


How can I combine multiple rows into a comma-delimited list in oracle?

589


How would you begin to troubleshoot an ORA-3113 error?

1612


What is the difference between a user and a schema in oracle?

575






How to drop a stored procedure in oracle?

597


Explain what are the type of synonyms?

592


What is a sub query and what are the different types of subqueries?

634


What are the different editions of oracle?

603


What is oracle and what are its different editions?

587


How to convert a string to a date in oracle database?

556


Which environment variables are absolutely critical in order to run the OUI?

1668


Will you be able to store pictures in the database?

650


Why do we use bulk collect in oracle?

581


Write a trigger example in oracle?

584