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 ceil and floor in oracle?

579


How would you change old and new values in an insert, delete and update triggers?

545


What is program global area (pga) in oracle?

609


What are privileges and grants?

572


How to store only time; not date and time?

557






what is difference between sql plus and sql*plus? (not sql and sql plus).

3348


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

1441


How to convert csv to table in oracle?

528


How does the on-delete-cascade statement work?

608


How to use existing values in update statements using oracle?

545


Explain cascading triggers.

574


Explain drop constraint oracle?

593


Can we save images in a database and if yes, how?

594


How to define an anonymous block?

618


In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1366