Hi,
I would like to insert even numbers by procedure in compartment 1 to 100.
I tried but it doesn't work:
CREATE TABLE numbers(number INT);
/
SET SERVEROUTPUT ON
/
CREATE OR REPLACE PROCEDURE insert_even IS
p_od NUMBER:=1;
p_do NUMBER:=100;
BEGIN
LOOP
p_od:=p_od+1;
IF mod(number,2)=0
then
INSERT INTO numbers values(number);
exit when p_od=p_do;
end if;
end loop;
end;
Thanks for advance