diff b/w sub query and co-relater query?

Answer Posted / guru

Sub query means A query within another query. the Sub query
executed first and returns result, which is used by Main Query.

Correlated Sub query:

The sub query has a Reference with a value or values of Main
Query, Which is Called as COrrelated Sub Query.

Thanks

Guru

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is memory optimized table?

759


What is the reports view in oracle sql developer?

718


What are stored procedures in mysql?

755


What are %type and %rowtype for?

806


Is left join inner or outer by default?

759






What is sql clause?

735


What is trigger point?

730


How many sql are there?

727


What are the advantages of pl sql over sql?

727


What is the size of partition table?

734


What is sap sql?

712


What will you get by the cursor attribute sql%notfound?

775


What is %type in pl sql?

700


Why use triggers in sql?

699


How you can copy a file to file content and file to pl/sql table in advance pl/sql?

808