... from dual;
-- yields values between 0 and 1
select dbms_random.value(1,1000) myAlias from dual;
-- yields number between 1 and 1000
select dbms_random.string('U', 10) myAlias from dual;
-- ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.