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
- 20459 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 are joins in sql and what are the different types of joins?
Is foreign key unique?
How to find out the list schema name and table name for the database?
What is the sql case statement used for? Explain with an example?
System requirements for sql server 2005 express edition?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
How to test odbc dsn connection settings?
What is difference between sql and sql server?
What is single-user mode?
How to loop through result set objects using odbc_fetch_row()?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
How do I find my localdb version?
What do you mean by normalisation?
How to optimize stored procedure optimization?
