Re: PL/SQL Cursor : any analogy in programming languages

Originally posted by Alex Vinokur

> Is it possible to get brief (conceptual) explanation for that who
> knows C++ :

> * what cursor is?

> * what is it used for?

> * how is it used?

>

> Does cursor have any analogy with programming language constructions?

>

> Thanks in thanks,

>

> =====================================

> Alex Vinokur

> mailto:alexvn_at_connect.tomailto:alexvn_at_connect.to

> http://mathforum.org/library/view/10978.html"]http://mathf-
> orum.org/library/view/10978.html[/url]

> =====================================

Analogy: a sequential file:

open = fopen()

fetch = fget()

close = fclose()

cursor%NOTFOUND = EOF

You open the cursor, start fetching records (in the order specified in the SELECT statement rather than "physical" order), and when you have finished you close the cursor.

--
Posted via http://dbforums.com