Re: cursor

oracle schreef:
> Hi,
>
> vat is cursor? vat is exact use of cursor?
>
> bye
> prasad
>
All right, all right - we go it the first time!

A cursor is some pointer to a memory location.

You define a cursor for a select statement, you open the cursor, and fetch the first row of data returned by the select statement.
You process that, and fetch the next row of data, or close the cursor - depending on your needs.

Back to the pointer business:
- open cursor: prepare statement,
  set pointer to top of the result stack. - fetch: fetch a (number of) record(s), return   the one pointed at, modify pointer to point to   the next record.

I am not sure what you mean by exact use of cursor; the general idea is to avoid explicit cursors.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...