what is the cursor and use of cursor in pl/sql ?
Answers were Sorted based on User's Feedback
Answer / prince pradeep
cursor is a handle or a pointer to a context area;
(context area is a memory area where sql statements are processed)
cursors are used to retrieve multiple records from data base
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / udaykumar
cursor is a private workspace memory,it does'nt stored in
the database.It is a buffer.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kesav
A cursor is a temporary work area created in the system memory when a SQL statement is executed. A cursor contains information on a select statement and the rows of data accessed by it.
Is This Answer Correct ? | 0 Yes | 0 No |
Which are sql * plus commands?
Can we join tables without foreign key?
What does select top 1 do in sql?
What is the difference between explicit and implicit cursors in oracle?
What is dynamic SQl and how you will create and execute dynamic sql?
What do you mean by rowid?
Is left join inner or outer?
When should I use nosql database?
What is not equal in sql?
Will truncate release space?
What are the types of sql commands?
Which is the best place to learn hadoop?