create or replace trigger order_b5
before insert on order_b
for each row
declare
dj varchar2(3000);
begin
dj:=(select price from danjia b where b.id:new.id and rownum=1);
:new.vbdef16 :=dj;
end order_b5;报错误:PLS-00103: ,
以下就没有问题,但我想我想从其它表取值过来。应该怎么写呢?
--------------------------------------------create or replace trigger order_b5
before insert on order_b
for each row
declare
dj varchar2(3000);
begin
dj:=‘1’;
:new.vbdef16 :=dj;
end order_b5;
before insert on order_b
for each row
declare
dj varchar2(3000);
begin
dj:=(select price from danjia b where b.id:new.id and rownum=1);
:new.vbdef16 :=dj;
end order_b5;报错误:PLS-00103: ,
以下就没有问题,但我想我想从其它表取值过来。应该怎么写呢?
--------------------------------------------create or replace trigger order_b5
before insert on order_b
for each row
declare
dj varchar2(3000);
begin
dj:=‘1’;
:new.vbdef16 :=dj;
end order_b5;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货