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 an inconsistent dependency?

761


Which software is used for pl sql programming?

677


Is sql a backend?

772


How to install oracle sql developer?

770


What is input buffer in sql*plus?

825






Can I create table without primary key?

733


What is bulk compiling in pl/sql.?

798


Differentiate between pl/sql and sql?

805


Where the sql database files are stored?

692


Does mysql_real_escape_string prevent sql injection?

691


Which is faster subquery or join?

850


What is the mutating table and constraining table?

738


What is difference between pls_integer and integer?

708


What is db journal file?

677


what is cross join? : Sql dba

742