Adv:cursor is a private sql area in which row by row operatioms and valida

Advantages and Disadvantages of Cursor?

Question Posted / ruchita

Answer Posted / ruchita

Adv:cursor is a private sql area in which
row by row operatioms and validations can be done
disadv:resource reqired are more

Is This Answer Correct ?

9 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are views used for?

1059

How to set the current database in ms sql server?

1141

Difference between aggregate functions of sql?

1148

What is the difference between row_number and dense_rank?

936

You want to implement the one-to-one relationship while designing tables. How would you do it?

1014

What is the distinction amongst delete and truncate?

1111

Tell me what are the advantages of using stored procedures?

1062

How to execute stored procedure and set temp table in sql server?

1094

How to assign null values to variables or columns?

1028

Can a database be shrunk to 0 bytes, if not, why?

1164

What is instead of dml trigger?

1058

What are the requirements to use odbc connections in php scripts?

1157

What is an index in sql?

1069

whats the maximum size of view state??

2248

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1182