Difference between sub query and nested query ?

Answer Posted / reddy

Hi Friends,

Query inside a query is called as Sub query. Sub query is
also called as Nested Query.

Thanks
REDDY

Is This Answer Correct ?    22 Yes 41 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the usage of analyze command in oracle?

834


WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

1927


I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2061


What is system global area (sga) in oracle?

771


Explain constraining triggers.

832


What is a Garbage Collection? and what is full recursive Garbage collection?

2586


What would you do with an in-doubt distributed transaction?

1701


Explain do view contain data?

772


How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1646


How to create a new table in oracle?

785


Is primary key indexed by default in oracle?

740


various types of hints and their usage

2367


how to clone 9i Database on to 10g Database.

2069


How data locks are respected in oracle?

800


How to load excel data sheet to oracle database

758