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: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
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 10.2.0.4 CPU24 Windows 64Bit
> Client:
> 10.2.0.4 CPU24 Windows 32bit
>
> I haven't researched this yet, but I'm curious why this might be happening.
>
>
Other related posts:
