create user master identified by master default tablespace "USERS" quota unlimited on "USERS";

grant connect, resource, dba to master;

create table product 
(prd_id number, 
 prd_name varchar2(50), 
 prd_value numeric(12,2), 
 constraint prd_id_pk primary key (prd_id));
 
create sequence prd_id_seq
start with 1
increment by 1;
 
create or replace procedure p_product
as
c number;
begin
c:=0;

for c in 1..100000 loop

insert into product values (prd_id_seq.nextval,'Product A'||c,  to_number(to_char(sysdate,'SS'),'9999D99')/3);
commit;
end loop;

end;
/