prompt PL/SQL Developer import file
prompt Created on 2018年3月30日 by
set feedback off
set define off
prompt Creating T_TEST_GROUP...
create table T_TEST_GROUP
(
code VARCHAR2(100),
supplier VARCHAR2(100),
item_id VARCHAR2(100),
num NUMBER,
lot VARCHAR2(100),
wh_id VARCHAR2(100),
user_id VARCHAR2(100)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 8K
minextents 1
maxextents unlimited
);
prompt Disabling triggers for T_TEST_GROUP...
alter table T_TEST_GROUP disable all triggers;
prompt Loading T_TEST_GROUP...
insert into T_TEST_GROUP (code, supplier, item_id, num, lot, wh_id, user_id)
values ('CG01', 'S0002', '100013', 400, 'P16', '1000', '100');
insert into T_TEST_GROUP (code, supplier, item_id, num, lot, wh_id, user_id)
values ('CG01', 'S0002', '100015', 500, 'P20', '1000', '100');
insert into T_TEST_GROUP (code, supplier, item_id, num, lot, wh_id, user_id)
values ('CG01', 'S0003', '100002', 10, 'P03', '1000', '200');
insert into T_TEST_GROUP (code, supplier, item_id, num, lot, wh_id, user_id)
values ('CG01', 'S0002', '100001', 20, 'P02', '1000', '100');
insert into T_TEST_GROUP (code, supplier, item_id, num, lot, wh_id, user_id)
values ('CG01', 'S0001', '100000', 10, 'P01', '1000', '100');
insert into T_TEST_GROUP (code, supplier, item_id, num, lot, wh_id, user_id)
values ('TH01', 'S0005', '100004', 40, 'P04', '1000', '200');
insert into T_TEST_GROUP (code, supplier, item_id, num, lot, wh_id, user_id)
values ('TH01', 'S0005', '100005', 22, 'P05', '1000', '200');
insert into T_TEST_GROUP (code, supplier, item_id, num, lot, wh_id, user_id)
values ('TH01', 'S0002', '100012', 300, 'P10', '1000', '100');
insert into T_TEST_GROUP (code, supplier, item_id, num, lot, wh_id, user_id)
values ('CG01', 'S0002', '100011', 200, 'P12', '1000', '100');
insert into T_TEST_GROUP (code, supplier, item_id, num, lot, wh_id, user_id)
values ('CG01', 'S0003', '100010', 100, 'P13', '1000', '100');
commit;
prompt 9 records loaded
prompt Enabling triggers for T_TEST_GROUP...
alter table T_TEST_GROUP enable all triggers;
set feedback on
set define on
prompt Done;