Autoincrement in Oracle

Hi,

I am new to oracle and this is probably a faq question so if it is could somebody just post a link to the faq. Otherwise: Is there a way in Oracle8i to have a column which autoincrements whenever you add a new row. (Does it reindex when you remove something?)
I just can't imagine that you have to check for the max(id) and increment that before adding a new row :-)

Thanks for any help

Florian Received on Mon Jun 12 2000 - 00:00:00 CDT