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

Are left and right joins the same?

539


what is the difference between nested subquery and correlated subquery?

556


What is mdf ldf and ndf?

565


Can we use update in sql function?

595


What is the difference between pl and sql?

549






What is the usage of nvl function?

603


Is like operator in sql case sensitive?

516


How to select random rows from a table?

529


What is the difference between an inner and outer join?

545


What is the difference between an inner join and an outer join?

518


what is the difference between blob and text? : Sql dba

533


what is the difference between undefined value and null value? : Sql dba

571


How does stored procedure reduce network traffic?

553


What are %type and %rowtype for?

623


How can triggers be used for the table auditing?

598