State the difference between implict and explict cursor's?

Answer Posted / bhavesh shah

Implicit cursor:- It always return one row, and no loop is
used in.
Explicit cursor:- It returns more than one row and here loop
is used.

Is This Answer Correct ?    5 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is native sql query?

546


Mention what is the use of function "module procedure" in pl/sql?

561


What are the events on which a database trigger can be based?

590


Is full outer join same as cross join?

501


What is coalesce in sql?

557






what is self-join? : Sql dba

565


What does pl sql developer do?

504


What is parameter substitution in sql?

523


What is the use of index in sql?

553


Is subquery faster than join?

568


What is the difference between joins?

532


Explain aggregate functions are available there in sql?

532


Can you inner join the same table?

525


what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

669


What is a stored procedure in sql with example?

598