DB/PLSQL
plsql random
냐옴
2013. 5. 30. 18:31
DECLARE
V_RET VARCHAR2(100);
BEGIN
FOR I IN 1..10
LOOP
V_RET := DBMS_RANDOM.VALUE(1, 10);
DBMS_OUTPUT.PUT_LINE(V_RET);
END LOOP;
END;
// output
8.983907832266700117045697426891695805
7.85138851818458197159926611283188386042
1.15776646610204195640170576336466009082
6.89453227669484520864497406123738919765
2.92422113684781021718794966809375193052
1.53399736142110573992925036854080351923
8.09751621393351335845076805508522738852
2.24796689544798407007445926425282739649
9.33763531106610743912681545933826238586
1.2239063232291398010054811607314076998