創(chuàng)建表
create table demo( did varchar2(20) constraint pk_demo PRimary key, dname varchar2(20), bumen varchar2(100) )創(chuàng)建自增ID,名稱為:表名_字段名_SEQ
create sequence demo_did_seq minvalue 1 nomaxvalue increment by 1 start with 1 nocache;為Insert操作創(chuàng)建觸發(fā)器,無需在sql語句里寫NEXTVAL,名稱為表名_INS_TRG
create or replace trigger demo_ins_trgbefore inserton demofor each row when(new.did is null)begin select demo_did_seq.nextval into :new.did from dual;end;/
新聞熱點
疑難解答
