如何创建视图（存储过程）

如何创建视图（存储过程）

CREATE OR REPLACE VIEW V_XMFK_PROJECT_THREE
AS
        SELECT
                '114001000000163002' TYPE_CODE,
                PROJECT_CONTENT               ,
                PROJECT_CODE,
                RMB_APP_MONEY,
                VERIFICATION
        FROM
                CASF_SAFE_ACCOUNT_MANAGE
        
        UNION ALL
        
        SELECT
                '114001000000173006' TYPE_CODE,
                PROJECT_CONTENT               ,
                PROJECT_CODE,
                 RMB_MONEY as RMB_APP_MONEY,
                VERIFICATION
        FROM
                CASF_REPAIR_ACCOUNT_MANAGE;