Re: random in PL/SQL

From: Sybrand Bakker <oradba_at_sybrandb.demon.nl>
Date: Sat, 15 Dec 2001 20:27:55 +0100
Message-ID: <vv8n1uk2grj3fg7u7lcudkmlu2vu2kka92@4ax.com>

On Sat, 15 Dec 2001 19:56:50 +0100, Jan Eliasen <eliasen_at_cs.auc.dk> wrote:

>Hi there.
>
>I can't find a random function in PL/SQL - can that be true? I've searched
>through all the documentation I could find.
>
>So what do I do if I want a random number between 18 and 100?

Use the dbms_random package when running 8.1.5 and higher, and use http://tahiti.oracle.com as a search engine for the doco.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Dec 15 2001 - 13:27:55 CST