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 -> autoinc / counter Field in ORACLE

autoinc / counter Field in ORACLE

From: Peter Wilk <PeterWilk_at_compuserve.com>
Date: Sun, 2 Jan 2000 20:29:54 +0100
Message-ID: <84o8lm$9fu$1@ssauraaa-i-1.production.compuserve.com>


hello,
  I want to simulate an AUTOINC field in Oracle with a sequence number using the following code - however I always get a compile-error for the trigger. can anybody help me with that ?
thanks a lot - peter

DROP TABLE SALEADMIN.TEST CASCADE CONSTRAINTS; CREATE TABLE SALEADMIN.TEST
   (

   TESTID               NUMBER(8,0)       NOT NULL,
      CONSTRAINT PK_SUBNUMBERROAD PRIMARY KEY(TESTID),
   TEXT             VARCHAR2(25)      NOT NULL
   )
   TABLESPACE SALEDATA; DROP SEQUENCE SALEADMIN.SEQ_TEST;
CREATE SEQUENCE SALEADMIN.SEQ_TEST
       INCREMENT BY 1 START WITH 1
       MAXVALUE 99999999 MINVALUE 1
       CYCLE CACHE 20 ORDER;

CREATE OR REPLACE TRIGGER SALEADMIN.TRIG_TESTID    BEFORE INSERT ON SALEADMIN.TEST
   BEGIN
      SALEADMIN.TEST.TESTID = SALEADMIN.SEQ_TEST.NEXTVAL;    END; --
Peter Wilk
Assistance and Insurance Consulting
http://ourworld.compuserve.com/homepages/PeterWilk Received on Sun Jan 02 2000 - 13:29:54 CST

Original text of this message

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