1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what are the advantages of cursors than procedures?

Question Posted / swapna

Answers were Sorted based on User's Feedback



what are the advantages of cursors than procedures?..

Answer / 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

what are the advantages of cursors than procedures?..

Answer / somashekhar m

By using cursors It is possible to fetch row by row, when
user might want to work with rows one at a time. But not
possible with SQL standard statements it is not possible to
go row by row fetching.
A cursor can be defined as is a set of rows together with a
pointer that identifies a current row.

in ACID cursor works for consistency of the data.

Is This Answer Correct ?    12 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

What is diff between bulk collect and forall

3 Answers   Metric Stream,

How to create your own reports in sql developer?

0 Answers  

Why is there a need for sqlcode and sqlerrm variables?

0 Answers  

What are the advantages of normalization?

0 Answers  

what is a unique key ? : Sql dba

0 Answers  




Does a join table need a primary key?

0 Answers  

How many tables can you join in sql?

0 Answers  

What is assignment operator in pl sql?

0 Answers  

What are conditional predicates?

0 Answers  

What is delimiter in pl sql?

0 Answers  

If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?

9 Answers   JPMorgan Chase,

How many unique keys can a table have?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories