bb.sql

来自「hibernate 简单的例子」· SQL 代码 · 共 503 行 · 第 1/3 页

insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (119, '2', to_date('15-03-2008 09:29:52', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '123456789', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (123, '2', to_date('15-03-2008 09:30:55', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '123456789', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (127, '2', to_date('15-03-2008 09:31:56', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '123456789', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (131, '2', to_date('15-03-2008 09:32:25', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '123456789', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (135, '2', to_date('15-03-2008 09:32:42', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '123456789', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (139, '2', to_date('15-03-2008 09:33:47', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '123456789', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (143, '2', to_date('15-03-2008 09:34:01', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '123456789', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (147, '2', to_date('15-03-2008 09:37:36', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '123456789', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (151, '2', to_date('15-03-2008 09:38:28', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '123456789', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (155, '2', to_date('15-03-2008 09:38:50', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '123456789', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (159, '2', to_date('15-03-2008 09:39:16', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '123456789', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (163, '2', to_date('15-03-2008 09:39:39', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '123456789', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (167, '2', to_date('15-03-2008 09:41:20', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '123456789', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (171, '2', to_date('15-03-2008 09:41:44', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '123456789', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (175, '2', to_date('15-03-2008 09:43:14', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '123456789', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (179, '2', to_date('15-03-2008 09:46:46', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '123456789', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (183, '2', to_date('15-03-2008 09:47:22', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '123456789', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (187, '2', to_date('15-03-2008 09:47:38', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '123456789', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (191, '2', to_date('15-03-2008 09:48:19', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '123456789', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (195, '2', to_date('15-03-2008 09:48:41', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '123456789', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (199, '2', to_date('15-03-2008 09:49:26', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '123456789', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (203, '2', to_date('15-03-2008 09:49:55', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '杰', '赵', '123456789', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (208, '204', to_date('15-03-2008 09:55:58', 'dd-mm-yyyy hh24:mi:ss'), 15600, '西安市', '西安市', '西安市', '陕西省', '71000', '中国', 'test', 'test', '西安市', '西安市', '西安市', '陕西省', '71000', '中国', 'test', 'test', '987654321', '2008-03-15', '银联', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (242, '204', to_date('15-03-2008 10:18:48', 'dd-mm-yyyy hh24:mi:ss'), 2300, 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', '西安市', '西安市', '西安市', '陕西省', '71000', '中国', 'test', 'test', '123456789', '2008-03-15', 'visa', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (245, '2', to_date('15-03-2008 10:30:32', 'dd-mm-yyyy hh24:mi:ss'), 4000, '西安市', '西安市', '西安市', '陕西省', '710065', '中国', '敏', '钱', '西安市', '西安市', '西安市', '陕西省', '71000', '中国', '杰', '赵', '123456789', '2008-03-15', 'visa', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (263, '2', to_date('15-03-2008 13:36:27', 'dd-mm-yyyy hh24:mi:ss'), 400, '西安市', '西安市', '西安市', '陕西省', '71000', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '71000', '中国', '杰', '赵', '123456789', '2008-03-15', 'visa', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (266, '2', to_date('15-03-2008 13:36:40', 'dd-mm-yyyy hh24:mi:ss'), 400, '西安市', '西安市', '西安市', '陕西省', '71000', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '71000', '中国', '杰', '赵', '123456789', '2008-03-15', 'visa', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (269, '204', to_date('15-03-2008 13:38:06', 'dd-mm-yyyy hh24:mi:ss'), 2000, '北京', '北京', '北京', '北京', '710065', '中国', '扬', '张', '西安市', '西安市', '西安市', '陕西省', '71000', '中国', 'test', 'test', '987654321', '2008-03-15', 'visa', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (272, '2', to_date('15-03-2008 14:18:39', 'dd-mm-yyyy hh24:mi:ss'), 300, '西安市', '西安市', '西安市', '陕西省', '71000', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '71000', '中国', '杰', '赵', '123456789', '2008-03-15', 'visa', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (275, '2', to_date('15-03-2008 14:20:27', 'dd-mm-yyyy hh24:mi:ss'), 300, '西安市', '西安市', '西安市', '陕西省', '71000', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '71000', '中国', '杰', '赵', '123456789', '2008-03-15', 'visa', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (278, '2', to_date('15-03-2008 14:20:58', 'dd-mm-yyyy hh24:mi:ss'), 300, '西安市', '西安市', '西安市', '陕西省', '71000', '中国', '杰', '赵', '西安市', '西安市', '西安市', '陕西省', '71000', '中国', '杰', '赵', '123456789', '2008-03-15', 'visa', null);
commit;
prompt 37 records loaded
prompt Loading LINEITEM...
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (95, 93, '4', 1, 400);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (95, 94, '7', 1, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (99, 98, '7', 1, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (99, 97, '4', 1, 400);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (103, 102, '7', 1, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (103, 101, '4', 1, 400);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (107, 106, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (107, 105, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (111, 109, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (111, 110, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (115, 113, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (115, 114, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (119, 118, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (119, 117, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (123, 122, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (123, 121, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (127, 126, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (127, 125, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (131, 129, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (131, 130, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (135, 133, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (135, 134, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (139, 137, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (139, 138, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (143, 141, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (143, 142, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (147, 145, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (147, 146, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (151, 149, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (151, 150, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (155, 154, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (155, 153, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (159, 157, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (159, 158, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (163, 162, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (163, 161, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (167, 165, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (167, 166, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (171, 169, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (171, 170, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (175, 173, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (175, 174, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (179, 178, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (179, 177, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (183, 181, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (183, 182, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (187, 186, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (187, 185, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (191, 190, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (191, 189, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (195, 193, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)