Answer Posted / nageswara rao
cursor acts as datatype for holding composite
variable.composite variable hold more than one value at a
time.
when ever u declare a cursor it tells to sqlserver that
memory is create for that cursor
whenever u open the cursor it executes select statement in
declare section and reserves memory stored the result of
execution in this memory.and reserves pointer to the before
first
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is #table in sql?
Explain the order of sql statement execution?
What is difference between pls_integer and integer?
What are the properties of a transaction?
Explain the advantages and disadvantages of stored procedure?
how would you get the current date in mysql? : Sql dba
Is it possible to link two groups inside a cross products after the cross products group has been created?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
Why select is used in sql?
What is a schema? How is it useful in sql servers?
How do I view a view in sql?
Can one improve the performance of sql*loader? : aql loader
What is the usage of the distinct keyword?
Why we use triggers in mysql?
What is sql and explain its components?