Oracle使用同一列数据计算并更新到另外一列

Oracle使用同一列数据计算并更新到另外一列

例如，我有一张表记录每月开销，建表语句如下

DROP TABLE TESTED.MONTH_SPEND CASCADE CONSTRAINTS;

CREATE TABLE TESTED.MONTH_SPEND(

    AMT NUMBER,
    S_TYPE VARCHAR2(100 CHAR),
    PROPORTION VARCHAR2 (20 CHAR),
    S_MONTH VARCHAR2(17 CHAR)
    

);

COMMENT ON TABLE TESTED.MONTH_SPEND IS '每月开销记录表';

COMMENT ON COLUMN TESTED.MONTH_SPEND.AMT IS '开销金额(元)';

COMMENT ON COLUMN TESTED.MONTH_SPEND.S_TYPE IS '支出类型';

COMMENT ON COLUMN TESTED.MONTH_SPEND.PROPORTION IS '开销占比';

COMMENT ON COLUMN TESTED.MONTH_SPEND.S_MONTH IS '支出月份';

19年10月开销花费数据记录

--清除已有数据
DELETE FROM TESTED.MONTH_SPEND  WHERE S_MONTH = '2019-10';
COMMIT;
--添加新数据
INSERT INTO TESTED.MONTH_SPEND VALUES(2000,'吃饭','','2019-10');
INSERT INTO TESTED.MONTH_SPEND VALUES(1000,'买衣服','','2019-10')