Re: SQL*Plus random function
From: Eric Pierce <sac50216_at_saclink1.csus.edu>
Date: 1 Feb 1995 22:54:43 GMT
Message-ID: <3gp3fj$8b6_at_news.csus.edu>
Date: 1 Feb 1995 22:54:43 GMT
Message-ID: <3gp3fj$8b6_at_news.csus.edu>
Robert Gillespie (gillespr_at_osshe.edu) wrote:
: Does anyone know of a good pseudo random number function which can
: be constructed solely of existing SQL*Plus arithmetic functions?
:
: Something equivalent to rand() in the C stdlib.
Bambi Bellows recently posted more or less the following idea on the Oracle-L listserver:
Use a format mask with substring to get the minutes and/or seconds off the system date and concatenate it with a character string of your choice.
This was a solution to generating "near random" passwords, and may not work for your needs.
EP Received on Wed Feb 01 1995 - 23:54:43 CET