What is the use of cursor ? how cursor allocate context area for executing the sql statement?
- 4 Answers
- 15288 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 a pragma statement?
What does over partition by mean in sql?
Can we use having without group by in sql?
How do you truncate?
What is sql rowcount?
What are the parameter modes supported by pl/sql?
What are basic techniques of indexing?
What are analytic functions in sql?
What will you get by the cursor attribute sql%rowcount?
What is the max nvarchar size?
how to present a past time in hours, minutes and seconds? : Sql dba
What is the difference between delete and truncate commands?
Can you call pl/sql package functions from within a fast formula?
What is fmtonly in sql?
Is there a way to automate sql execution from the command-line, batch job or shell script?
