CREATE OR REPLACE PROCEDURE GENERATE_PASSWORD IS
        I NUMBER ;
BEGIN
        I := 1 ;
        LOOP
            INSERT INTO PASSWORDS(USER_PASSWORD) VALUES(TO_CHAR(DBMS_RANDOM.string('X', 5)));
            I := I+1 ;
        EXIT WHEN(I>1000) ;
END LOOP ;
END;
/

------------------------generate password---------------------------------

CREATE OR REPLACE PROCEDURE GENERATE_PREPAID_NUM IS
        I NUMBER ;
BEGIN
        I := 1 ;
        LOOP
            INSERT INTO AVAILABLE_PREPAID_SIM(SIM_NO) VALUES('019' || TO_CHAR(FLOOR(DBMS_RANDOM.VALUE(11111111,55555555))));
            I := I+1 ;
        EXIT WHEN(I>1000) ;
END LOOP ;
END;
/
-----------------------GENERATE AVAILABLE PREPAID NO___________________

CREATE OR REPLACE PROCEDURE GENERATE_POSTPAID_NUM IS
        I NUMBER ;
BEGIN
        I := 1 ;
        LOOP
            INSERT INTO AVAILABLE_POSTPAID_SIM(SIM_NO) VALUES('019' || TO_CHAR(FLOOR(DBMS_RANDOM.VALUE(66666666,99999999))));
            I := I+1 ;
        EXIT WHEN(I>1000) ;
END LOOP ;
END;
/

-----------------------GENERATE AVAILABLE POSTPAID NO_____________________