Re: how to emulate "cursors"

[Vivek Khera]

>>>>> "OA" == Orlando Andico <orly@stripped> writes:

>> I have an application where I need to select certain random values
>> from a select set.  The obvious way to do it is via cursors.  That is, 

OA> Maybe you could add an auto increment field (call it rownum) and select *
OA> from table where rownum = myrandomnumber.

The rows already have sequential row numbers assigned.  The problem is 
that the set from which I need to choose has a complicated "WHERE"
clause on it, which makes the row numbers less useful.  However, if it 
were for the entire table, this would be the way to go.