Database Concepts (7th Edition)
Database Concepts (7th Edition)
7th Edition
ISBN: 9780133544626
Author: David M. Kroenke, David J. Auer
Publisher: PEARSON
bartleby

Concept explainers

Question
Book Icon
Chapter 6, Problem 6.34RQ
Program Plan Intro

Cursor:

The term cursor is used to retrieve the information in row by row manner. If the records stored in the database table, which needs to be updated one row at a time is carried over by cursor.

  • It plays the major role for fetching a required row from the table in the database which holds numerous records.
  • Cursors are defined using SELECT statement.
  • It points the set of rows which is resulted from an SQL SELECT statement.
  • In general the cursor is placed in the first or last row.
  • It influences the performance of the SQL Server as it uses the SQL server instances memory, decrease network bandwidth, and reduction in concurrency.
  • It’s recommended to avoid the use of cursor and the cursor can be replaced with WHILE loop, temporary tables, and sub queries.
  • The types of cursor are listed below:
    • Forward-only cursor
    • Static cursor
    • Dynamic cursor
    • Keyset cursor

Blurred answer
Students have asked these similar questions
Explain keyset cursors. Give an example of their use.
Explain What do you mean by Lookup table?  in detail text typed answer only
Explain the process for limited access in detail.
Knowledge Booster
Background pattern image
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage