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 does count (*) do in sql?
Can a procedure in a package be overloaded?
What does where 1 1 mean in sql?
Can we commit inside a trigger?
What is the largest value that can be stored in a byte data field?
What is cursor in pl sql with examples?
How many disk partitions should I have?
What is db journal file?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
What is identity column in sql server?
How to run pl/sql statements in sql*plus?
What are crud methods?
What are the parameter modes supported by pl/sql?
Which is better trigger or stored procedure?
Does oracle roll back the transaction on an error?
