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
- 16442 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
What are schema-level triggers?
Why is nosql good?
What is the use of partition by in sql?
Does mysql support pl sql?
How do you optimize a query?
What is the non-clustered index in sql?
Can we use view in stored procedure?
What is sql in oracle?
What is mdb stand for?
What is mutating error in pl sql?
Explain the insert into statements in sql?
Why is sql*loader direct path so fast?
describe mysql connection using mysql binary. : Sql dba
Explain the components of sql?
What is record in pl sql?
