銀行儲蓄業(yè)務(wù)管理系統(tǒng)介紹-文庫吧資料
2025-04-14 05:58本頁面
【正文】 應(yīng)儲戶的余額(balance)減少插入記錄包含的金額數(shù)(money)CREATE OR REPLACE TRIGGER OperatingDw AFTER INSERT ON drawslip FOR EACH ROWDECLAREn_ac VARCHAR2(5)。update luser set balance=balanceo_mo where =o_ac。BEGINo_ac:=:。刪除存款，對應(yīng)儲戶表的相應(yīng)儲戶的余額(balance)減去所刪除記錄的金額數(shù)(money)CREATE OR REPLACE TRIGGER OperatingDps2 AFTER DELETE ON depositslip FOR EACH ROWDECLAREo_ac VARCHAR2(5)。update luser set balance=balance+n_mo where =n_ac。BEGINn_ac:=:。6）觸發(fā)器插入存款，對應(yīng)儲戶表的相應(yīng)儲戶的余額(balance)增加插入記錄包含的金額數(shù)(money)CREATE OR REPLACE TRIGGER OperatingDps AFTER INSERT ON depositslip FOR EACH ROWDECLAREn_ac VARCHAR2(5)。在取款單表的賬號字段建立索引CREATE INDEX XIF1drawslip ON drawslip(aum ASC)。在存款單表的賬號字段建立索引CREATE INDEX XIF1depositslip ON depositslip(aum ASC)。)。), 39。,39。,39,to_date(39。insert into drawslip (DW_NUM, ACNUM, MONEY, DW_TIME, DW_WAY)values (52008,39。柜臺39。ddmmyyyy39。1010201039。0000539。)。), 39。,39。,100,to_date(39。insert into drawslip (DW_NUM, ACNUM, MONEY, DW_TIME, DW_WAY)values (52006,39。取款機(jī)39。ddmmyyyy39。1209201039。0000439。)。), 39。,39。,47,to_date(39。insert into drawslip (DW_NUM, ACNUM, MONEY, DW_TIME, DW_WAY)values (52004,39。柜臺39。ddmmyyyy39。1210201039。0000239。)。), 39。,39。, 27,to_date(39。insert into drawslip (DW_NUM, ACNUM, MONEY, DW_TIME, DW_WAY)values (52002,39。柜臺39。ddmmyyyy39。0808201039。0000139。)。), 39。,39。, 210,to_date(39。insert into depositslip (DPS_NUM, ACNUM, MONEY, DPS_TIME, DPS_WAY)values (98011,39。通知存款39。ddmmyyyy39。2408200939。0000539。)。), 39。,39。, 180,to_date(39。insert into depositslip (DPS_NUM, ACNUM, MONEY, DPS_TIME, DPS_WAY)values (98009,39。零存零取39。ddmmyyyy39。2308200939。0000439。)。), 39。,39。, 80,to_date(39。insert into depositslip (DPS_NUM, ACNUM, MONEY, DPS_TIME, DPS_WAY)values (98007,39。零存整取39。ddmmyyyy39。1409200939。0000339。)。), 39。,39。, 200,to_date(39。insert into depositslip (DPS_NUM, ACNUM, MONEY, DPS_TIME, DPS_WAY)values (98005,39。整存零取39。ddmmyyyy39。1209200939。0000239。)。), 39。,39。, 100,to_date(39。insert into depositslip (DPS_NUM, ACNUM, MONEY, DPS_TIME, DPS_WAY)values (98003,39。整存整取39。ddmmyyyy39。1008200939。0000139。)。), 39。,39。, 120,to_date(39。插入存款單表(depositslip)數(shù)據(jù)insert into depositslip (DPS_NUM, ACNUM, MONEY, DPS_TIME, DPS_WAY)values (98001,39。香港市旺角區(qū)39。女39。陳麗華39。0000539。, 234)。, 39。, 39。, 3422104, 39。insert into luser (ACNUM, ID, NAME, SEX,HEIGHT, ADDRESS, BALANCE)values (39。南京市新街口39。男39。陳光標(biāo)39。0000339。, 123)。, 39。, 39。, 3422102, 39。insert into luser (ACNUM, ID, NAME, SEX,HEIGHT, ADDRESS, BALANCE)values (39。北京市朝陽區(qū)39。男39。劉忠田39。0000139。ALTER TABLE drawslip 在drawslip表中的aum字段中添加外鍵約束 ADD (CONSTRAINT R_6 FOREIGN KEY (aum) REFERENCES luser(aum))。取款單表(drawslip)字段(屬性)含義字段(屬性)名字段(屬性)類型取款單號dw_numNUMBER賬號aumVARCHAR2(5)取款時間dw_timeTIMESTAMP金額(億)MoneyINT取款方式dw_wayVARCHAR2(10)創(chuàng)建取款單表的代碼如下：CREATE TABLE drawslip( dw_num NUMBER NOT NULL , money INT CHECK(money=0), dw_way
公司管理相關(guān)推薦
鄂ICP備17016276號-1