专注于互联网--专注于架构

oracle10.2.0.4:dbms_random在Oracle 10.2.0.4下的bug

Test Case： ＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋＋ CREATE TABLE TestCode ( ID VARCHAR2(5), VAL NUMBER(1) ); select * from ( select rownum id, decode(sign(dbms_random.value-0.9),-1,0,1) val from dual connect by rownum<=100 ) where val>0; insert into testcode select * from ( select [阅读全文] [PDF]