??????????????????DBMS_RANDOM????CASE WHEN????·???￡?
???????????DBMS_RANDOM.RANDOM?????????????????????????????????????????10?????????????????????????????10????????
?????????????????????CASE WHEN??????????й?????
??????磬??????????????????“????”??“???”??“????”??“????”??“?人”???????????????????????????????????????Ρ?
??????????????????
????SQL> create table test(loc varchar2(2 char));
????Table created.
????????????????????SQL???
select case mod(abs(dbms_random.random)??5)
when 1 then '????'
when 2 then '???'
when 3 then '????'
when 4 then '????'
else '?人' end "LOC"
from dual;
?????????????test???loc???
begin
for i in 1..10 loop
insert into test values(case mod(abs(dbms_random.random)??5)
when 1 then '????'
when 2 then '???'
when 3 then '????'
when 4 then '????'
else '?人' end );
end loop;
end;
????????????????￡?
SQL> select * from test;
LOC
--------
?人
????
???
????
???
?人
????
???
?人
????
10 rows selected.