Interested to Buy Any Domain ? << Click Here >> for more details...
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 are the types of functions in sql?
Is not equal in sql?
What is sql resultset?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is the difference between in and between in sql?
how mysql optimizes distinct? : Sql dba
What is t sql used for?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What is the process of debugging?
How to pronounce postgresql?
What are pl sql data types?
What are the advantages of sql?
How do I debug a stored procedure?
What are different functions in sql?
Can sql developer connect to db2?
