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
- 16271 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 is over () in sql?
What is the use of prepared statement?
What is the use of sql trace?
How to load data with sql*loader?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
Should I use mbr or gpt?
What is the difference between a query and a report?
What are commit, rollback, and savepoint?
What are expressions?
What is query optimization in sql?
What is view? Can we update view
What are the types of queries in sql?
How do you rename a table in sql?
describe transaction-safe table types in mysql : sql dba
What is the purpose of design view?
