oracle_data--数据库文件.sql

福建博洋教育C/C++软件项目实战：POS收银系统

values ('CN000028', '绿帽子', '顶', '10次', 5, 3, 9998, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000029', '笔记本电脑', '台', '13寸', 6999, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000030', '统一排骨面', '袋', '5包', 7.8, 4, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000031', '黑人牙膏', '盒', '200g', 3, 1.8, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000032', '白人牙刷', '支', '35g', 2, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000033', '飘又柔', '瓶', '400ml', 20, 12, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000034', '黑又亮', '瓶', '400ml', 18, 11, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000035', '鸟牌洗衣粉', '袋', '200g', 3, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000036', '便餐', '盒', '自助', 5, 3, 99, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000037', '婴儿纸尿片', '张', '10片', 1, .7, 9994, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000038', '护舒宝', '条', '10包', 5, 3, 9998, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000039', '低级笔记本', '本', '16开', 1, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000040', '统一中国', '次', '2秒', 999, 4, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000041', '黄种人人牙膏', '盒', '200g', 3, 1.8, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000042', '印第安人牙刷', '支', '35g', 2, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000043', '粗又大玉米', '支', '高级', 20, 12, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000044', '白又嫩', '瓶', '400ml', 18, 11, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000045', '鸡牌洗衣粉', '袋', '200g', 3, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000046', '便当', '盒', '自助', 5, 3, 99, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000047', '少年纸尿片', '张', '10片', 1, .7, 9994, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000048', '宜而爽', '条', '10包', 5, 3, 9998, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000049', '黄历', '本', '16开', 10, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000050', '狗牌', '个', '10G', 99, 4, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000051', '杯子', '个', '200g', 3, 1.8, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000052', '大杯子', '支', '35g', 2, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000053', '特大杯子', '瓶', '400ml', 20, 12, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000054', '小杯子', '瓶', '400ml', 18, 11, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000055', '很小的杯子', '瓶', '400ml', 3, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000056', '非常小的杯子', '瓶', '400ml', 5, 3, 99, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000057', '中年纸尿片', '张', '10片', 1, .7, 9994, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000058', '小白兔奶糖', '条', '10包', 5, 3, 9998, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000059', '健身器材', '套', '12件组', 1000, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000060', '高级健身器材', '套', '18件组', 5000, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000061', '高露洁牙刷', '盒', '200g', 3, 1.8, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000062', '佳洁士牙线', '支', '35g', 2, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000063', '硝化甘油', '瓶', '400ml', 20, 12, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000064', '硫酸', '瓶', '400ml', 18, 11, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000065', '黑火药', '袋', '200g', 3, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000066', '成套工具', '盒', '自助', 5, 3, 99, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000067', '打印纸', '张', '10片', 1, .7, 9994, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000068', '某品牌香烟', '条', '10包', 5, 3, 9998, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000069', '高级笔记本电脑', '本', '12寸', 8999, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000070', '家居用品', '套', '10件组', 900, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000071', '枕头', '个', '200g', 30, 1.8, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000072', '佳洁士牙线', '支', '35g', 2, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000073', '牙签', '瓶', '100根', 20, 12, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000074', '泰迪熊', '个', '10KG', 180, 11, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000075', '黑巧克力', '盒', '200g', 30, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000076', '牛奶巧克力', '盒', '200g', 30, 3, 99, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000077', '杏仁巧克力', '盒子', '200g', 30, .7, 9994, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000078', '某知名品牌香烟', '条', '10包', 50, 3, 9998, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000079', 'XBOX', '套', '360', 2999, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000080', '枕头套', '套', '1个', 90, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000081', '席梦思', '床', '200g', 300, 1.8, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000082', '劣质牙线', '根', '假冒', 1, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000083', '劣质牙签', '瓶', '10根', 2, 12, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000084', '劣质泰迪熊', '个', '1假冒', 18, 11, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000085', '黑胡椒巧克力', '盒', '200g', 30, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000086', '难吃的巧克力', '盒', '200g', 3, 3, 99, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000087', '杏仁', '盒', '200g', 30, .7, 9994, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000088', '假冒香烟', '条', '10包', 5, 3, 9998, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000089', 'PS 3', '套', '360', 2999, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000090', '衣服', '套', '1个', 90, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000091', '寿衣', '套', '200g', 300, 1.8, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000092', '死人穿的衣服', '套', '高级', 1000, 100, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000093', '活人穿的高级衣服', '套', '高级', 200, 120, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000094', 'WINDOWS VISTA', '片', '假冒', 10, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000095', 'WINDOWS VISTA', '盒', '真货', 5000, 1000, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000096', 'WINDOWS 98', '盒', '别买', 300, 3, 99, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000097', 'AMD双核3800', '盒装', '性价比', 700, 600.7, 9994, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000098', 'INTER 迅驰 5250', '盒装', '乱贵', 1800, 1300, 9998, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000099', 'nVIDIA 6200 AGP', '显卡', '二手', 199, 100, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000100', 'NIKE鞋子', '双', '2个', 900, 800, 9999, 1);
commit;
prompt 100 records committed...
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000101', '高级书包', '个', '200g', 1300, 1.8, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000102', '低级书包', '个', '低级', 120, 100, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000103', '低级皮包', '个', '低级', 200, 120, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000104', '假LV包', '个', '假冒', 100, 19, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000105', 'TT风扇', '盒', '真货', 150, 100, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000106', '太阳眼镜', '盒', '黑', 300, 3, 99, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000107', '包包', '个', '吃的', 1, .7, 9994, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000108', '我的太阳', '骂人', '我日', 1800, 1300, 9998, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000109', '猴子的屁股', '对', '红的', 199, 100, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000110', 'ADIDAS鞋子', '双', '2个', 900, 800, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000111', '西装', '套', 'XL', 1300, 811.8, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000112', '高级西装', '套', '高级', 1720, 1100, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000113', '低级西装', '套', '洗坏', 100, 20, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000114', '假LV包', '个', '假冒', 100, 19, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000115', '高级TT风扇', '盒', '真货', 180, 100, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000116', '月亮眼镜', '盒', '金色', 300, 3, 99, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000117', '周经帖', '张', '每周', 1, .7, 9994, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000118', '炫耀贴', '张', '喷之', 10, 10, 9998, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000119', '猴子的屁股', '对', '特红', 199, 100, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000120', '很黄很暴力', '句', '张X凡', 10, 1, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000121', '很好很强大', '句', '天涯', 1300, 811.8, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000122', '最XXX，没有之一', '句', 'MOPer', 1720, 1100, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000123', '太平间公主', '句', '死了', 100, 20, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000124', '很爱很爱你', '的', '钱', 100, 19, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000125', '我想你的每一天', '都', '犯困', 150, 100, 9999, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000126', '牛仔玩具', '个', '很忙', 300, 3, 99, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000127', '我的笑话', '非常', '冷！', 1, .7, 9994, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000128', '从前有只企鹅', '叫', '豆豆', 10, 10, 9998, 1);
insert into PRODUCT (BAR_CODE, PRODUCT_NAME, UNIT, SPEC, SALE_PRICE, PURCHASE_PRICE, COUNT, DISCOUNT)
values ('CN000129', '后来它', '被打', '死了', 199, 100, 9999, 1);
commit;
prompt 129 records loaded
prompt Loading SALE...
insert into SALE (SALE_ID, TRANS_ID, STAFF_ID, SALE_DATE, GIVEN_SUM, REAL_SUM, SALE_MONEY, CHANGE, SALE_STATE)
values ('200808080733451232', '1232', '000001', to_date('08-08-2008 07:33:45', 'dd-mm-yyyy hh24:mi:ss'), 23, 7.5, 7.5, 15.5, 0);
insert into SALE (SALE_ID, TRANS_ID, STAFF_ID, SALE_DATE, GIVEN_SUM, REAL_SUM, SALE_MONEY, CHANGE, SALE_STATE)
values ('200808080745101233', '1233', '000001', to_date('08-08-2008 07:45:10', 'dd-mm-yyyy hh24:mi:ss'), 23, 5, 5, 18, 0);
commit;
prompt 2 records loaded
prompt Loading SALE_DETAIL...
prompt Table is empty
prompt Loading SALE_TMP...
insert into SALE_TMP (SALE_ID, STAFF_ID)
values ('200710071804050395', '000001');
insert into SALE_TMP (SALE_ID, STAFF_ID)
values ('200710071809340397', '000001');
commit;
prompt 2 records loaded
prompt Loading STAFF...
insert into STAFF (STAFF_ID, STAFF_NAME, STAFF_PWD, STAFF_TYPE, REMARK)
values ('000000', 'admin', '123456', 0, '销单与退货');
insert into STAFF (STAFF_ID, STAFF_NAME, STAFF_PWD, STAFF_TYPE, REMARK)
values ('000001', '江进龙', '123456', 2, '收银员');
insert into STAFF (STAFF_ID, STAFF_NAME, STAFF_PWD, STAFF_TYPE, REMARK)
values ('000002', 'manager', '123456', 1, '管理员');
insert into STAFF (STAFF_ID, STAFF_NAME, STAFF_PWD, STAFF_TYPE, REMARK)
values ('123123', '123', '123123', 1, ' ');
insert into STAFF (STAFF_ID, STAFF_NAME, STAFF_PWD, STAFF_TYPE, REMARK)
values ('070503', 'Shimmergloom', '070503', 1, 'Load Of Ring');
insert into STAFF (STAFF_ID, STAFF_NAME, STAFF_PWD, STAFF_TYPE, REMARK)
values ('123000', '1230', '123456', 1, '123456');
insert into STAFF (STAFF_ID, STAFF_NAME, STAFF_PWD, STAFF_TYPE, REMARK)
values ('123111', '111', 'sdafsd', 1, ' ');
insert into STAFF (STAFF_ID, STAFF_NAME, STAFF_PWD, STAFF_TYPE, REMARK)
values ('123222', '222', 'sdafsfasa', 2, '122222');
insert into STAFF (STAFF_ID, STAFF_NAME, STAFF_PWD, STAFF_TYPE, REMARK)
values ('123333', '333', '333333', 1, '123');
insert into STAFF (STAFF_ID, STAFF_NAME, STAFF_PWD, STAFF_TYPE, REMARK)
values ('123444', '444', '444444', 1, ' ');
insert into STAFF (STAFF_ID, STAFF_NAME, STAFF_PWD, STAFF_TYPE, REMARK)
values ('121555', '555', '55555556', 1, ' ');
insert into STAFF (STAFF_ID, STAFF_NAME, STAFF_PWD, STAFF_TYPE, REMARK)
values ('123466', '66', '66666666', 0, '213');
insert into STAFF (STAFF_ID, STAFF_NAME, STAFF_PWD, STAFF_TYPE, REMARK)
values ('123477', '777', '77777895a', 1, 'sad');
insert into STAFF (STAFF_ID, STAFF_NAME, STAFF_PWD, STAFF_TYPE, REMARK)
values ('123888', '12388', '321654', 2, '2222');
insert into STAFF (STAFF_ID, STAFF_NAME, STAFF_PWD, STAFF_TYPE, REMARK)
values ('321564', '321564', '321654897', 2, 'asdasd');
commit;
prompt 15 records loaded
prompt Enabling foreign key constraints for SALE_DETAIL...
alter table SALE_DETAIL enable constraint FK_D_R_SALE;
prompt Enabling triggers for PRODUCT...
alter table PRODUCT enable all triggers;
prompt Enabling triggers for SALE...
alter table SALE enable all triggers;
prompt Enabling triggers for SALE_DETAIL...
alter table SALE_DETAIL enable all triggers;
prompt Enabling triggers for SALE_TMP...
alter table SALE_TMP enable all triggers;
prompt Enabling triggers for STAFF...
alter table STAFF enable all triggers;
set feedback on
set define on
prompt Done.