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
- 16602 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
how to enter characters as hex numbers? : Sql dba
What is difference between inner join and cross join?
Why should I use postgresql?
What are sql ddl commands?
What is pl sql code?
What is sqlca in powerbuilder?
What is sql clause?
How do you remove duplicate records from a table?
What is database migration?
What are the methods of filing?
Is sql a backend?
Show the cursor attributes of pl/sql.
how can you see all indexes defined for a table? : Sql dba
Does varchar need length?
Explain the difference between rename and alias?
