Oracle About Sequence&trigger On Table

数据维护表主键序列号 用Oracle sequence 序列自增时

• 1、创建表
• 2、创建序列
• 3、创建触发器将其关联起来

-- Create table
create table DWD_GLSID_AFCM
(
  seq_no_id   NUMBER not null,
  tag         VARCHAR2(32),
  gls_id      VARCHAR2(32),
  pnl_id      VARCHAR2(32),
  durable     VARCHAR2(32),
  batch_id    VARCHAR2(32),
  update_user VARCHAR2(32),
  update_time DATE default SYSDATE
)
tablespace EDW_COM_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

---

-- Create sequence 
create sequence SEQ_NO_ID
minvalue 1
maxvalue 9999999999999999999999999999
start with 1
increment by 1
cache 20;

---

-- Create trigger
CREATE OR REPLACE TRIGGER INSERT_DWD_GLSID_AFCM
  BEFORE INSERT ON DWD_GLSID_AFCM
  REFERENCING NEW AS NEW OLD AS OLD
  FOR EACH ROW
BEGIN
  SELECT SEQ_NO_ID.NEXTVAL INTO :NEW.SEQ_NO_ID FROM DUAL;
END;