3.创建临时表的————测试数据表（）

prompt PL/SQL Developer import file
prompt Created on 2013年1月3日 by Administrator
set feedback off
set define off
prompt Creating AAA_TEST...
create table AAA_TEST
(
  INVTYPE         VARCHAR2(1),
  PREYEARTHISYEAR VARCHAR2(2),
  JD              VARCHAR2(1),
  MONTN           VARCHAR2(2),
  SL              VARCHAR2(12),
  BSOID           VARCHAR2(32),
  NOTE            VARCHAR2(32)
)
;

prompt Disabling triggers for AAA_TEST...
alter table AAA_TEST disable all triggers;
prompt Loading AAA_TEST...
insert into AAA_TEST (INVTYPE, PREYEARTHISYEAR, JD, MONTN, SL, BSOID, NOTE)
values ('0', '-1', '1', '1', '101', '1', '统_往年');
insert into AAA_TEST (INVTYPE, PREYEARTHISYEAR, JD, MONTN, SL, BSOID, NOTE)
values ('0', '-1', '2', '4', '102', '2', '统_往年');
insert into AAA_TEST (INVTYPE, PREYEARTHISYEAR, JD, MONTN, SL, BSOID, NOTE)
values ('0', '-1', '3', '8', '103', '3', '统_往年');
insert into AAA_TEST (INVTYPE, PREYEARTHISYEAR, JD, MONTN, SL, BSOID, NOTE)
values ('0', '-1', '4', '12', '104', '4', '统_往年');
insert into AAA_TEST (INVTYPE, PREYEARTHISYEAR, JD, MONTN, SL, BSOID, NOTE)
values ('0', '0', '1', '2', '105', '5', '统_今');
insert into AAA_TEST (INVTYPE, PREYEARTHISYEAR, JD, MONTN, SL, BSOID, NOTE)
values ('0', '0', '2', '5', '106', '6', '统_今');
insert into AAA_TEST (INVTYPE, PREYEARTHISYEAR, JD, MONTN, SL, BSOID, NOTE)
values ('0', '0', '3', '9', '107', '7', '统_今');
insert into AAA_TEST (INVTYPE, PREYEARTHISYEAR, JD, MONTN, SL, BSOID, NOTE)
values ('0', '0', '4', '11', '108', '8', '统_今');
insert into AAA_TEST (INVTYPE, PREYEARTHISYEAR, JD, MONTN, SL, BSOID, NOTE)
values ('1', '-1', '1', '1', '501', '9', '冠名_往年');
insert into AAA_TEST (INVTYPE, PREYEARTHISYEAR, JD, MONTN, SL, BSOID, NOTE)
values ('1', '-1', '2', '4', '502', '10', '冠名_往年');
insert into AAA_TEST (INVTYPE, PREYEARTHISYEAR, JD, MONTN, SL, BSOID, NOTE)
values ('1', '-1', '3', '8', '503', '11', '冠名_往年');
insert into AAA_TEST (INVTYPE, PREYEARTHISYEAR, JD, MONTN, SL, BSOID, NOTE)
values ('1', '-1', '4', '12', '504', '12', '冠名_往年');
insert into AAA_TEST (INVTYPE, PREYEARTHISYEAR, JD, MONTN, SL, BSOID, NOTE)
values ('1', '0', '1', '2', '505', '13', '冠名_往年');
insert into AAA_TEST (INVTYPE, PREYEARTHISYEAR, JD, MONTN, SL, BSOID, NOTE)
values ('1', '0', '2', '5', '506', '14', '冠名_今');
insert into AAA_TEST (INVTYPE, PREYEARTHISYEAR, JD, MONTN, SL, BSOID, NOTE)
values ('1', '0', '3', '9', '507', '15', '冠名_今');
insert into AAA_TEST (INVTYPE, PREYEARTHISYEAR, JD, MONTN, SL, BSOID, NOTE)
values ('1', '0', '4', '11', '508', '16', '冠名_今');
commit;
prompt 16 records loaded
prompt Enabling triggers for AAA_TEST...
alter table AAA_TEST enable all triggers;
set feedback on
set define on
prompt Done.