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 |
How do you update f as m and m as f from the below table testtable?
Can we use having without group by in sql?
how to get the third quarter of employee details from emp?
What are aggregate and scalar functions?
How to create your own reports in sql developer?
How to write html code in pl sql?
What is a natural join?
What are the different types of database management systems?
how to get @@error and @@rowcount at the same time? : Sql dba
Explain cursor types?
Give an example of Full Outer Join?
What is package in pl sql with an examples?