有些时候需要将输出的结果转为一行 然后在进行处理的时候可以用这个办法
DECLARE
CURSOR V_USERS IS
SELECT T.USERNAME FROM DBA_USERS T;

V_RET V_USERS%ROWTYPE;
V_RESULT VARCHAR2(30000);
BEGIN
V_RESULT := ‘’;
OPEN V_USERS;
LOOP
FETCH V_USERS INTO V_RET;

EXIT WHEN V_USERS%NOTFOUND;
V_RESULT :=V_RESULT||’’’’|| V_RET.USERNAME||’’’’ || ‘,’;
END LOOP;
CLOSE V_USERS;
PRINT(V_RESULT);
END;
/

https://eco.dameng.com