Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> forcing the developers to use sequences

forcing the developers to use sequences

From: Gordon T. Wu <wutao19_at_yahoo.com>
Date: Fri, 12 Dec 2003 10:53:58 -0500
Message-ID: <qwlCb.402$Er.31529@mencken.net.nih.gov>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US