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 |
Can you have multiple SPs with the same name on a database?
What schema means?
What are the sql aggregate functions?
When is the update_statistics command used?
What is auto increment?
What is a composite primary key?
what is the difference between sql and t-sql? : Transact sql
Which command is used to delete a trigger?
What are the indexing methods?
Can I create table without primary key?
What is meant by temporal data?
how do you count the duplicate records in a table