oracle怎么在数据拼接中文,Oracle 拼接列数据的方法

保存在这里，方便自己以后查看 (⊙_⊙) ╮(╯▽╰)╭

我们可以先这样创建一张需要的临时表(Role 表)：

select 'role_01' as role_id, 'admin' as role_category from dual

union all

select 'role_02' as role_id, 'admin' as role_category from dual

union all

select 'role_03' as role_id, 'normal' as role_category from dual

union all

select 'role_04' as role_id, 'normal' as role_category from dual

union all

select 'role_05' as role_id, 'normal' as role_category from dual

union all

select 'role_06' as role_id, 'normal' as role_category from dual

union all

select 'role_07' as role_id, 'normal' as role_category from dual

union all

select 'role_08' as role_id, 'normal' as role_category from dual

表结构：

现在我们要根据 role_category 分组，把相同 role_category 下的 role_id 连接起来，就是列 role_id 转成行，大家可能很容易想到使用 wm_concat() 方法来进行：

select role_category,

wm_concat(role_id) as role_id_list

from (

select 'role_01' as role_id, 'admin' as role_category from dual

union all

select 'role_02' as role_id, 'admin' as role_category from dual

union all

select 'role_03' as role_id, 'normal' as role_category from dual

union all

select 'role_04' as role_id, 'normal' as role_category from dual

union all

select 'role_05' as role_id, 'normal' as role_category from dual

union all

select 'role_06' as role_id, 'normal