CURSORS

Posted Date: 11 May 2008 Resource Type: Articles/Knowledge Sharing Category: Computer & Technology

Posted By: Nikky Member Level: Gold
Rating:

Points: 2

Cursor is a memory area that an Oracle engine uses for its internal processing for executing and storing the results of SQL statement, and this work area is reserved for SQL’s operations also called Oracle’s Private area or CURSOR.

The set of rows returned by a SQL query is called the result set. This result set is called Active Data Set. The size of cursor is the same as the size required by the number of rows in Active Data Set. This size is constrained by the size of memory. The data fetched from the table is first placed in the cursor opened in the memory on Oracle Engine or Oracle server. Then this set of data values is transferred to the client machine through network.

EXAMPLE: -
SQL> SELECT client_no,order_no,sale_amount,name
FROM sales_order
WHERE name='samrim'

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: PL/SQL
	Previous Resource: TYPES OF CURSORS IN PL/SQL
	Return to Discussion Resource Index
	Post New Resource
	Category: Computer & Technology

Post resources and earn money!

Related Resources

Fresher Jobs

Resources

Colleges

CURSORS

Responses

Post Feedback