Is there a way to add an incremental count expression while using SELECT statement. For example, the statement below retrieves record into cursor:

select firstname from sometable into cursor

the data retrieved is;

john
susan
mary
etc..

Is there a way to write the SELECT statement where I can add a number for each record retrieved. For example:

the desired data I would like to retreive is the firstname column and incremental number column (I don't know how to add something in SELECT statement to create incremental numbers);

name column    incremental number column
john           1
susan          2
mary           3
etc..          etc..

is there anything I can add in the SELECT statment to get incremental number column. Thanks

Nick