oracle-Random Number acquisition

1, get 10-100 of data, retain two decimal places

Select Trunc (Dbms_random.value (10,100), 2) from dual;

2. Get 0-1 Decimals

Select Dbms_random.value from dual;

3. Get a random letter-3

Select Dbms_random.string (' x ', 3) from dual;

4. Get a random date

Select To_date (2454084+trunc (dbms_random. VALUE (0,365)), ' J ') from dual;

5. Generate a unique string

Select Sys_guid () from dual;

Application Examples:

Randomly generate test data for some fields of a table

Update AAA
Set

Zyl=trunc (Dbms_random.value (10,100), 2),
Cl=trunc (Dbms_random.value (10,100), 2),
Kccl=trunc (Dbms_random.value (10,100), 2),
Jjkccl=trunc (Dbms_random.value (10,100), 2),
Ncl=trunc (Dbms_random.value (10,100), 2),
Lcl=trunc (Dbms_random.value (10,100), 2)

oracle-Random Number acquisition