Oracle将多行内容整合到一行

在做一个邮件设置功能，由于数据库表设计者很蠢，导致查询起来很费劲，有的时候可能要将简单的查询根据条件不同执行很多次，很是让自己不开心。下面是一个与蠢人打交道的成功方案：

• 起初数据库里的数据是长这样的：

• 通过sql查询出来的结果变成了想要的结果：
  

sql：

select
            tmp1.host_address,tmp2.host_port,tmp3.email_user_name,tmp4.email_password,tmp5.accept_email_address,tmp6.publicity_is_send
        from
            (select
                wmsys.wm_concat (value) as host_address
            from
                t_sys_setup
            where
                data_type in ('mail_server'))tmp1,(select
                wmsys.wm_concat (value) as host_port
            from
                t_sys_setup
            where
                data_type in ('mail_port'))tmp2,(select
                wmsys.wm_concat (value) as email_user_name
            from
                t_sys_setup
            where
                data_type in ('mail_account'))tmp3,(select
                wmsys.wm_concat (value) as email_password
            from
                t_sys_setup
            where
                data_type in ('mail_pwd'))tmp4,(select
                wmsys.wm_concat (value) as accept_email_address
            from
                t_sys_setup
            where
                data_type in ('addressee'))tmp5,(select
                wmsys.wm_concat (value) as publicity_is_send
            from
                t_sys_setup
            where
                data_type in ('issendmail'))tmp6

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!