代码重贴。
create table yx_out(
yx_out_id INTEGER CONSTRAINT yx_out_id_pk
primary key,
danwei VARCHAR(200) DEFAULT NULL,
huhao VARCHAR(200) DEFAULT NULL,
huming VARCHAR(200) DEFAULT NULL,
yddz VARCHAR(200) DEFAULT NULL,
cbdbh VARCHAR(200) DEFAULT NULL,
txm VARCHAR(200) DEFAULT NULL,
zcbh VARCHAR(200) DEFAULT NULL,
jldbh VARCHAR(200) DEFAULT NULL,
bxzyh VARCHAR(200) DEFAULT NULL,
bxwz VARCHAR(200) DEFAULT NULL,
lc VARCHAR(200) DEFAULT NULL,
bxlx VARCHAR(200) DEFAULT NULL,
tqmc VARCHAR(200) DEFAULT NULL,
tqbh VARCHAR(200) DEFAULT NULL,
jingdu VARCHAR(200) DEFAULT NULL,
weidu VARCHAR(200) DEFAULT NULL,
jrdbh VARCHAR(200) DEFAULT NULL,
jrdmc VARCHAR(200) DEFAULT NULL
);
/*创建yx_out表主键序列*/
CREATE SEQUENCE yx_out_id_sequence
INCREMENT BY 1
START WITH 1
NOCYCLE
NOCACHE;
/*创建yx_out表主键递增触发器*/
CREATE OR REPLACE TRIGGER yx_out_id_increase
before INSERT ON yx_out
FOR each row
DECLARE
BEGIN
select yx_out_id_sequence.nextval INTO :new.yx_out_id FROM dual;
END yx_out_id_increase;
create table yx_out(
yx_out_id INTEGER CONSTRAINT yx_out_id_pk
primary key,
danwei VARCHAR(200) DEFAULT NULL,
huhao VARCHAR(200) DEFAULT NULL,
huming VARCHAR(200) DEFAULT NULL,
yddz VARCHAR(200) DEFAULT NULL,
cbdbh VARCHAR(200) DEFAULT NULL,
txm VARCHAR(200) DEFAULT NULL,
zcbh VARCHAR(200) DEFAULT NULL,
jldbh VARCHAR(200) DEFAULT NULL,
bxzyh VARCHAR(200) DEFAULT NULL,
bxwz VARCHAR(200) DEFAULT NULL,
lc VARCHAR(200) DEFAULT NULL,
bxlx VARCHAR(200) DEFAULT NULL,
tqmc VARCHAR(200) DEFAULT NULL,
tqbh VARCHAR(200) DEFAULT NULL,
jingdu VARCHAR(200) DEFAULT NULL,
weidu VARCHAR(200) DEFAULT NULL,
jrdbh VARCHAR(200) DEFAULT NULL,
jrdmc VARCHAR(200) DEFAULT NULL
);
/*创建yx_out表主键序列*/
CREATE SEQUENCE yx_out_id_sequence
INCREMENT BY 1
START WITH 1
NOCYCLE
NOCACHE;
/*创建yx_out表主键递增触发器*/
CREATE OR REPLACE TRIGGER yx_out_id_increase
before INSERT ON yx_out
FOR each row
DECLARE
BEGIN
select yx_out_id_sequence.nextval INTO :new.yx_out_id FROM dual;
END yx_out_id_increase;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货