Force randomize within a set of numbers
From: CrazyKarma <skalki_at_gmail.com>
Date: Thu, 3 Dec 2009 14:01:52 -0800 (PST)
Message-ID: <31c26a4b-3130-43c5-b311-77dc9ad4d5a1_at_v7g2000pro.googlegroups.com>
Here is the last one for this week..I guess :)
Date: Thu, 3 Dec 2009 14:01:52 -0800 (PST)
Message-ID: <31c26a4b-3130-43c5-b311-77dc9ad4d5a1_at_v7g2000pro.googlegroups.com>
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