Re: Here's a wierd one for you (SQL with DBMS_RANDOM.VALUE)

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: ChrisDavid.Taylor@xxxxxxxxxxxxxxx
  • Date: Wed, 28 Apr 2010 10:58:25 -0700

This seems to work:

with rval as (
   select trunc(dbms_random.value(1,500)) random_int
   from dual
select r.random_int, t.*
from test1 t, rval r
where t.val1 = r.random_int

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog:
Home Page:

On Wed, Apr 28, 2010 at 7:40 AM, Taylor, Chris David <
ChrisDavid.Taylor@xxxxxxxxxxxxxxx> wrote:

> (First one didn't seem to go through to the list - resending as plain txt)
> DB Version:
> Server CPU24 Windows 64Bit
> Client:
> CPU24 Windows 32bit
> I haven't researched this yet, but I'm curious why this might be happening.

Other related posts: