DBMS_RANDOM

• 이 패키지는 랜덤 값을 생성하는데 사용한다.

SQL> select dbms_random.random from dual;
SQL> select dbms_random.value(1,10000) from dual;
SQL> select trunc(dbms_random.value(1,10000)) from dual;
SQL> select level from dual connect by level <= 10  order by dbms_random.random;

• 테스트는 다음과 같다.

SQL >select dbms_random.random from dual;

    RANDOM
----------
 253530142

SQL >select dbms_random.value(1,10000) from dual;

DBMS_RANDOM.VALUE(1,10000)
--------------------------
                2931.38688

SQL >select trunc(dbms_random.value(1,10000)) from dual;

TRUNC(DBMS_RANDOM.VALUE(1,10000))
---------------------------------
                             5172

SQL >select level from dual connect by level <= 10
order by dbms_random.random;
  2
     LEVEL
----------
         9
         2
         3
        10
         7
         4
         5
         8
         1
         6

10 rows selected.