没有环境,不知道行不行,你可以试一下:
select substr(t1.c1,level,1) from (select to_char(id) c1,rownum rn from t) t1 connect by level<=length(t1.c1) and t1.rn=prior t1.rn and prior dbms_random.value is not null;
select substr(t1.c1,level,1) from (select to_char(id) c1,rownum rn from t) t1 connect by level<=length(t1.c1) and t1.rn=prior t1.rn and prior dbms_random.value is not null;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货