经典的标量子查询

explain plan for ( select 'C10927' as YXJGDM, --银行机构代码\
           '20110213000003' as JRXKZH, --金融许可证号
           a.SIGN_ORG as NBJGH, --内部机构号
           case
             when substr(b.product_name, 1, 3) = '如意宝' and
                  substr(a.cust_no, 1, 1) = '1' then
              '219'
             when substr(b.product_name, 1, 3) = '如意宝' and
                  substr(a.cust_no, 1, 1) <> '1' then
              '218'
             else
              '40605'
           end as MXKMBH, --明细科目编号
           c.org_name as YXJGMC, --银行机构名称
           case
             when substr(b.product_name, 1, 3) = '如意宝' and
                  substr(a.cust_no, 1, 1) = '1' then
              '个人如意宝存款'
             when substr(b.product_name, 1, 3) = '如意宝' and
                  substr(a.cust_no, 1, 1) <> '1' then