create table COMPANY(
ID NUMBER NOT NULL,
COMPANY_NO varchar2(30) NOT NULL,
NAME varchar2(50) NOT NULL,
LEGAL_NAME varchar2(20) NOT NULL,
LEGAL_MOBILE varchar2(11) NOT NULL,
ID_CARD varchar2(30) NOT NULL,
ADDRESS varchar2(50) NOT NULL,
STATUS varchar2(2) NOT NULL,
CREATE_AT DATE NOT NULL,
LINK_NAME VARCHAR2(20) NOT NULL,
LINK_MOBILE VARCHAR2(11) NOT NULL,
LINCENSE_NO VARCHAR2(50) NOT NULL,
DISPLAY VARCHAR2(2) NOT NULL,
UPDATE_AT DATE NOT NULL,
constraint PK_COMPANY primary key (ID)
);
CREATE SEQUENCE company_sequence
INCREMENT BY 1 -- 每次加几个
START WITH 1 -- 从1开始计数
NOMAXVALUE -- 不设置最大值
NOCYCLE -- 一直累加,不循环
NOCACHE -- 不建缓冲区
CREATE OR REPLACE TRIGGER company_trg BEFORE
INSERT ON company FOR EACH ROW WHEN (new.id is null)
begin
select company_sequence.nextval into :new.id from dual;--请注意这里的冒号跟new之间是没有空格的,我从网上复制过来的就是因为中间多了一个空格啊!坑爹啊
end;
insert into COMPANY (COMPANY_NO, NAME, LEGAL_NAME, LEGAL_MOBILE, ID_CARD,ADDRESS,STATUS,CREATE_AT,LINK_NAME,LINK_MOBILE,LINCENSE_NO,DISPLAY,UPDATE_AT)
values ('1000000001','甘肃爱彼利科技有限公司','闫亮','18888888888','620123199509122546','甘肃省兰州市城关区静宁路昌运大厦','0',to_date('2018-06-19 19:55:45', 'yyyy-mm-dd hh24:mi:ss'),
'李彦锟','18993065156','888888888888','0',to_date('2018-06-19 19:55:45', 'yyyy-mm-dd hh24:mi:ss'));
ID NUMBER NOT NULL,
COMPANY_NO varchar2(30) NOT NULL,
NAME varchar2(50) NOT NULL,
LEGAL_NAME varchar2(20) NOT NULL,
LEGAL_MOBILE varchar2(11) NOT NULL,
ID_CARD varchar2(30) NOT NULL,
ADDRESS varchar2(50) NOT NULL,
STATUS varchar2(2) NOT NULL,
CREATE_AT DATE NOT NULL,
LINK_NAME VARCHAR2(20) NOT NULL,
LINK_MOBILE VARCHAR2(11) NOT NULL,
LINCENSE_NO VARCHAR2(50) NOT NULL,
DISPLAY VARCHAR2(2) NOT NULL,
UPDATE_AT DATE NOT NULL,
constraint PK_COMPANY primary key (ID)
);
CREATE SEQUENCE company_sequence
INCREMENT BY 1 -- 每次加几个
START WITH 1 -- 从1开始计数
NOMAXVALUE -- 不设置最大值
NOCYCLE -- 一直累加,不循环
NOCACHE -- 不建缓冲区
CREATE OR REPLACE TRIGGER company_trg BEFORE
INSERT ON company FOR EACH ROW WHEN (new.id is null)
begin
select company_sequence.nextval into :new.id from dual;--请注意这里的冒号跟new之间是没有空格的,我从网上复制过来的就是因为中间多了一个空格啊!坑爹啊
end;
insert into COMPANY (COMPANY_NO, NAME, LEGAL_NAME, LEGAL_MOBILE, ID_CARD,ADDRESS,STATUS,CREATE_AT,LINK_NAME,LINK_MOBILE,LINCENSE_NO,DISPLAY,UPDATE_AT)
values ('1000000001','甘肃爱彼利科技有限公司','闫亮','18888888888','620123199509122546','甘肃省兰州市城关区静宁路昌运大厦','0',to_date('2018-06-19 19:55:45', 'yyyy-mm-dd hh24:mi:ss'),
'李彦锟','18993065156','888888888888','0',to_date('2018-06-19 19:55:45', 'yyyy-mm-dd hh24:mi:ss'));