Oracle Create Million Row Table With Unique ID

oracle_create_million_row_table_with_id.sql

drop table million;
drop sequence million_sequence;

create table million
(
    id number,
    type varchar2(50),
    constraint million_id_pk primary key (id)
);

create sequence million_sequence start with 1 nocycle;

declare
    rows_inserted number := 0;
begin
    loop
        insert into million(id, type)
        values(million_sequence.nextval, dbms_random.string('U', 1));
        rows_inserted := rows_inserted + 1;
        exit when rows_inserted = 1000000;
    end loop;
    commit;
end;
/