Interested to Buy Any Domain ? << Click Here >> for more details...
What is the use of cursor ? how cursor allocate context area for executing the sql statement?
- 4 Answers
- 16384 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / kamal
Cursor is a named private SQL area from where information
can be accessed. Cursors are required to process rows
individually for queries returning multiple rows.
Within the library cache, parsed SQL is stored as cursors.
The cursors are indexed by handlers referencing memory
locations within which parsed statements and information
relating to processing are stored. A context area is a
shared area of memory that stores the environment and
session variables for an instruction. Buffer caches store
active data and use a cache replacement scheme storing the
most recently used data.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Are sql database names case sensitive?
What is partition in sql query?
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
explain the difference between myisam static and myisam dynamic. : Sql dba
What is the difference between view and stored procedure?
What is full join?
What is the syntax to add a record to a table?
how to extract a unit value from a date and time? : Sql dba
How to find 3rd highest salary of an employee from the employee table in sql?
Does inner join return duplicate rows?
what is meant by urlencode and urldocode? : Sql dba
How many types of keys are there in sql?
What is a natural join sql?
how can you see all indexes defined for a table? : Sql dba
What is an emotional trigger?
