CREATE TABLE Assignment2
 (Cl NUMBER(12));
DECLARE @firstLoop
SET @firstLoop = 1
    WHILE @firstloop<100000
    BEGIN
        INSERT INTO Assignment2.C1
        VALUES @firstloop
        @firstloop=@firstloop+100;
END;