select firstname from sometable into cursorthe 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:
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