what are the advantages of cursors than procedures?

Answer Posted / kumar srinivasalu

Cursors can be used to pass the parameters to procedures
and functions. The Single cursor used to multiple
updatation and used multiple queries at run time

Is This Answer Correct ?    16 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does sqlite need a server?

541


What are the operators used in select statements?

578


What is the cause of mutating table error and how can we solve it?

605


Does sql require a server?

532


Can we insert data into view?

527






What is where clause in sql?

537


What is sqlca in powerbuilder?

573


What plvcmt and plvrb does in pl/sql?

881


What is primary key and foreign key with example?

496


What are the types of variables use in pl sql?

514


what's the difference between a primary key and a unique key? : Sql dba

512


What is duration in sql profiler trace?

557


What is a recursive stored procedure?

621


how would you enter characters as hex numbers? : Sql dba

518


Is sql a microsoft product?

498