my question is to all gurus i want to make application which is electronic balloting means i have create one table
create table ballot(s_no number(5),
CURSOR C1 IS SELECT id_card_number FROM ballot ORDER BY dbms_random.value;
FOR A IN C1 LOOP
FOR A IN 1..50000 LOOP
i know this code is not correct its only synchronizing id_card_number in text_field nothing else.
now in this table almost 5000 records and we have to choose one for them randomly means all reacords will be in loop/synchronize in text_field when we will click the button name will come out and will blink as winner.then rest of records will keep looping for 2nd winner. example code will be highly appreciated in both forms either oracle forms 6i or forms 10g.
plz need help little urgent..
Thanks in advance