ORACLE 触发器报错,错误:PLS-00103:
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;