先
create table test
(num_id number(10),
name varchar2(10),
password varchar2(10))
然后建
create sequence myseq increment by 1 start with 1 nomaxvalue
然后,
create or replace trigger test1
before insert on test
for each row
begin
new.num_id:=myseq.nextval;
end;
编译时出错,
请问trigger哪里有问题?
create table test
(num_id number(10),
name varchar2(10),
password varchar2(10))
然后建
create sequence myseq increment by 1 start with 1 nomaxvalue
然后,
create or replace trigger test1
before insert on test
for each row
begin
new.num_id:=myseq.nextval;
end;
编译时出错,
请问trigger哪里有问题?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货