Difference between sub query and nested query ?

Answer Posted / mohammed al-fahed

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 ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a server parameter file in oracle?

771


How do I learn what codesets are available in oracle?

755


What privilege is needed for a user to connect to oracle server?

743


In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

3904


What is oracle host variable?

697






What is key preserved table?

726


How can you merge two tables in oracle?

728


List out the components of logical database structure of oracle database.

780


What are the uses of linked server and explain it in detail?

791


What are the numeric comparison operations?

830


How to sort output in descending order in oracle?

812


What do you understand by database schema and what does it hold?

904


How to define a variable to match a table column data type?

745


Explain integrity constraint?

851


How do I spool in oracle?

713