Re: unique column values

From: Ian Douglas <idouglas_at_NLIS.ORG.UK> >> I am an Oracle newbie. Could someone please tell me how to create a column with in an Oracle Table that has an automatically unique sequential number <<

Look up sequences, i.e. create sequence sequence_name. There are a range of options such as starting value, maximum value, how many to cache in memory, and whether to cycle back to the start when all the numbers have been used.

There are used in an insert statement like this: insert into table_name columns (key, column1, etc...) values (sequence_name.nextval,column1_value,etc...);

Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Tue Sep 23 1997 - 00:00:00 CEST