That would work, but depending on what they want, you may need to
reset it every go. It is not a threadsafe (because generators are not
isolated to your transaction), so your numbers aren't guaranteed to
be sequential, though they will be unique unless someone resets the
generator.

I would suggest implementing the row number in the client
application, or if it really needs to be on the db server, then use a
stored procedure to create it.

Adam

> A roundabout way:
>
> select gen_id(ROWNUM_COUNTER, 1) as ORDER, TITLE FROM BOOK ORDER BY

1"

>
> eMeL