?? bb.sql
字號:
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)
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -