what is the difference between the query and corelated
query

Answer Posted / guruswamy

corelated query is refered by each an every value by
subquery.
normal query is referd by subquery one bulk amount to get a
main query

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does cursor do in sql?

711


How to create a menu in sqlplus or pl/sql?

807


What version is sql?

728


What are different types of indexes?

702


Can a varchar be a primary key?

694






Explain what is sql*plus?

854


How to order siblings in oracle hierarchy queries?

768


Is sqlite thread safe?

787


How is sql used in oracle?

755


what is the difference between sql and t-sql? : Transact sql

804


Where do we use pl sql?

716


Is left join faster than join?

760


Can 2 queries be executed simultaneously in a distributed database system?

855


What is %type in pl sql?

703


What is the purpose of a secondary key?

679