I'm working with Oracle 8i, and I'd like to create a table. The first column of this table a number type and is an ID. I don't want to give myself the number of this field, instead, I want the table auto create the number each time I create a new record in this table. (1, 2, 3, ...)
Which option should I use to create this type of column ?