Sequences and Views

I'm trying to label rows when creating a view with the numbers 1...n,
where n is the number of items in a view.  Since views are requeryed
when used in a select statement, using sequences breaks the 1 to n
numbering.

Under oracle the label was produced by the 'rownum' attribute.

Suggestions?
-JP