Pragathi sneha
2011-04-05 07:43:02 UTC
account_number number;
bal number;
deposit number;
withdr number;
begin
account_number:=&account_number;
select balance into bal from sbaccount where acct_number=account_number;
deposit:=&deposit;
update sbaccount set balance=balance+deposit where acct_number=account_number;
select balance into bal from sbaccount where acct_number=account_number;
if bal>1000 then
withdr:=&withdr;
update sbaccount set balance=balance-withdr where acct_number=account_number
end if;
end;