福彩如何控制不重复？

显示全部楼层 · 2013-8-8 14:01:23

SELECT 'Red Ball#' || ROWNUM AS RED_BALL, Val
FROM (
SELECT trunc(dbms_random.value(1, 34)) AS Val
from dual
connect by level >
select round(dbms_random.value(1,34)) into random_item(i) from dual;

if i > 1 then
FOR j IN 1 .. i-1 LOOP

if random_item(j) = random_item(i) then

--dbms_output.put_line('Again:'||i||'--Item_Number--I:'||random_item(i));

goto Again;

end if;
End Loop;
end if;

End Loop;
FOR j IN 1 .. random_item.count LOOP
dbms_output.put_line('Item_Number:'||random_item(j));
--min_item(random_item(j)) := 9999;
End Loop;
End;
/

http://www.techwind.net/thread-3284-1-1.html

千问 · 2013-8-8 14:01:23

select 'Red Ball #'||rownum||' '||n from (select level n from dual connect by level复制代码