Hi Mark,

Thanks for your comments. I'm going to use rownum in a stored procedure to return 20 records at a time for use in a paged html display.

Paul


>
>Since you found the answer to your own question, I will just make a comment. I highly recommend against using this as PK or FK or anything meaningful. Oracle calls this a pseudo-column which means a false column. There are no guarantees that this row number will always be the same throughout the lifetime of the databse. For example, if you backup the database using the Oracle EXP [export] utility, then use IMP [import] to restore the DB, these IDs could change.