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

What is the plv (pl/vision) package offers?

795


Which are the different case manipulation functions in sql?

734


Define commit?

747


What are all different types of collation sensitivity?

737


How do I upgrade sql?

737






How many databases can sql express handle?

729


What is sql comments?

813


How many rows can sqlite handle?

782


What is parameter substitution in sql?

755


What are the types of variables use in pl sql?

689


How do I clear the screen in sql plus?

756


what is transaction? : Sql dba

719


What operating systems are supported by oracle sql developer?

714


The select into statement is most often used to create backup copies of tables or for archiving records?

770


Does truncate remove indexes?

721