39.0k views
4 votes
Describe the concept of a cursor and how it is used in embedded SQL.

User TheNavigat
by
5.6k points

1 Answer

3 votes

Answer:

Cursor is the temporary area created when the SQL statement is executed.

Step-by-step explanation:

Data base management system allows

 Entering Data

 Housekeeping

 Querying data

 Printing reports

Cursor contains the information about the selected statement and the rows data accessed by it. This space is used to store the data retrieve from data base

A cursor is used to get rows from the query that has many rows in its result sets a cursor is work as a handle and identifier in SQL query. it is very necessary in SQL because it is an object which is used to store the output of query.

A cursor is used to retrieve rows from a query that has multiple rows in its result set. A cursor is a handle or an identifier for the SQL query and a position within the result set.

User Swim
by
5.4k points