상품 목록을 불러올 더미데이터를 삽입해 보자.

더미데이터 생성기는 다음 아래 사이트에서 가면 자동으로  생성해 준다.

http://www.mockaroo.com/

 

다음 더미데이터는 필자가 임의로 만들었다.

insert into tbl_product(pseq, name, kind, price1, price2, price3, content, image) values(
product_seq.nextval, 'A남성운동화', '1', '40000', '50000', '10000', 'A남성운동화 입니다.', '1.jpg');
insert into tbl_product(pseq, name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval, '롱남성운동화', '1', 40000, 50000, 10000,'롱남성운동화 입니다.', '2.jpg', 'n');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval,  '스니커여성구두', '5', '15000', '20000', '5000', '스니커여성구두 입니다.', '48.jpg','n');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval,  'C여성운동화', '2', '5000', '5500', '500', 'C여성운동화 입니다.', '19.jpg', 'y');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval, '슬여성운동화', '2', '5000', '5500', '500', '슬여성운동화 입니다.', '20.jpg', 'y');
insert into tbl_product(pseq, name, kind, price1, price2, price3, content, image) values(
product_seq.nextval, 'A여성운동화', '2', '40000', '50000', '10000', 'A여성운동화 입니다.', '13.jpg');

insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values( 
product_seq.nextval, '힐남성운동화', '1', '10000', '12000', '2000', '힐남성운동화 힐', '3.jpg', 'n');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval, '롱여성구두', '4', 40000, 50000, 10000,'롱여성구두 입니다.', '38.jpg', 'n');


insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval,  'C남성운동화', '1', '5000', '5500', '500', 'C남성운동화 입니다.', '7.jpg', 'y');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval, '슬남성운동화', '1', '5000', '5500', '500', '슬남성운동화 입니다.', '8.jpg', 'y');

insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval, '슬리남성구두', '3', '5000', '5500', '500', '슬리남성구두 입니다.', '28.jpg', 'y');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval, '회색남성구두', '3', '10000', '12000', '2000', '회색남성구두', '29.jpg', 'n');

insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval,  '스니커남성구두', '5', '15000', '20000', '5000', '스니커남성구두 입니다.', '36.jpg','n');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval,  '샌남성운동화', '1', '5000', '5500', '500', '샌남성운동화 입니다.', '10.jpg','n');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval,  '스니커남성운동화', '5', '15000', '20000', '5000', '스니커남성운동화 입니다.', '11.jpg','n');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values( 
product_seq.nextval, '힐여성구두', '4', '10000', '12000', '2000', '힐여성구두 힐', '39.jpg', 'n');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval, '슬리여성구두', '4', '5000', '5500', '500', '슬리여성구두 입니다.', '40.jpg', 'y');

insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image) values(
product_seq.nextval, 'B남성운동화', '1', '12000', '18000', '6000', 'B남성운동화', '6.jpg');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval,  '샌여성구두', '4', '5000', '5500', '500', '샌여성구두 입니다.', '46.jpg','n');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval, '회색여성운동화', '2', '10000', '12000', '2000', '회색여성운동화', '17.jpg', 'n');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval, '슬리여성운동화', '2', '5000', '5500', '500', '슬리여성운동화 입니다.', '16.jpg', 'y');

insert into tbl_product(pseq, name, kind, price1, price2, price3, content, image) values(
product_seq.nextval, 'A여성구두', '4', '40000', '50000', '10000', 'A여성구두 입니다.', '37.jpg');
insert into tbl_product(pseq, name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval,  'C여성구두', '4', '5000', '5500', '500', 'C여성구두 입니다.', '43.jpg', 'y');


insert into tbl_product(pseq, name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval, '롱여성운동화', '2', 40000, 50000, 10000,'롱여성운동화 입니다.', '14.jpg', 'n');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values( 
product_seq.nextval, '힐여성운동화', '2', '10000', '12000', '2000', '힐여성운동화 힐', '15.jpg', 'n');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image) values(
product_seq.nextval,  '스여성구두', '4', '15000', '20000', '5000', '스여성구두 입니다.', '45.jpg');

insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image) values(
product_seq.nextval, 'B여성운동화', '2', '12000', '18000', '6000', 'B여성운동화', '18.jpg');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval,  '스니커남성운동화', '5', '15000', '20000', '5000', '스니커남성운동화 입니다.', '12.jpg','n');


insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval, '회색남성운동화', '1', '10000', '12000', '2000', '회색남성운동화', '5.jpg', 'n');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image) values(
product_seq.nextval,  '스여성운동화', '2', '15000', '20000', '5000', '스여성운동화 입니다.', '21.jpg');




insert into tbl_product(pseq, name, kind, price1, price2, price3, content, image) values(
product_seq.nextval, 'A남성구두', '3', '40000', '50000', '10000', 'A남성구두 입니다.', '25.jpg');
insert into tbl_product(pseq, name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval, '롱남성구두', '3', 40000, 50000, 10000,'롱남성구두 입니다.', '26.jpg', 'n');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values( 
product_seq.nextval, '힐남성구두', '3', '10000', '12000', '2000', '힐남성구두 힐', '27.jpg', 'n');



insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval, '슬여성구두', '4', '5000', '5500', '500', '슬여성구두 입니다.', '44.jpg', 'y');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image) values(
product_seq.nextval, 'B남성구두', '3', '12000', '18000', '6000', 'B남성구두', '30.jpg');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval,  'C남성구두', '1', '5000', '5500', '500', 'C남성구두 입니다.', '31.jpg', 'y');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval, '슬남성구두', '3', '5000', '5500', '500', '슬남성구두 입니다.', '32.jpg', 'y');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval,  '샌여성운동화', '2', '5000', '5500', '500', '샌여성운동화 입니다.', '22.jpg','n');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval,  '스니커여성운동화', '5', '15000', '20000', '5000', '스니커여성운동화 입니다.', '23.jpg','n');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval,  '스니커남성구두', '5', '15000', '20000', '5000', '스니커남성구두 입니다.', '35.jpg','n');

insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval, '슬리남성운동화', '1', '5000', '5500', '500', '슬리남성운동화 입니다.', '4.jpg', 'y');


insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval,  '스니커여성구두', '5', '15000', '20000', '5000', '스니커여성구두 입니다.', '47.jpg','n');

insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval, '회색여성구두', '4', '10000', '12000', '2000', '회색여성구두', '41.jpg', 'n');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image) values(
product_seq.nextval, 'B여성구두', '4', '12000', '18000', '6000', 'B여성구두', '42.jpg');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval,  '스니커여성운동화', '5', '15000', '20000', '5000', '스니커여성운동화 입니다.', '24.jpg','n');

insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image) values(
product_seq.nextval,  '스남성운동화', '1', '15000', '20000', '5000', '스남성운동화 입니다.', '9.jpg');

insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image) values(
product_seq.nextval,  '스남성구두', '3', '15000', '20000', '5000', '스남성구두 입니다.', '33.jpg');
insert into tbl_product(pseq,  name, kind, price1, price2, price3, content, image, bestyn) values(
product_seq.nextval,  '샌남성구두', '3', '5000', '5500', '500', '샌남성구두 입니다.', '34.jpg','n');


commit;