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


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

Original text of this message