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 can get second highest salary in sql?
Types of optimization?
discuss about myisam index statistics collection. : Sql dba
What are stuff and replace function?
What is difference between mysql and postgresql?
I WANT INFORMATION ABOUT SAS SOFTWARE USING FINANCIAL COMPANIES LIST, PLESE GIVE ME DETAILS ABOUT
what is the difference between rownum pseudo column and row_number() function? : Sql dba
Explain the rollback statement?
How do I write a cron which will run a sql query and mail the results to agroup?
write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000
What type of join is sql join?
what is a database? : Sql dba
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)