Re: Ampersand in PL/SQL
From: Thomas Dunbar <tdunbar_at_gserver.grads.vt.edu>
Date: 1995/04/14
Message-ID: <3mltc3$n8i_at_solaris.cc.vt.edu>#1/1
Date: 1995/04/14
Message-ID: <3mltc3$n8i_at_solaris.cc.vt.edu>#1/1
declare
zzz number(5);
begin
select sal into zzz from emp where empno = &&aaa; if (zzz > 2000) then
update emp set sal = zzz + 10 where empno = &aaa; else
update emp set sal = zzz + 500 where empno = &aaa;
end if;
commit;
end;
yes, that works ok..the first time..when called again, tho, it does not prompt for value but reuses what was given before! Received on Fri Apr 14 1995 - 00:00:00 CEST