线上咨询预约网站建设方案,wordpress二级目录,设计公司详情,网站没有备案可以做百度推广吗oracle从各个表取得数据保存到另一个表从各个表中取得数据保存另一个表中#xff1a;CREATE VIEWPARAMETER_view ASWITHtall AS(SELECTp.PI_NO,--产品序列号p.SERIALNO,--产品编号p.PI_NAME,--产品名称p. PI_START_DATE,--产品起息日p.PI_END_DATE,--产品期日期p.PI_CUSTOMER_…oracle从各个表取得数据保存到另一个表从各个表中取得数据保存另一个表中CREATE VIEWPARAMETER_view ASWITHtall AS(SELECTp.PI_NO,--产品序列号p.SERIALNO,--产品编号p.PI_NAME,--产品名称p. PI_START_DATE,--产品起息日p.PI_END_DATE,--产品期日期p.PI_CUSTOMER_YIELD/100 PI_CUSTOMER_YIELD, --产品收益率a.AI_NO, --资产序列号a.CAS_ASSETS_NA,--资产的名称a.DONO,--资产的编码a.CAS_ISSUE_SUM,--资产发行金额a.CAS_YIELD_RATE/100 CAS_YIELD_RATE, --资产收益率a.CAS_VALUE_DATE , --资产起息日a.CAS_DUE_DATE , --资产到期日期NVL(FeeNum,0) FeeNum,--其他费用NVL(FeeRate,0) FeeRate,--其他费率NVL(fmfee,0) fmfee, --累计浮动管理费NVL( fmfee3/100,0) fmfee3, --浮动管理费NVL(ct.FEERATIO/100,0) FEERATIO, --产品的托管费NVL( cg.cgrate/100,0) cgrate --产品的管理费NVL( atrate/100,0) atrate--资产的托管费NVL( agrate/100,0) agrate ,--资产的管理费NVL( cgrates/100,0) cgrates ,--产品的投顾费NVL( agrates/100,0) agrates ,--资产的投顾费gl_date --交易日期floor(SYSDATE-to_date(PI_START_DATE,yyyy-mm-dd hh24:mi:ss)) pflday--产品累加天数floor(SYSDATE-to_date(CAS_VALUE_DATE,yyyy-mm-dd hh24:mi:ss)) aflday--资产累加天数FROMGL_PRODUCTASSETS gLEFT JOINProduct_info pONg.PBS_MAINPRO_NOp.PI_NOLEFT JOINASSETS_INFO aONg.CAS_ASSETS_NUa.AI_NOLEFT JOIN(SELECTproductid,SUM(FMFEE) fmfeeFROMPRODUCT_FMFEEGROUP BYproductid ) fONg.PBS_MAINPRO_NOf.PRODUCTIDLEFT JOIN(SELECTFEERATIO fmfee3,FEEOBJECTNOFROMPRODUCT_COST_INFOWHEREFEETYPE浮动管理费 ) f2ONp.PI_NOf2.FEEOBJECTNOLEFT JOIN(SELECT*FROMPRODUCT_COST_INFOWHEREfeeobjecttypeProductAND FEETYPE托管费) ctONp.PI_NOct.FEEOBJECTNOLEFT JOIN(SELECTsum( FEERATIO) cgrate ,FEEOBJECTNOFROMPRODUCT_COST_INFOWHEREfeeobjecttypeProductAND FEETYPE管理费 group by FEEOBJECTNO ) cgONp.PI_NOcg.FEEOBJECTNOLEFT JOIN(SELECTFEERATIO cgrates ,FEEOBJECTNOFROMPRODUCT_COST_INFOWHEREfeeobjecttypeProductAND FEETYPE投顾费) cggONp.PI_NOcgg.FEEOBJECTNOLEFT JOIN(SELECTFEERATIO atrate ,FEEOBJECTNOFROMPRODUCT_COST_INFOWHEREfeeobjecttypeAssetAND FEETYPE托管费) attONa.AI_NOatt.FEEOBJECTNOLEFT JOIN(SELECTFEERATIO agrate ,FEEOBJECTNOFROMPRODUCT_COST_INFOWHEREfeeobjecttypeAssetAND FEETYPE管理费) agONa.AI_NOag.FEEOBJECTNOLEFT JOIN(SELECTFEERATIO agrates ,FEEOBJECTNOFROMPRODUCT_COST_INFOWHEREfeeobjecttypeAssetAND FEETYPE投顾费) aggONa.AI_NOagg.FEEOBJECTNOLEFT JOIN(SELECTSUM( FEERATIO ) FeeNum,FEEOBJECTNOFROMPRODUCT_COST_INFOWHEREfeeobjecttypeProductAND FEETYPE NOT IN (托管费,投顾费,管理费,浮动管理费)AND FEERATIO1GROUP BYFEEOBJECTNO) fsONa.AI_NOfs.FEEOBJECTNOLEFT JOIN(SELECTSUM( FEERATIO ) FeeRate,FEEOBJECTNOFROMPRODUCT_COST_INFOWHEREfeeobjecttypeProductAND FEETYPE NOT IN (托管费,投顾费,管理费,浮动管理费)AND FEERATIO1GROUP BYFEEOBJECTNO) fssONa.AI_NOfss.FEEOBJECTNOWHEREG.GL_STATE1)SELECTta.*,(a_day_receivep_day_managep_day_tmp_day_tes-p_day_receive-a_day_manage-a_day_tm-a_day_tesfmfee3FeeNum) all_getFROM(SELECTPI_NO,PI_NAME,PI_CUSTOMER_YIELD*CAS_ISSUE_SUM/365 p_day_receive --产品编号产品名称产品每日收益PI_CUSTOMER_YIELD*CAS_ISSUE_SUM/365*pflday p_all_receive, --起息日到当天的累计cgrate*CAS_ISSUE_SUM/365 p_day_manage --产品当天管理费cgrate*CAS_ISSUE_SUM/365*pflday p_all_manage --产品累计管理费FEERATIO*CAS_ISSUE_SUM/365 p_day_tm --产品当天托管费FEERATIO*CAS_ISSUE_SUM/365*pflday p_all_tm --产品累计托管费CAS_ASSETS_NACAS_YIELD_RATE*CAS_ISSUE_SUM/365 a_day_receive --资产编号资产名称资产每日收益CAS_YIELD_RATE*CAS_ISSUE_SUM/365*aflday a_all_receieve, --资产起息日到当天的累计agrate*CAS_ISSUE_SUM/365 a_day_manage --资产当天管理费agrate*CAS_ISSUE_SUM/365*aflday a_all_manage --产品累计管理费atrate*CAS_ISSUE_SUM/365 a_day_tm --资产当天托管费atrate*CAS_ISSUE_SUM/365*aflday a_all_tm, --资产累计托管费0 tdfee,0 tdallfee,fmfee3,cgrates*CAS_ISSUE_SUM/365 p_day_tes,--产品当天投顾费cgrates*CAS_ISSUE_SUM/365*pflday p_all_tes,--产品累计投顾费agrates*CAS_ISSUE_SUM/365 a_day_tes--资产当天投顾费agrates*CAS_ISSUE_SUM/365*aflday a_all_tes, --资产累计投顾费FeeNum --其他费用FROMtall) ta ;SELECTDECODE(gl_date,a.CAS_VALUE_DATE, p.PI_NO , p.PI_NAME )FROMGL_PRODUCTASSETS gLEFT JOINProduct_info pONg.PBS_MAINPRO_NOp.PI_NOLEFT JOINASSETS_INFO aONg.CAS_ASSETS_NUa.AI_NOLEFT JOIN(SELECTproductid,SUM(FMFEE) fmfeeFROMPRODUCT_FMFEEGROUP BYproductid ) fONg.PBS_MAINPRO_NOf.PRODUCTIDLEFT JOIN(SELECTproductid,SUM(FMFEE) fmfee3FROMPRODUCT_FMFEEWHEREINPUTDATE TO_CHAR(SYSDATE,YYYY/MM/DD)GROUP BYproductid) f2ONg.PBS_MAINPRO_NOf2.PRODUCTIDLEFT JOIN(SELECT*FROMPRODUCT_COST_INFOWHEREfeeobjecttypeProductAND FEETYPE托管费) ctONp.PI_NOct.FEEOBJECTNOLEFT JOIN(SELECTFEERATIO cgrate ,FEEOBJECTNOFROMPRODUCT_COST_INFOWHEREfeeobjecttypeProductAND FEETYPE管理费) cgONp.PI_NOcg.FEEOBJECTNOLEFT JOIN(SELECTFEERATIO cgrates ,FEEOBJECTNOFROMPRODUCT_COST_INFOWHEREfeeobjecttypeProductAND FEETYPE投顾费) cggONp.PI_NOcg.FEEOBJECTNOLEFT JOIN(SELECTFEERATIO atrate ,FEEOBJECTNOFROMPRODUCT_COST_INFOWHEREfeeobjecttypeAssetAND FEETYPE托管费) attONa.AI_NOatt.FEEOBJECTNOLEFT JOIN(SELECTFEERATIO agrate ,FEEOBJECTNOFROMPRODUCT_COST_INFOWHEREfeeobjecttypeAssetAND FEETYPE管理费) agONa.AI_NOag.FEEOBJECTNOLEFT JOIN(SELECTFEERATIO agrates ,FEEOBJECTNOFROMPRODUCT_COST_INFOWHEREfeeobjecttypeAssetAND FEETYPE投顾费) aggONa.AI_NOag.FEEOBJECTNOWHEREG.GL_STATE1然后把这个视图数据保存到你要保存的表insert into (和视图的列要对应的列名)表A(select * from 视图表)
