What is the use of cursor ? how cursor allocate context area for executing the sql statement?
Answer Posted / ragaventhar
Cursor is used to fetch the data from a main table to temporary variable at run time and it is affected row by row .Mainly used to stored a data temporary and give the result set at the time of run time
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we make an if statement within a select statement?
Which is better stored procedure or query?
Does truncate release storage space?
What is output spooling in sql*plus?
What are the topics in pl sql?
How is sql used in oracle?
What is the use of desc in sql?
What is a parameter query?
What are different types of keys?
How much does sql cost?
What is a system versioned table?
How do you clear the screen in sql?
What is scope of pl sql developer in future?
What is data control language?
How many disk partitions should I have?