SELECT 랜덤하게

SELECT *

FROM 

(

    SELECT 'DD' COL FROM DUAL UNION ALL

    SELECT 'BB' COL FROM DUAL UNION ALL

    SELECT 'CC' COL FROM DUAL UNION ALL

    SELECT 'AA' COL FROM DUAL

)

ORDER BY DBMS_RANDOM.VALUE

;