oracle创建表-序列-触发器

-- Create table
create table T_INTER_EXTERNAL_EXPERT
(
  NUM_ID      NUMBER(16) not null,
  APPLY_ID    NUMBER(16),
  NAME        VARCHAR2(32) not null,
  SEX         VARCHAR2(32) not null,
  BIRTHDAY    DATE,
  FROM_NATION VARCHAR2(32),
  DEGREE      VARCHAR2(32),
  DEPT_NAME   VARCHAR2(100),
  DUTY        VARCHAR2(32) not null,
  SPEC_AREAS  VARCHAR2(100) not null,
  SPECIALITY  VARCHAR2(100),
  ID_CODE     VARCHAR2(32) not null,
  PHONE       VARCHAR2(32),
  EMAIL       VARCHAR2(64),
  FAX         VARCHAR2(32),
  REMARK      VARCHAR2(255)
)
tablespace TBS_URP
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Add comments to the table 
comment on table T_INTER_EXTERNAL_EXPERT
  is '05_国际交流合作项目计划表外聘专家';
-- Add comments to the columns 
comment on column T_INTER_EXTERNAL_EXPERT.NUM_ID
  is '流水号';
comment on column T_INTER_EXTERNAL_EXPERT.APPLY_ID
  is '申请号';
comment on column T_INTER_EXTERNAL_EXPERT.NAME
  is '姓名';
comment on column T_INTER_EXTERNAL_EXPERT.SEX
  is '性别';
comment on column T_INTER_EXTERNAL_EXPERT.BIRTHDAY
  is '出生日期';
comment on column T_INTER_EXTERNAL_EXPERT.FROM_NATION
  is '国籍';
comment on column T_INTER_EXTERNAL_EXPERT.DEGREE
  is '最高学位';
comment on column T_INTER_EXTERNAL_EXPERT.DEPT_NAME
  is '工作单位';
comment on column T_INTER_EXTERNAL_EXPERT.DUTY
  is '职务';
comment on column T_INTER_EXTERNAL_EXPERT.SPEC_AREAS
  is '专业领域';
comment on column T_INTER_EXTERNAL_EXPERT.SPECIALITY
  is '专业方向';
comment on column T_INTER_EXTERNAL_EXPERT.ID_CODE
  is '护照号码';
comment on column T_INTER_EXTERNAL_EXPERT.PHONE
  is '联系电话';
comment on column T_INTER_EXTERNAL_EXPERT.EMAIL
  is '电子信箱';
comment on column T_INTER_EXTERNAL_EXPERT.FAX
  is '传真';
comment on column T_INTER_EXTERNAL_EXPERT.REMARK
  is '备注';
-- Create/Recreate primary, unique and foreign key constraints 
alter table T_INTER_EXTERNAL_EXPERT
  add constraint PK_T_INTER_EXTERNAL_EXPERT primary key (NUM_ID)
  using index 
  tablespace TBS_URP
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
  
  ----
 


create sequence SEQ_PLANEXPERT
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;


----Create trigger 建立名为TRIG_CARD的触发器 
----当向表T_CADRES_CARD插入数据时,自动触发。id自动增长。


create or replace trigger TRIG_PLANEXPERT
  before insert on urp_bjfu.T_INTER_EXTERNAL_EXPERT
  for each row
declare
  id_ urp_bjfu.T_INTER_EXTERNAL_EXPERT.NUM_ID%type;
begin
  select urp_bjfu.SEQ_PLANEXPERT.nextval into id_ from dual;
  :new.NUM_ID := id_;
end ;
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值