SQL过程按渠道统计重点业务发展情况

最新推荐文章于 2022-06-17 17:22:04 发布
最新推荐文章于 2022-06-17 17:22:04 发布
阅读量285 收藏
点赞数
分类专栏： 数据库办公记录语句 文章标签： sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/szc_1985/article/details/109488584
版权

提取相关渠道数据，然后分别从相关业务表提取业务发展明细数据，分别计算每日业务进展

—放号 活跃率 存量 活跃率 宽带新增 活跃率 生态 活跃率 5G终端 活跃率

fan_drop_retable(upper(‘sybb_’||v_monsr||‘shqd_ta’),‘XXXX’);
SQL_STRING:='create table XXXX.sybb’||v_monsr||’_shqd_ta as
select nvl(substr(a.orgid,8,1),’‘0’’) qx,b.name,a.orgid,a.orgname,a.unit_id,a.unit_name,
a.微网格编码,a.微网格名称,a.单位类型,a.渠道类型,a.渠道类别,
nvl(a.是否核心渠道,’‘0’’) 是否核心渠道,a.渠道经理工号,a.渠道经理
from zhyw.xxx_organization a,
zhyw.rpt_county b
where nvl(a.是否自办渠道,’‘0’’)=’‘社会渠道’’
and nvl(substr(a.orgid,8,1),’‘0’’)=b.county_id(+) ’ ;
execute immediate (SQL_STRING);

----放号

fan_drop_retable(upper(‘sybb_’||v_monsr||‘shqd_ta_fh’),‘XXXX’);
SQL_STRING:='create table XXXX.sybb’||v_monsr||‘shqd_ta_fh as
select a.registerorgid,a.servnumber,a.subsid,a.prodid,a.prodname,a.createdate,
to_char(a.createdate,’‘yyyymm’’) cycle, to_char(a.createdate,’‘dd’’) create_dd
from zhyw.xxx_fanghao’||v_monsr||’ a,
XXXX.sybb_’||v_monsr||’_shqd_ta b
where a.registerorgid=b.orgid
and to_char(a.createdate,’‘yyyymm’’)=’’’||v_monsr||’’’
and a.createdate-1<to_date(’’’||P_DAY||’’’,’‘yyyymmdd’’) ’ ;
execute immediate (SQL_STRING);

fan_drop_retable(upper(‘sybb_’||v_monsr||‘shqd_ta_fha’),‘XXXX’);
SQL_STRING:='create table XXXX.sybb’||v_monsr||‘shqd_ta_fha as
select b.orgid sl_orgid,a.*
from XXXX.sybb’||v_monsr||‘shqd_ta b ,
XXXX.sybb’||v_monsr||’_shqd_ta_fh a
where b.orgid=a.registerorgid(+) ’ ;
execute immediate (SQL_STRING);

–宽带

fan_drop_retable(upper(‘sybb_’||v_monsr||‘shqd_ta_kd’),‘XXXX’);
SQL_STRING:='create table XXXX.sybb’||v_monsr||‘shqd_ta_kd as
select a.recorgid,a.servnumber,a.subsid,
nvl(a.prodid_priv,a.prodid_rh) prodid,
nvl(a.privname_priv,a.privname_rh) privname,a.recdate,
to_char(a.recdate,’‘yyyymm’’) cycle, to_char(a.recdate,’‘dd’’) create_dd
from zhyw.zhai_yxkd_priv_subs a,
XXXX.sybb’||v_monsr||’_shqd_ta b
where a.recorgid=b.orgid
and a.startdate<nvl(a.enddate,sysdate+9999)
and to_char(a.recdate,’‘yyyymm’’)=’’’||v_monsr||’’’
and a.recdate-1<to_date(’’’||P_DAY||’’’,’‘yyyymmdd’’) ’ ;
execute immediate (SQL_STRING);

–存量

    fan_drop_retable(upper('sybb_'||v_monsr||'_shqd_ta_cl'),'XXXX');
    SQL_STRING:='create table XXXX.sybb_'||v_monsr||'_shqd_ta_cl as

select distinct a.PROD_TYPE, a.orgid ,a.ORGNAME, a.unit_name,nvl(a.QX,’‘电子渠道’’)QX,a.subsid,a.oid,
qx_name,a.是否自办渠道,a.渠道类型 ,a.是否核心渠道, t6. 微网格编码, t6.微网格名称,a.班组类型 ,a.班组名称,a.SERVNUMBER,
a.recdate recdate , a.附加信息,
a.prodname,a.privname,a.recopid,zhyw.shc_del_tszf(a.notes)notes ,受理方式,鉴权,业务类型,
to_char(a.createdate,’‘yyyymmdd’’) createdate,a.startdate,a.enddate,a.qx_gs,a.渠道经理工号,a.渠道经理, 根据备注获取工号,
t3. 集团编号,t3.集团名称,t3.集团类型,t3.客户经理 ,个性化,备用字段1,备用字段2,备用字段3,a.status,
to_char(a.statusdate,’‘yyyymmdd’’) statusdate,to_char(a.mtd_flow) mtd_flow,
to_char(mtd_flow_次月) mtd_flow_次月,to_char(mtd_flow_次次月) mtd_flow_次次月,to_char(mtd_flow_次次次月) mtd_flow_次次次月, t4.kehu_type ,
case when t5.servnumber is not null then ‘‘1’’ end 是否员工号码,main_prodname
from zhyw.report_mx_month_’||v_monsr||‘new a,
zhyw.qcy_busscustsubs’||v_monsr||’ t3,
( select * from zhyw.shc_ldjs_kehu_type ) t4,
( select servnumber from zhyw.zb_staff where status=’‘1’’ union
select distinct servnumber from zhyw.shc_tsyh where privname = ‘‘公免用户优惠’’ and enddate is null ) t5,
zhyw.shc_organization t6
where a.prod_type in ( select keywords from zhyw.shc_shishi_report_keywords where 是否聚合明细=’‘1’’ )
and to_char(a.recdate,’‘yyyymm’’)=’’’||v_monsr||’’’
and a.recdate-1<to_date(’’’||P_DAY||’’’,’‘yyyymmdd’’)
and a.servnumber=t3.servnumber(+)
and a.servnumber=t5.servnumber(+)
and a.subsid=t4.subsid(+)
and a.orgid=t6.orgid(+) ’ ;
execute immediate (SQL_STRING);

---特别说明： 需要剔除第一列“新模组升级”的号码中在后面“个性化”字段中的NULL，只保留计入模组升级）

fan_drop_retable(upper('sybb_'||v_monsr||'_shqd_ta_cla'),'XXXX');
    SQL_STRING:='create table XXXX.sybb_'||v_monsr||'_shqd_ta_cla as
select a.orgid registerorgid,a.servnumber,a.subsid,to_char(a.oid) prodid,a.prod_type prodname,a.recdate createdate,
to_char(a.recdate,''yyyymm'') cycle, to_char(a.recdate,''dd'') create_dd 
from  XXXX.sybb_'||v_monsr||'_shqd_ta_cl a,
XXXX.sybb_'||v_monsr||'_shqd_ta b
where a.orgid=b.orgid
and a.prod_type<>''新模组升级''
union all
select a.orgid registerorgid,a.servnumber,a.subsid,to_char(a.oid) prodid,a.prod_type prodname,a.recdate createdate,
to_char(a.recdate,''yyyymm'') cycle, to_char(a.recdate,''dd'') create_dd 
from  XXXX.sybb_'||v_monsr||'_shqd_ta_cl a,
XXXX.sybb_'||v_monsr||'_shqd_ta b
where a.orgid=b.orgid
and a.prod_type=''新模组升级'' and 个性化 is not null  ' ;
    execute immediate (SQL_STRING);

–生态 活跃率

–生态新增
fan_drop_retable(upper(‘sybb_’||v_monsr||‘shqd_ta_st’),‘XXXX’);
SQL_STRING:='create table XXXX.sybb’||v_monsr||‘shqd_ta_st as
select a.subsid,a.servnumber,a.item,a.recdate,a.recorgid,a.applyoperid,a.startdate,a.enddate,a.applyoid,
to_char(a.recdate,’‘yyyymm’’) cycle, to_char(a.recdate,’‘dd’’) create_dd
from zhyw.qcy_js_shengtai_subs a,
XXXX.sybb’||v_monsr||’_shqd_ta b
where a.recorgid=b.orgid
and to_char(a.recdate,’‘yyyymm’’)=’’’||v_monsr||’’’
and a.recdate-1<to_date(’’’||P_DAY||’’’,’‘yyyymmdd’’) ’ ;
execute immediate (SQL_STRING);

--5G终端  活跃率
fan_drop_retable(upper('sybb_'||v_monsr||'_shqd_ta_zdxs'),'XXXX');
    SQL_STRING:='create table XXXX.sybb_'||v_monsr||'_shqd_ta_zdxs as
select a.* from XXXX.scjk_zdxs_slb_hz a,
 XXXX.sybb_'||v_monsr||'_shqd_ta b
where a.recorgid=b.orgid
and to_char(a.recdate,''yyyymm'')='''||v_monsr||''' 
and a.recdate-1<to_date('''||P_DAY||''',''yyyymmdd'')  ' ;
    execute immediate (SQL_STRING);


fan_drop_retable(upper('sybb_'||v_monsr||'_shqd_ta_zdxsa'),'XXXX');
    SQL_STRING:='create table XXXX.sybb_'||v_monsr||'_shqd_ta_zdxsa as
select a.*,b.term_brand,b.term_code,b.term_4g,nvl(b.term_5g,''0'')  term_5g
from XXXX.sybb_'||v_monsr||'_shqd_ta_zdxs a ,
ZIBO.DW_IMEI_TERMINFO_NEW_MS b
where substr(a.imei,1,8)=b.tac(+) ' ;
    execute immediate (SQL_STRING);

fan_drop_retable(upper('sybb_'||v_monsr||'_shqd_ta_zdxsb'),'XXXX');
    SQL_STRING:='create table XXXX.sybb_'||v_monsr||'_shqd_ta_zdxsb as
select a.*,to_char(a.recdate,''yyyymm'') cycle, to_char(a.recdate,''dd'') create_dd 
from XXXX.sybb_'||v_monsr||'_shqd_ta_zdxsa a 
where a.term_5g=''1''  ' ;
    execute immediate (SQL_STRING);

--------汇总

—放号
fan_drop_retable(upper(‘sybb_’||v_monsr||‘shqd_ta_fhz’),‘XXXX’);
SQL_STRING:='create table XXXX.sybb’||v_monsr||‘shqd_ta_fhz as
select ‘’’||P_DAY||’’’ 日期,a.registerorgid,
count() 总量,round(count()/to_number(substr( ‘’’||P_DAY||’’’,7,2)),2) 日均,
count(case when a.create_dd=’‘01’’ then a.subsid end) y01,
count(case when a.create_dd=’‘02’’ then a.subsid end) y02,
count(case when a.create_dd=’‘03’’ then a.subsid end) y03,
count(case when a.create_dd=’‘04’’ then a.subsid end) y04,
count(case when a.create_dd=’‘05’’ then a.subsid end) y05,
count(case when a.create_dd=’‘06’’ then a.subsid end) y06,
count(case when a.create_dd=’‘07’’ then a.subsid end) y07,
count(case when a.create_dd=’‘08’’ then a.subsid end) y08,
count(case when a.create_dd=’‘09’’ then a.subsid end) y09,
count(case when a.create_dd=’‘10’’ then a.subsid end) y10,
count(case when a.create_dd=’‘11’’ then a.subsid end) y11,
count(case when a.create_dd=’‘12’’ then a.subsid end) y12,
count(case when a.create_dd=’‘13’’ then a.subsid end) y13,
count(case when a.create_dd=’‘14’’ then a.subsid end) y14,
count(case when a.create_dd=’‘15’’ then a.subsid end) y15,
count(case when a.create_dd=’‘16’’ then a.subsid end) y16,
count(case when a.create_dd=’‘17’’ then a.subsid end) y17,
count(case when a.create_dd=’‘18’’ then a.subsid end) y18,
count(case when a.create_dd=’‘19’’ then a.subsid end) y19,
count(case when a.create_dd=’‘20’’ then a.subsid end) y20,
count(case when a.create_dd=’‘21’’ then a.subsid end) y21,
count(case when a.create_dd=’‘22’’ then a.subsid end) y22,
count(case when a.create_dd=’‘23’’ then a.subsid end) y23,
count(case when a.create_dd=’‘24’’ then a.subsid end) y24,
count(case when a.create_dd=’‘25’’ then a.subsid end) y25,
count(case when a.create_dd=’‘26’’ then a.subsid end) y26,
count(case when a.create_dd=’‘27’’ then a.subsid end) y27,
count(case when a.create_dd=’‘28’’ then a.subsid end) y28,
count(case when a.create_dd=’‘29’’ then a.subsid end) y29,
count(case when a.create_dd=’‘30’’ then a.subsid end) y30,
count(case when a.create_dd=’‘31’’ then a.subsid end) y31,
count(distinct a.create_dd) 发展日,
to_number(substr( ‘’’||P_DAY||’’’,7,2))-count(distinct a.create_dd) 未破零天数
from XXXX.sybb’||v_monsr||’_shqd_ta_fha a
group by a.registerorgid ’ ;
execute immediate (SQL_STRING);

—存量

fan_drop_retable(upper(‘sybb_’||v_monsr||‘shqd_ta_clz’),‘XXXX’);
SQL_STRING:='create table XXXX.sybb’||v_monsr||‘shqd_ta_clz as
select ‘’’||P_DAY||’’’ 日期,a.registerorgid,
count() 总量,round(count()/to_number(substr( ‘’’||P_DAY||’’’,7,2)),2) 日均,
count(case when a.create_dd=’‘01’’ then a.subsid end) y01,
count(case when a.create_dd=’‘02’’ then a.subsid end) y02,
count(case when a.create_dd=’‘03’’ then a.subsid end) y03,
count(case when a.create_dd=’‘04’’ then a.subsid end) y04,
count(case when a.create_dd=’‘05’’ then a.subsid end) y05,
count(case when a.create_dd=’‘06’’ then a.subsid end) y06,
count(case when a.create_dd=’‘07’’ then a.subsid end) y07,
count(case when a.create_dd=’‘08’’ then a.subsid end) y08,
count(case when a.create_dd=’‘09’’ then a.subsid end) y09,
count(case when a.create_dd=’‘10’’ then a.subsid end) y10,
count(case when a.create_dd=’‘11’’ then a.subsid end) y11,
count(case when a.create_dd=’‘12’’ then a.subsid end) y12,
count(case when a.create_dd=’‘13’’ then a.subsid end) y13,
count(case when a.create_dd=’‘14’’ then a.subsid end) y14,
count(case when a.create_dd=’‘15’’ then a.subsid end) y15,
count(case when a.create_dd=’‘16’’ then a.subsid end) y16,
count(case when a.create_dd=’‘17’’ then a.subsid end) y17,
count(case when a.create_dd=’‘18’’ then a.subsid end) y18,
count(case when a.create_dd=’‘19’’ then a.subsid end) y19,
count(case when a.create_dd=’‘20’’ then a.subsid end) y20,
count(case when a.create_dd=’‘21’’ then a.subsid end) y21,
count(case when a.create_dd=’‘22’’ then a.subsid end) y22,
count(case when a.create_dd=’‘23’’ then a.subsid end) y23,
count(case when a.create_dd=’‘24’’ then a.subsid end) y24,
count(case when a.create_dd=’‘25’’ then a.subsid end) y25,
count(case when a.create_dd=’‘26’’ then a.subsid end) y26,
count(case when a.create_dd=’‘27’’ then a.subsid end) y27,
count(case when a.create_dd=’‘28’’ then a.subsid end) y28,
count(case when a.create_dd=’‘29’’ then a.subsid end) y29,
count(case when a.create_dd=’‘30’’ then a.subsid end) y30,
count(case when a.create_dd=’‘31’’ then a.subsid end) y31,
count(distinct a.create_dd) 发展日,
to_number(substr( ‘’’||P_DAY||’’’,7,2))-count(distinct a.create_dd) 未破零天数
from XXXX.sybb’||v_monsr||’_shqd_ta_cla a
group by a.registerorgid ’ ;
execute immediate (SQL_STRING);

–宽带

fan_drop_retable(upper(‘sybb_’||v_monsr||‘shqd_ta_kdz’),‘XXXX’);
SQL_STRING:='create table XXXX.sybb’||v_monsr||‘shqd_ta_kdz as
select ‘’’||P_DAY||’’’ 日期,a.recorgid registerorgid,
count() 总量,round(count()/to_number(substr( ‘’’||P_DAY||’’’,7,2)),2) 日均,
count(case when a.create_dd=’‘01’’ then a.subsid end) y01,
count(case when a.create_dd=’‘02’’ then a.subsid end) y02,
count(case when a.create_dd=’‘03’’ then a.subsid end) y03,
count(case when a.create_dd=’‘04’’ then a.subsid end) y04,
count(case when a.create_dd=’‘05’’ then a.subsid end) y05,
count(case when a.create_dd=’‘06’’ then a.subsid end) y06,
count(case when a.create_dd=’‘07’’ then a.subsid end) y07,
count(case when a.create_dd=’‘08’’ then a.subsid end) y08,
count(case when a.create_dd=’‘09’’ then a.subsid end) y09,
count(case when a.create_dd=’‘10’’ then a.subsid end) y10,
count(case when a.create_dd=’‘11’’ then a.subsid end) y11,
count(case when a.create_dd=’‘12’’ then a.subsid end) y12,
count(case when a.create_dd=’‘13’’ then a.subsid end) y13,
count(case when a.create_dd=’‘14’’ then a.subsid end) y14,
count(case when a.create_dd=’‘15’’ then a.subsid end) y15,
count(case when a.create_dd=’‘16’’ then a.subsid end) y16,
count(case when a.create_dd=’‘17’’ then a.subsid end) y17,
count(case when a.create_dd=’‘18’’ then a.subsid end) y18,
count(case when a.create_dd=’‘19’’ then a.subsid end) y19,
count(case when a.create_dd=’‘20’’ then a.subsid end) y20,
count(case when a.create_dd=’‘21’’ then a.subsid end) y21,
count(case when a.create_dd=’‘22’’ then a.subsid end) y22,
count(case when a.create_dd=’‘23’’ then a.subsid end) y23,
count(case when a.create_dd=’‘24’’ then a.subsid end) y24,
count(case when a.create_dd=’‘25’’ then a.subsid end) y25,
count(case when a.create_dd=’‘26’’ then a.subsid end) y26,
count(case when a.create_dd=’‘27’’ then a.subsid end) y27,
count(case when a.create_dd=’‘28’’ then a.subsid end) y28,
count(case when a.create_dd=’‘29’’ then a.subsid end) y29,
count(case when a.create_dd=’‘30’’ then a.subsid end) y30,
count(case when a.create_dd=’‘31’’ then a.subsid end) y31,
count(distinct a.create_dd) 发展日,
to_number(substr( ‘’’||P_DAY||’’’,7,2))-count(distinct a.create_dd) 未破零天数
from XXXX.sybb’||v_monsr||’_shqd_ta_kd a
group by a.recorgid ’ ;
execute immediate (SQL_STRING);

—生态

fan_drop_retable(upper(‘sybb_’||v_monsr||‘shqd_ta_stz’),‘XXXX’);
SQL_STRING:='create table XXXX.sybb’||v_monsr||‘shqd_ta_stz as
select ‘’’||P_DAY||’’’ 日期,a.recorgid registerorgid,
count() 总量,round(count()/to_number(substr( ‘’’||P_DAY||’’’,7,2)),2) 日均,
count(case when a.create_dd=’‘01’’ then a.subsid end) y01,
count(case when a.create_dd=’‘02’’ then a.subsid end) y02,
count(case when a.create_dd=’‘03’’ then a.subsid end) y03,
count(case when a.create_dd=’‘04’’ then a.subsid end) y04,
count(case when a.create_dd=’‘05’’ then a.subsid end) y05,
count(case when a.create_dd=’‘06’’ then a.subsid end) y06,
count(case when a.create_dd=’‘07’’ then a.subsid end) y07,
count(case when a.create_dd=’‘08’’ then a.subsid end) y08,
count(case when a.create_dd=’‘09’’ then a.subsid end) y09,
count(case when a.create_dd=’‘10’’ then a.subsid end) y10,
count(case when a.create_dd=’‘11’’ then a.subsid end) y11,
count(case when a.create_dd=’‘12’’ then a.subsid end) y12,
count(case when a.create_dd=’‘13’’ then a.subsid end) y13,
count(case when a.create_dd=’‘14’’ then a.subsid end) y14,
count(case when a.create_dd=’‘15’’ then a.subsid end) y15,
count(case when a.create_dd=’‘16’’ then a.subsid end) y16,
count(case when a.create_dd=’‘17’’ then a.subsid end) y17,
count(case when a.create_dd=’‘18’’ then a.subsid end) y18,
count(case when a.create_dd=’‘19’’ then a.subsid end) y19,
count(case when a.create_dd=’‘20’’ then a.subsid end) y20,
count(case when a.create_dd=’‘21’’ then a.subsid end) y21,
count(case when a.create_dd=’‘22’’ then a.subsid end) y22,
count(case when a.create_dd=’‘23’’ then a.subsid end) y23,
count(case when a.create_dd=’‘24’’ then a.subsid end) y24,
count(case when a.create_dd=’‘25’’ then a.subsid end) y25,
count(case when a.create_dd=’‘26’’ then a.subsid end) y26,
count(case when a.create_dd=’‘27’’ then a.subsid end) y27,
count(case when a.create_dd=’‘28’’ then a.subsid end) y28,
count(case when a.create_dd=’‘29’’ then a.subsid end) y29,
count(case when a.create_dd=’‘30’’ then a.subsid end) y30,
count(case when a.create_dd=’‘31’’ then a.subsid end) y31,
count(distinct a.create_dd) 发展日,
to_number(substr( ‘’’||P_DAY||’’’,7,2))-count(distinct a.create_dd) 未破零天数
from XXXX.sybb’||v_monsr||’_shqd_ta_st a
group by a.recorgid ’ ;
execute immediate (SQL_STRING);

-----5G终端

fan_drop_retable(upper(‘sybb_’||v_monsr||‘shqd_ta_zdxsz’),‘XXXX’);
SQL_STRING:='create table XXXX.sybb’||v_monsr||‘shqd_ta_zdxsz as
select ‘’’||P_DAY||’’’ 日期,a.recorgid registerorgid,
count() 总量,round(count()/to_number(substr( ‘’’||P_DAY||’’’,7,2)),2) 日均,
count(case when a.create_dd=’‘01’’ then a.imei end) y01,
count(case when a.create_dd=’‘02’’ then a.imei end) y02,
count(case when a.create_dd=’‘03’’ then a.imei end) y03,
count(case when a.create_dd=’‘04’’ then a.imei end) y04,
count(case when a.create_dd=’‘05’’ then a.imei end) y05,
count(case when a.create_dd=’‘06’’ then a.imei end) y06,
count(case when a.create_dd=’‘07’’ then a.imei end) y07,
count(case when a.create_dd=’‘08’’ then a.imei end) y08,
count(case when a.create_dd=’‘09’’ then a.imei end) y09,
count(case when a.create_dd=’‘10’’ then a.imei end) y10,
count(case when a.create_dd=’‘11’’ then a.imei end) y11,
count(case when a.create_dd=’‘12’’ then a.imei end) y12,
count(case when a.create_dd=’‘13’’ then a.imei end) y13,
count(case when a.create_dd=’‘14’’ then a.imei end) y14,
count(case when a.create_dd=’‘15’’ then a.imei end) y15,
count(case when a.create_dd=’‘16’’ then a.imei end) y16,
count(case when a.create_dd=’‘17’’ then a.imei end) y17,
count(case when a.create_dd=’‘18’’ then a.imei end) y18,
count(case when a.create_dd=’‘19’’ then a.imei end) y19,
count(case when a.create_dd=’‘20’’ then a.imei end) y20,
count(case when a.create_dd=’‘21’’ then a.imei end) y21,
count(case when a.create_dd=’‘22’’ then a.imei end) y22,
count(case when a.create_dd=’‘23’’ then a.imei end) y23,
count(case when a.create_dd=’‘24’’ then a.imei end) y24,
count(case when a.create_dd=’‘25’’ then a.imei end) y25,
count(case when a.create_dd=’‘26’’ then a.imei end) y26,
count(case when a.create_dd=’‘27’’ then a.imei end) y27,
count(case when a.create_dd=’‘28’’ then a.imei end) y28,
count(case when a.create_dd=’‘29’’ then a.imei end) y29,
count(case when a.create_dd=’‘30’’ then a.imei end) y30,
count(case when a.create_dd=’‘31’’ then a.imei end) y31,
count(distinct a.create_dd) 发展日,
to_number(substr( ‘’’||P_DAY||’’’,7,2))-count(distinct a.create_dd) 未破零天数
from XXXX.sybb’||v_monsr||’_shqd_ta_zdxsb a
group by a.recorgid ’ ;
execute immediate (SQL_STRING);

------五项合并

fan_drop_retable(upper(‘sybb_’||v_monsr||‘shqd_tsxz’),‘XXXX’);
SQL_STRING:='create table XXXX.sybb’||v_monsr||‘shqd_tsxz as
select ‘’’||P_DAY||’’’ 日期,a.registerorgid registerorgid,
count() 总量,round(count()/to_number(substr( ‘’’||P_DAY||’’’,7,2)),2) 日均,
count(case when a.create_dd=’‘01’’ then a.subsid end) y01,
count(case when a.create_dd=’‘02’’ then a.subsid end) y02,
count(case when a.create_dd=’‘03’’ then a.subsid end) y03,
count(case when a.create_dd=’‘04’’ then a.subsid end) y04,
count(case when a.create_dd=’‘05’’ then a.subsid end) y05,
count(case when a.create_dd=’‘06’’ then a.subsid end) y06,
count(case when a.create_dd=’‘07’’ then a.subsid end) y07,
count(case when a.create_dd=’‘08’’ then a.subsid end) y08,
count(case when a.create_dd=’‘09’’ then a.subsid end) y09,
count(case when a.create_dd=’‘10’’ then a.subsid end) y10,
count(case when a.create_dd=’‘11’’ then a.subsid end) y11,
count(case when a.create_dd=’‘12’’ then a.subsid end) y12,
count(case when a.create_dd=’‘13’’ then a.subsid end) y13,
count(case when a.create_dd=’‘14’’ then a.subsid end) y14,
count(case when a.create_dd=’‘15’’ then a.subsid end) y15,
count(case when a.create_dd=’‘16’’ then a.subsid end) y16,
count(case when a.create_dd=’‘17’’ then a.subsid end) y17,
count(case when a.create_dd=’‘18’’ then a.subsid end) y18,
count(case when a.create_dd=’‘19’’ then a.subsid end) y19,
count(case when a.create_dd=’‘20’’ then a.subsid end) y20,
count(case when a.create_dd=’‘21’’ then a.subsid end) y21,
count(case when a.create_dd=’‘22’’ then a.subsid end) y22,
count(case when a.create_dd=’‘23’’ then a.subsid end) y23,
count(case when a.create_dd=’‘24’’ then a.subsid end) y24,
count(case when a.create_dd=’‘25’’ then a.subsid end) y25,
count(case when a.create_dd=’‘26’’ then a.subsid end) y26,
count(case when a.create_dd=’‘27’’ then a.subsid end) y27,
count(case when a.create_dd=’‘28’’ then a.subsid end) y28,
count(case when a.create_dd=’‘29’’ then a.subsid end) y29,
count(case when a.create_dd=’‘30’’ then a.subsid end) y30,
count(case when a.create_dd=’‘31’’ then a.subsid end) y31,
count(distinct a.create_dd) 发展日,
to_number(substr( ‘’’||P_DAY||’’’,7,2))-count(distinct a.create_dd) 未破零天数
from (select a.registerorgid,a.subsid,a.cycle,a.create_dd
from XXXX.sybb’||v_monsr||‘shqd_ta_fha a
union all
select a.registerorgid,a.subsid,a.cycle,a.create_dd
from XXXX.sybb’||v_monsr||‘shqd_ta_cla a
union all
select a.recorgid registerorgid,a.subsid,a.cycle,a.create_dd
from XXXX.sybb’||v_monsr||‘shqd_ta_kd a
union all
select a.recorgid registerorgid,a.subsid,a.cycle,a.create_dd
from XXXX.sybb’||v_monsr||‘shqd_ta_st a
union all
select a.recorgid registerorgid,a.entityid subsid,a.cycle,a.create_dd
from XXXX.sybb’||v_monsr||’_shqd_ta_zdxsb a ) a
group by a.registerorgid ’ ;
execute immediate (SQL_STRING);

fan_drop_retable(upper(‘sybb_’||v_monsr||‘shqd_hzfh’),‘XXXX’);
SQL_STRING:='create table XXXX.sybb’||v_monsr||‘shqd_hzfh as
select ‘’’||P_DAY||’’’ 日期,a.*,’‘放号’’ 类型,nvl(b.总量,0) 总量,nvl(b.日均,0) 日均,
nvl(b.y01,0) y01,nvl(b.Y02,’‘0’’) Y02 ,nvl(b.Y03,’‘0’’) Y03 ,nvl(b.Y04,’‘0’’) Y04 ,
nvl(b.Y05,’‘0’’) Y05 ,nvl(b.Y06,’‘0’’) Y06 ,nvl(b.Y07,’‘0’’) Y07 ,nvl(b.Y08,’‘0’’) Y08 ,
nvl(b.Y09,’‘0’’) Y09 ,nvl(b.Y10,’‘0’’) Y10 ,nvl(b.Y11,’‘0’’) Y11 ,nvl(b.Y12,’‘0’’) Y12 ,
nvl(b.Y13,’‘0’’) Y13 ,nvl(b.Y14,’‘0’’) Y14 ,nvl(b.Y15,’‘0’’) Y15 ,nvl(b.Y16,’‘0’’) Y16 ,
nvl(b.Y17,’‘0’’) Y17 ,nvl(b.Y18,’‘0’’) Y18 ,nvl(b.Y19,’‘0’’) Y19 ,nvl(b.Y20,’‘0’’) Y20 ,
nvl(b.Y21,’‘0’’) Y21 ,nvl(b.Y22,’‘0’’) Y22 ,nvl(b.Y23,’‘0’’) Y23 ,nvl(b.Y24,’‘0’’) Y24 ,
nvl(b.Y25,’‘0’’) Y25 ,nvl(b.Y26,’‘0’’) Y26 ,nvl(b.Y27,’‘0’’) Y27 ,nvl(b.Y28,’‘0’’) Y28 ,
nvl(b.Y29,’‘0’’) Y29 ,nvl(b.Y30,’‘0’’) Y30 ,nvl(b.Y31,’‘0’’) Y31 ,nvl(b.发展日,’‘0’’) 发展日 ,
nvl(b.未破零天数,to_number(substr( ‘’’||P_DAY||’’’,7,2))) 未破零天数
from
(select * from XXXX.sybb’||v_monsr||‘shqd_ta a where a.name is not null ) a,
XXXX.sybb’||v_monsr||’_shqd_ta_fhz b
where a.orgid=b.registerorgid(+) ’ ;
execute immediate (SQL_STRING);

fan_drop_retable(upper(‘sybb_’||v_monsr||‘shqd_hzcl’),‘XXXX’);
SQL_STRING:='create table XXXX.sybb’||v_monsr||‘shqd_hzcl as
select ‘’’||P_DAY||’’’ 日期,a.*,’‘存量’’ 类型,nvl(b.总量,0) 总量,nvl(b.日均,0) 日均,
nvl(b.y01,0) y01,nvl(b.Y02,’‘0’’) Y02 ,nvl(b.Y03,’‘0’’) Y03 ,nvl(b.Y04,’‘0’’) Y04 ,
nvl(b.Y05,’‘0’’) Y05 ,nvl(b.Y06,’‘0’’) Y06 ,nvl(b.Y07,’‘0’’) Y07 ,nvl(b.Y08,’‘0’’) Y08 ,
nvl(b.Y09,’‘0’’) Y09 ,nvl(b.Y10,’‘0’’) Y10 ,nvl(b.Y11,’‘0’’) Y11 ,nvl(b.Y12,’‘0’’) Y12 ,
nvl(b.Y13,’‘0’’) Y13 ,nvl(b.Y14,’‘0’’) Y14 ,nvl(b.Y15,’‘0’’) Y15 ,nvl(b.Y16,’‘0’’) Y16 ,
nvl(b.Y17,’‘0’’) Y17 ,nvl(b.Y18,’‘0’’) Y18 ,nvl(b.Y19,’‘0’’) Y19 ,nvl(b.Y20,’‘0’’) Y20 ,
nvl(b.Y21,’‘0’’) Y21 ,nvl(b.Y22,’‘0’’) Y22 ,nvl(b.Y23,’‘0’’) Y23 ,nvl(b.Y24,’‘0’’) Y24 ,
nvl(b.Y25,’‘0’’) Y25 ,nvl(b.Y26,’‘0’’) Y26 ,nvl(b.Y27,’‘0’’) Y27 ,nvl(b.Y28,’‘0’’) Y28 ,
nvl(b.Y29,’‘0’’) Y29 ,nvl(b.Y30,’‘0’’) Y30 ,nvl(b.Y31,’‘0’’) Y31 ,nvl(b.发展日,’‘0’’) 发展日 ,
nvl(b.未破零天数,to_number(substr( ‘’’||P_DAY||’’’,7,2))) 未破零天数
from
(select * from XXXX.sybb’||v_monsr||‘shqd_ta a where a.name is not null ) a,
XXXX.sybb’||v_monsr||’_shqd_ta_clz b
where a.orgid=b.registerorgid(+) ’ ;
execute immediate (SQL_STRING);

fan_drop_retable(upper(‘sybb_’||v_monsr||‘shqd_hzkd’),‘XXXX’);
SQL_STRING:='create table XXXX.sybb’||v_monsr||‘shqd_hzkd as
select ‘’’||P_DAY||’’’ 日期,a.*,’‘宽带’’ 类型,nvl(b.总量,0) 总量,nvl(b.日均,0) 日均,
nvl(b.y01,0) y01,nvl(b.Y02,’‘0’’) Y02 ,nvl(b.Y03,’‘0’’) Y03 ,nvl(b.Y04,’‘0’’) Y04 ,
nvl(b.Y05,’‘0’’) Y05 ,nvl(b.Y06,’‘0’’) Y06 ,nvl(b.Y07,’‘0’’) Y07 ,nvl(b.Y08,’‘0’’) Y08 ,
nvl(b.Y09,’‘0’’) Y09 ,nvl(b.Y10,’‘0’’) Y10 ,nvl(b.Y11,’‘0’’) Y11 ,nvl(b.Y12,’‘0’’) Y12 ,
nvl(b.Y13,’‘0’’) Y13 ,nvl(b.Y14,’‘0’’) Y14 ,nvl(b.Y15,’‘0’’) Y15 ,nvl(b.Y16,’‘0’’) Y16 ,
nvl(b.Y17,’‘0’’) Y17 ,nvl(b.Y18,’‘0’’) Y18 ,nvl(b.Y19,’‘0’’) Y19 ,nvl(b.Y20,’‘0’’) Y20 ,
nvl(b.Y21,’‘0’’) Y21 ,nvl(b.Y22,’‘0’’) Y22 ,nvl(b.Y23,’‘0’’) Y23 ,nvl(b.Y24,’‘0’’) Y24 ,
nvl(b.Y25,’‘0’’) Y25 ,nvl(b.Y26,’‘0’’) Y26 ,nvl(b.Y27,’‘0’’) Y27 ,nvl(b.Y28,’‘0’’) Y28 ,
nvl(b.Y29,’‘0’’) Y29 ,nvl(b.Y30,’‘0’’) Y30 ,nvl(b.Y31,’‘0’’) Y31 ,nvl(b.发展日,’‘0’’) 发展日 ,
nvl(b.未破零天数,to_number(substr( ‘’’||P_DAY||’’’,7,2))) 未破零天数
from
(select * from XXXX.sybb’||v_monsr||‘shqd_ta a where a.name is not null ) a,
XXXX.sybb’||v_monsr||’_shqd_ta_kdz b
where a.orgid=b.registerorgid(+) ’ ;
execute immediate (SQL_STRING);

fan_drop_retable(upper(‘sybb_’||v_monsr||‘shqd_hzst’),‘XXXX’);
SQL_STRING:='create table XXXX.sybb’||v_monsr||‘shqd_hzst as
select ‘’’||P_DAY||’’’ 日期,a.*,’‘生态’’ 类型,nvl(b.总量,0) 总量,nvl(b.日均,0) 日均,
nvl(b.y01,0) y01,nvl(b.Y02,’‘0’’) Y02 ,nvl(b.Y03,’‘0’’) Y03 ,nvl(b.Y04,’‘0’’) Y04 ,
nvl(b.Y05,’‘0’’) Y05 ,nvl(b.Y06,’‘0’’) Y06 ,nvl(b.Y07,’‘0’’) Y07 ,nvl(b.Y08,’‘0’’) Y08 ,
nvl(b.Y09,’‘0’’) Y09 ,nvl(b.Y10,’‘0’’) Y10 ,nvl(b.Y11,’‘0’’) Y11 ,nvl(b.Y12,’‘0’’) Y12 ,
nvl(b.Y13,’‘0’’) Y13 ,nvl(b.Y14,’‘0’’) Y14 ,nvl(b.Y15,’‘0’’) Y15 ,nvl(b.Y16,’‘0’’) Y16 ,
nvl(b.Y17,’‘0’’) Y17 ,nvl(b.Y18,’‘0’’) Y18 ,nvl(b.Y19,’‘0’’) Y19 ,nvl(b.Y20,’‘0’’) Y20 ,
nvl(b.Y21,’‘0’’) Y21 ,nvl(b.Y22,’‘0’’) Y22 ,nvl(b.Y23,’‘0’’) Y23 ,nvl(b.Y24,’‘0’’) Y24 ,
nvl(b.Y25,’‘0’’) Y25 ,nvl(b.Y26,’‘0’’) Y26 ,nvl(b.Y27,’‘0’’) Y27 ,nvl(b.Y28,’‘0’’) Y28 ,
nvl(b.Y29,’‘0’’) Y29 ,nvl(b.Y30,’‘0’’) Y30 ,nvl(b.Y31,’‘0’’) Y31 ,nvl(b.发展日,’‘0’’) 发展日 ,
nvl(b.未破零天数,to_number(substr( ‘’’||P_DAY||’’’,7,2))) 未破零天数
from
(select * from XXXX.sybb’||v_monsr||‘shqd_ta a where a.name is not null ) a,
XXXX.sybb’||v_monsr||’_shqd_ta_stz b
where a.orgid=b.registerorgid(+) ’ ;
execute immediate (SQL_STRING);

fan_drop_retable(upper(‘sybb_’||v_monsr||‘shqd_hz5G’),‘XXXX’);
SQL_STRING:='create table XXXX.sybb’||v_monsr||‘shqd_hz5G as
select ‘’’||P_DAY||’’’ 日期,a.*,’‘5G终端’’ 类型,nvl(b.总量,0) 总量,nvl(b.日均,0) 日均,
nvl(b.y01,0) y01,nvl(b.Y02,’‘0’’) Y02 ,nvl(b.Y03,’‘0’’) Y03 ,nvl(b.Y04,’‘0’’) Y04 ,
nvl(b.Y05,’‘0’’) Y05 ,nvl(b.Y06,’‘0’’) Y06 ,nvl(b.Y07,’‘0’’) Y07 ,nvl(b.Y08,’‘0’’) Y08 ,
nvl(b.Y09,’‘0’’) Y09 ,nvl(b.Y10,’‘0’’) Y10 ,nvl(b.Y11,’‘0’’) Y11 ,nvl(b.Y12,’‘0’’) Y12 ,
nvl(b.Y13,’‘0’’) Y13 ,nvl(b.Y14,’‘0’’) Y14 ,nvl(b.Y15,’‘0’’) Y15 ,nvl(b.Y16,’‘0’’) Y16 ,
nvl(b.Y17,’‘0’’) Y17 ,nvl(b.Y18,’‘0’’) Y18 ,nvl(b.Y19,’‘0’’) Y19 ,nvl(b.Y20,’‘0’’) Y20 ,
nvl(b.Y21,’‘0’’) Y21 ,nvl(b.Y22,’‘0’’) Y22 ,nvl(b.Y23,’‘0’’) Y23 ,nvl(b.Y24,’‘0’’) Y24 ,
nvl(b.Y25,’‘0’’) Y25 ,nvl(b.Y26,’‘0’’) Y26 ,nvl(b.Y27,’‘0’’) Y27 ,nvl(b.Y28,’‘0’’) Y28 ,
nvl(b.Y29,’‘0’’) Y29 ,nvl(b.Y30,’‘0’’) Y30 ,nvl(b.Y31,’‘0’’) Y31 ,nvl(b.发展日,’‘0’’) 发展日 ,
nvl(b.未破零天数,to_number(substr( ‘’’||P_DAY||’’’,7,2))) 未破零天数
from
(select * from XXXX.sybb’||v_monsr||‘shqd_ta a where a.name is not null ) a,
XXXX.sybb’||v_monsr||’_shqd_ta_zdxsz b
where a.orgid=b.registerorgid(+) ’ ;
execute immediate (SQL_STRING);

fan_drop_retable(upper(‘sybb_’||v_monsr||‘shqd_hzzo’),‘XXXX’);
SQL_STRING:='create table XXXX.sybb’||v_monsr||‘shqd_hzzo as
select ‘’’||P_DAY||’’’ 日期,a.*,’‘合并’’ 类型,nvl(b.总量,0) 总量,nvl(b.日均,0) 日均,
nvl(b.y01,0) y01,nvl(b.Y02,’‘0’’) Y02 ,nvl(b.Y03,’‘0’’) Y03 ,nvl(b.Y04,’‘0’’) Y04 ,
nvl(b.Y05,’‘0’’) Y05 ,nvl(b.Y06,’‘0’’) Y06 ,nvl(b.Y07,’‘0’’) Y07 ,nvl(b.Y08,’‘0’’) Y08 ,
nvl(b.Y09,’‘0’’) Y09 ,nvl(b.Y10,’‘0’’) Y10 ,nvl(b.Y11,’‘0’’) Y11 ,nvl(b.Y12,’‘0’’) Y12 ,
nvl(b.Y13,’‘0’’) Y13 ,nvl(b.Y14,’‘0’’) Y14 ,nvl(b.Y15,’‘0’’) Y15 ,nvl(b.Y16,’‘0’’) Y16 ,
nvl(b.Y17,’‘0’’) Y17 ,nvl(b.Y18,’‘0’’) Y18 ,nvl(b.Y19,’‘0’’) Y19 ,nvl(b.Y20,’‘0’’) Y20 ,
nvl(b.Y21,’‘0’’) Y21 ,nvl(b.Y22,’‘0’’) Y22 ,nvl(b.Y23,’‘0’’) Y23 ,nvl(b.Y24,’‘0’’) Y24 ,
nvl(b.Y25,’‘0’’) Y25 ,nvl(b.Y26,’‘0’’) Y26 ,nvl(b.Y27,’‘0’’) Y27 ,nvl(b.Y28,’‘0’’) Y28 ,
nvl(b.Y29,’‘0’’) Y29 ,nvl(b.Y30,’‘0’’) Y30 ,nvl(b.Y31,’‘0’’) Y31 ,nvl(b.发展日,’‘0’’) 发展日 ,
nvl(b.未破零天数,to_number(substr( ‘’’||P_DAY||’’’,7,2))) 未破零天数
from
(select * from XXXX.sybb’||v_monsr||‘shqd_ta a where a.name is not null ) a,
XXXX.sybb’||v_monsr||’_shqd_tsxz b
where a.orgid=b.registerorgid(+) ’ ;
execute immediate (SQL_STRING);

SQL_STRING:=‘delete from XXXX.sybb_shqd_hzzo a where a.日期=’’’||P_DAY||’’’ ’ ;
execute immediate (SQL_STRING);
commit;

SQL_STRING:=‘insert into XXXX.sybb_shqd_hzzo
select * from XXXX.sybb_’||v_monsr||‘shqd_hzzo a
union all
select * from XXXX.sybb’||v_monsr||‘shqd_hzfh a
union all
select * from XXXX.sybb’||v_monsr||‘shqd_hzcl a
union all
select * from XXXX.sybb’||v_monsr||‘shqd_hzkd a
union all
select * from XXXX.sybb’||v_monsr||‘shqd_hzst a
union all
select * from XXXX.sybb’||v_monsr||’_shqd_hz5G a ’ ;
execute immediate (SQL_STRING);
commit;

szc_1985
关注
专栏目录
【SQL】电商用户行为分析
linglish的博客
05-04 1854
一、项目背景及目的 1.1 项目背景 移动互联网企业从粗放式到精细化运营管理过程中，需要结合市场、渠道、用户行为等数据分析，对用户开展有针对性的运营活动，提供个性化、差异化的运营策略，以实现运营业务指标。本项目利用sql对淘宝用户行为数据进行分析，通过用户行为分析业务问题，提供针对性的运营策略。 1.2 项目目的 通过对淘宝用户行为数据分析，为以下问题提供解释和改进建议： 1、分析用户使用APP过程中的常见电商分析指标，建立用户行为转化漏斗模型，确定各个环节的流失率，找到需要改进的环节 2、研究用
SQL-DAY 7（SQL查询语句的应用案例：汽车新销售）
Fan20190515的博客
12-06 1285
文章目录一、涉及业务介绍二、涉及业务数据及字典三、需求与代码实现 一、涉及业务介绍   某头部汽车新零售企业立足下沉市场，通过网络渠道和品牌广告获取大量汽车销售线索，并借助大量地面销售在线下门店完成客户成交孵化，该企业最终依靠自建供应链建立的护城河来赚取采购差价，同时也通过给客户提供低首付金融租赁产品来赚取金融费用。该公司商业分析师需要从数据层面去驱动投放团队去做效率优化，以助力业务正常健康发展。 头部汽车：top级，行业排名靠前 下沉市场：三四线城市及以下消费市场 网络渠道：汽车之家、懂车帝、易车等 品
数据库请求来源统计
渔夫数据库笔记
01-07 817
数据库请求来源统计
分类统计数据库数据
Jackia的专栏
08-23 873
/**double 数据类型*/ private static final String STR_DOUBLE="double";  /**INT 数据类型*/ private static final String STR_INT="int";  /**long 数据类型*/ private static final String STR_LONG="long";  /**标志位*/ priva
列式数据库~关于对统计数据库的选型
weixin_33887443的博客
08-09 450
简介:今天咱们聊聊针对统计数据的选项标准 具体 : 统计数据库你需要关注的几个指标 1 千万级别以上表的查询效率和压缩效率 2 数据类型与关系型数据库的差异性 3 标准SQL语法的支持程度和 数据库函数的支持程度 4 集群架构的可扩展性和稳定性 5 运维成本和程序适用性 转载于:https://www.cnblogs.com...
数据的查询、汇总 、统计和分析
ITdada的专栏
06-25 8072
8.11. 数据分组小计 利用GROUP BY子句，可以根据一个或多个组的值将查询中的数据记录分组。 1.        计算出员工“飞狐工作室”表中，各个部门的薪资最高值、薪资最小值、薪资平均值及人数。 /* 档案名称: Demo956.sql */ USE NorthwindSQL   SELECT 部门,        COUNT(*) AS 部门员工人数,
每个渠道销售情况统计sql
jalu的博客
03-15 2077
select a.member_id,a.share_channel,sum(a.share_PV),sum(a.share_point),count(b.my_share_id),sum(order_amount),sum(order_brokerage) from my_share a, my_share_order b where a.my_share_id=b.my_share_id
【实战】淘宝电商用户行为分析——SQL
Bsienwuw的博客
06-02 1507
项目实战
server sql 分组 去重 字符串拼接_SQL初级数据分析（基于Microsoft Access）
weixin_39541681的博客
12-20 692
一、数据库与SQL1、数据库介绍数据库(Database)是按照数据接口来组织、存储和管理数据的仓库。通过数据库中的各种对象，进行记录、处理、分析各种数据。常用数据库：OracleSQL ServerMySQLAccess2、Access数据库2.1、Microsoft Office办公软件重要组成部分，一种关系数据管理系统软件。存储、处理、分析数据，数据处理功能更强大，数据量较大(大于几十万)时...
基于SQL的淘宝用户行为分析报告
Rachel_LONG的博客
07-19 1403
一、分析背景 二、分析目的 三、理解数据 数据来源：阿里天池-User Behavior Data from Taobao for Recommendation 数据集介绍：本数据集包含了2017年11月25日至2017年12月3日之间，有行为的约一百万随机用户的所有行为（行为包括点击、购买、加购、喜欢）。数据集的每一行表示一条用户行为，由用户ID、商品ID、商品类目ID、行为类型和时间戳组成，并以逗号分隔。关于数据集中每一列的详细描述如下： 列名称 说明 用户ID 整数类型，序列化后的用户
mysql渠道统计,Mysql 统计查询
weixin_36486277的博客
03-18 149
SELECT ub.telphone,SUM(IF(b.type = 1 AND b.level = 1, 1, 0)) AS type11,SUM(IF(b.type = 1 AND b.level = 2, 1, 0)) AS type12,SUM(IF(b.type = 2 AND b.level = 1, 1, 0)) AS type21,SUM(IF(b.type = 2 AND b.l...
关于字符和数字类型的索引,Oracle如何实现内部自动转换以及索引使用的验证测试
11-29 4180
关于字符和数字类型的索引,Oracle如何实现内部自动转换以及索引使用的验证测试
Server U 的使用
weixin_33975951的博客
11-20 1118
FTP服务与FTP软件基础知识　　共享下载站，即我们所说的FTP服务器，FTP是英文File Transfer Protocol的缩写，中文意思是文件传输协议。用户通过FTP协议能够在两台联网的计算机之间相互传递文件，它是互联网上载递文件最主要的方法。　　FTP服务器是互联网上提供FTP 提供一定存储空间的计算机，它可以是专用服务器，也可以是个人计算机。当它提供这项服务后，用...
将手机号码中间四位换成****的方法
WangMoBei的博客
08-15 2177
将手机号码中间四位换成****的方法 方式一、 使用substr从第四位开始往后截取四位，然后使用replace将截取的四位替换为**** SELECT REPLACE(serv_number, SUBSTR(serv_number,4,4)'****') AS serv_number FROM test; 方式二、 首先使用substr截取到总长的-8，然后拼接****，最后拼接上最后四位，最后四位使用substr进行截取 SELECT SUBSTR(serv_number,1,(serv_numbe
oracle中怎样用游标统计不同字各自出现次数,Oracle用游标分解号码次数
weixin_34731498的博客
04-03 176
Oracle用游标分解号码次数drop table tb_wjf_xh_dg100_50_tmp4 purge;create table tb_wjf_xh_dg100_50_tmp4(servnumbervarchar(11));declarevv_cusor_servnumbervarchar2(32);vv_cusor_lost_cnt integer;vv_servnumber...
HiveSQL各渠道1、7、30日流量统计
asd623444055的博客
06-17 1246
HiveSQL各渠道1、7、30日流量统计
SQL Server存储过程基础语法详解
本文档深入介绍了SQL Server存储过程的基本语法，对于那些已经掌握了SQL语言基础的读者来说，是一份实用的参考材料。首先，我们来详细探讨以下几个关键知识点： 1. 定义变量： - 在SQL Server存储过程中，变量是...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值