select GROUP_CONCAT(p_str SEPARATOR ';')
from (select 'aa' as p_str
from dual
union all
select 'bb' as p_str
from dual) mt;在这里把后面的分号替换成换行符 char(13),直接替换是报错的,有其它办法没?
from (select 'aa' as p_str
from dual
union all
select 'bb' as p_str
from dual) mt;在这里把后面的分号替换成换行符 char(13),直接替换是报错的,有其它办法没?
HEX()函数:返回十六进制值的字符串表示形式。注意:并不是十进制转化为十六进制数,而是转化为字符串
UNHEX() 函数: 每对十六进制数字转化为一个字符。select GROUP_CONCAT(p_str SEPARATOR HEX(13))
from (select 'aa' as p_str
from dual
union all
select 'bb' as p_str
from dual) mt;
from (select 'aa' as p_str
from dual
union al' at line 1