Interested to Buy Any Domain ? << Click Here >> for more details...
What are cursors? Name four types of cursors and when each
one would be applied?
- 3 Answers
- 20298 Views
- Adea Solutions, I also Faced
- E-Mail Answers
Answer Posted / khushboo rastogi
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. This temporary work area is used to store the data retrieved from the
database, and manipulate this data. A cursor can hold more than one row, but can process
only one row at a time. The set of rows the cursor holds is called the active set.
There are two types of cursors in PL/SQL:
Implicit cursors:
These are created by default when DML statements like, INSERT, UPDATE, and
DELETE statements are executed. They are also created when a SELECT statement that
returns just one row is executed.
Explicit cursors:
They must be created when you are executing a SELECT statement that returns more
than one row. Even though the cursor stores multiple records, only one record can be
processed at a time, which is called as current row. When you fetch a row the current row
position moves to next row.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is join query?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
Where is trigger in sql server?
How to encrypt data between dialogs?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
Mention the command used to rename the database.
What are binary string data types in ms sql server?
Explain the dbcc pintable command when would you use it?
Why use update_statistics command in sql server?
Why use stored procedures in sql server?
What are the differences between user defined functions and stored procedures?
Why we use trigger in sql server with example?
What is 2nf example?
If we delete pack Spec what will be the status of pack Body ?
What is the difference between join and inner join?
