生成随机五个不重复字母的字符串,参考SELECT REPLACE(TO_CHAR(WMSYS.WM_CONCAT(S)),',',''),--各版本通用的写法 LISTAGG(S,'')WITHIN GROUP(ORDER BY RN)--11g之后版本可以选择这样写 FROM( select chr(ascii('A')+ROWNUM-1) S,ROW_NUMBER()OVER(ORDER BY dbms_random.value) RN from dual connect by rownum<=26 )WHERE RN<=5;
REPLACE(TO_CHAR(WMSYS.WM_CONCAT(S)),',',''),--各版本通用的写法
LISTAGG(S,'')WITHIN GROUP(ORDER BY RN)--11g之后版本可以选择这样写
FROM(
select chr(ascii('A')+ROWNUM-1) S,ROW_NUMBER()OVER(ORDER BY dbms_random.value) RN from dual connect by rownum<=26
)WHERE RN<=5;