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
- 16591 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
List and explain the different types of join clauses supported in ansi-standard sql?
Can a table contain multiple primary key’s?
Explain what is rdbms?
What is the difference between clustered and non-clustered indexes?
What is the difference between inner join and outer join?
How to place comments in pl/sql?
What is graph sql?
What is data profiling in sql?
How do you update sql?
Can we create table in function?
What is the usage of the distinct keyword?
How to fetch alternate records from a table?
What is a primary key called that is made up of more than one field?
How do you explain an index number?
When are we going to use truncate and delete?
