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
- 16198 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 trigger and stored procedure in sql?
Explain table and field in sql?
Name three sql operations that perform a sort.
How to fix oracle error ora-00942: table or view does not exist
How do I run sql?
Can a table contain multiple foreign key’s?
Which is better stored procedure or query?
Why functions are used in sql?
Does varchar need length?
Is pl sql different from sql?
What are the key differences between SQL and PL SQL?
How do I save the results of sql query in a file?
What are the advantages of sql?
What is pl/sql language case sensitive?
Which is faster union or join?
