17,382
社区成员




create table t_temp(
col varchar2(10)
)
insert into t_temp values('P268');
insert into t_temp values('P267');
insert into t_temp values('P266');
commit;
SELECT WMSYS.WM_CONCAT(COL) FROM T_TEMP
select substr(max(sys_connect_by_path(col ,',')),2) arr
from (
select col ,row_number() over(order by col ) rn
from t_temp
)
start with rn=1
connect by rn-1=prior rn