Force randomize within a set of numbers

From: CrazyKarma <>
Date: Thu, 3 Dec 2009 14:01:52 -0800 (PST)
Message-ID: <>

Here is the last one for this week..I guess :)

Is there way to force the randomize within a set of number in Oracle? Say I have a set of integers ( 2,8,6,5)
and I want to force randomize function to randomly pick within that set only.

I know about the DBMS_RANDOM package, sample and seed clause but none help what I need to do here.

any thoughts?

CK Received on Thu Dec 03 2009 - 16:01:52 CST

Original text of this message