Oracle--長SQL

最新推荐文章于 2022-07-11 07:38:00 发布

DB王子様

最新推荐文章于 2022-07-11 07:38:00 发布

阅读量314

点赞数

本文链接：https://blog.csdn.net/u013736803/article/details/104636561

版权

本文详细介绍了在Oracle数据库中如何处理和优化长SQL查询，包括语法要点、性能调优技巧以及实战案例分析，帮助读者掌握高效管理复杂SQL的方法。

摘要由CSDN通过智能技术生成

SELECT
RQ_MNG.DIC.GET_DIC_NAME('RM','RM9040',mc.if_star) AS 客户类型,                                                               --客户类型
mc.cus_name AS 客户姓名,                                                                                                     --客户姓名
mc.m_phone AS 客户电话,                                                                                                      --客户电话
(SELECT RQ_MNG.STRAGG(CC.LAB_NAME)
                    FROM (SELECT CCL.CUS_LABEL
                            FROM CUST.C_CUST_LABEL CCL
                           WHERE CCL.CUS_NO = mc.cus_no
                             ANDCCL.COMP_NO = 'C11341') T,
                         CUST.C_LABEL CC
                   WHERE CC.CUS_LABEL = T.CUS_LABEL
                     ANDCC.COMP_NO = 'C11341') as 客户标签,
CASE MC.CHN_NO                                                                                                               --客户渠道
 WHEN '1807201045537300'THEN 'G'
 WHEN '1806121537018513'THEN '官网'
 WHEN '1804172042381277'THEN 'DT'
 WHEN '1805211618179134'THEN 'JQ'
 WHEN '1806121538558826'THEN '融360'
 WHEN '1809181009015157'THEN '阳光'
 WHEN '1804172043011282'THEN 'TT'
 WHEN '1804172043181284'THEN '转介绍'
 WHEN '1804172042541280'THEN 'YH'
 WHEN '1806121536028402'THEN 'FM102.6'
 WHEN '1806190849176417'THEN '地铁'
 WHEN '1804172043261285'THEN '老客户'
 WHEN '1808140921106548'THEN 'JH'
 WHEN '1809031101372998'THEN 'GJJ'
 WHEN '1806051050369017'THEN 'MS'
 WHEN '1804172042281276'THEN 'WL'
 WHEN '1807271138020835'THEN 'YZ'
 WHEN '1804081507197894'THEN '内部渠道'
 WHEN '1808031620284366'THEN 'LMD'
 WHEN '1808211707068822'THEN 'PG18.8'
 WHEN '1807181637354059'THEN '电梯'
 WHEN '1811131618208171'THEN 'FM92.5'
 WHEN '1806121536308409'THEN '公众号'
 WHEN '1809291027362545'THEN 'GZ'
 WHEN '1804172042441279'THEN 'PG&