PLSQL中用于转账的存储过程

huwehgph 于 2022-10-04 发布在 Oracle

关注(0)|答案(1)|浏览(163)

希望你能顺利完成这项任务。

Please help me out with this,

My requirement is to transfer money from one account to another account which is in a same table.
the procedure should have 3 in parameters,
They are,
--> from_account_number
--> To_account_number
--> Credit_amount

实际数据：

acc_num        acc_bal
12345          50000
67890          40000

预期数据：

eg: exec trans_sp(12345,67890,10000);

ac_num   ac_bal
12345    40000
67890    60000

`trans_sp`

oracle

来源：https://stackoverflow.com/questions/73933893/stored-procedure-for-money-transfer-in-plsql

1条答案

按热度按时间

oyjwcjzk1#

一个简单的选项(根本没有控件；您可以自己添加)：

以前：

SQL> select * from money;

ACCOUNT_NU     AMOUNT
---------- ----------
12345           10000
65789           20000
86420           30000

程序：

SQL> create or replace procedure trans_sp (par_acc_from in varchar2, par_acc_to in varchar2, par_amount in number)
  2  is
  3  begin
  4    update money set
  5      amount = amount - par_amount
  6      where account_number = par_acc_from;
  7
  8    update money set
  9      amount = amount + par_amount
 10      where account_number = par_acc_to;
 11  end;
 12  /

Procedure created.

测试：

SQL> exec trans_sp('86420', '12345', 5000);

PL/SQL procedure successfully completed.

之后：

SQL> select * from money;

ACCOUNT_NU     AMOUNT
---------- ----------
12345           15000
65789           20000
86420           25000

SQL>

赞(0）回复(0）举报 2022-10-04

我来回答

PLSQL中用于转账的存储过程

1条答案

相关问题

热门标签

最新问答