Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> forcing the developers to use sequences
In Oracle 9i2, is there a way to attach a sequence to a field so that people
have to use the sequence during insertion operations?
Say,
create table test (id number(38), name varchar2(20); create sequence id_seq no cycle nomaxvalue;
Is there a way to force the developers to use the sequence when inserting a new record?
insert into test (id, name) values (id_seq.nextval, 'xyz'); Received on Fri Dec 12 2003 - 09:53:58 CST