What is the use of cursor ? how cursor allocate context area for executing the sql statement?
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 is schema in sql?
What is recursive stored procedure?
What is sorting in sql?
What are the features of pl sql?
Mention what plvcmt and plvrb does in pl/sql?
what is the difference between nested subquery and correlated subquery?
How many types of triggers exist in pl/sql?
What types of commands can be executed in sql*plus?
How many triggers can be applied to a table?
Difference between global and parameter variables?
what is rdbms? : Sql dba
What is right join sql?
What are different types of functions in sql?
what is bcp? When is it used?
What is bitemporal narrowing?