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

How can we solve sql error: ora-00904: invalid identifier?

699


How do you modify a table in sql?

565


Is inner join faster than left join?

636


What is a primary key? Explain

542


What does sql stand for?

546






How is a process of pl/sql compiled?

600


How can we debug in PL/SQL?

661


what is rdbms? : Sql dba

581


Does truncate remove indexes?

563


Is delete faster than truncate?

547


what is the difference between union and union all? : Sql dba

548


How do I view a sql database?

558


What are the types of join in sql?

520


What are data types in pl sql?

564


How do you rename a table in sql?

534