Oralce数据库建表及id递增触发器

风声渐微

已于 2023-05-18 13:34:41 修改

阅读量95

点赞数 1

分类专栏： oracle 文章标签：数据库 sql oracle

于 2023-03-31 18:44:33 首次发布

本文链接：https://blog.csdn.net/weixin_46120673/article/details/129886527

版权

oracle 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

建表

create table PRD_STATIC_CONFIGURATION
(
  ID NUMBER not null,
  CONFIGURE_NAME VARCHAR2(200) ,
  CONFIGURE_DETAILS_NAME VARCHAR2(200),
  CONFIGURE_VALUE1 VARCHAR2(200),
  CONFIGURE_VALUE2 VARCHAR2(200),
  CONFIGURE_TIME DATE,
  CONFIGURE_USER VARCHAR2(200),
  REMARKS VARCHAR2(200)
)

comment on column PRD_STATIC_CONFIGURATION.ID
  is '序号';
comment on column PRD_STATIC_CONFIGURATION.CONFIGURE_NAME
  is '配置名';
comment on column PRD_STATIC_CONFIGURATION.CONFIGURE_DETAILS_NAME
  is '配置详情名';
comment on column PRD_STATIC_CONFIGURATION.CONFIGURE_VALUE1
  is '配置值1';
comment on column PRD_STATIC_CONFIGURATION.CONFIGURE_VALUE2
  is '配置值2';
comment on column PRD_STATIC_CONFIGURATION.CONFIGURE_TIME
  is '配置时间';
comment on column PRD_STATIC_CONFIGURATION.CONFIGURE_USER
  is '配置人';
comment on column PRD_STATIC_CONFIGURATION.REMARKS
  is '备注';

建序列器

create sequence PRD_STATIC_CONFIGURATION_SEQ
minvalue 1
maxvalue 9999999999999999999999999999
start with 1
increment by 1
nocache;

建触发器

CREATE OR REPLACE TRIGGER PRD_STATIC_CONFIGURATION_TRG
BEFORE INSERT ON PRD_STATIC_CONFIGURATION FOR EACH ROW
WHEN(NEW.ID Is NULL)
BEGIN
  SELECT PRD_STATIC_CONFIGURATION_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;