CREATE TABLE "TABLEA"
( "RESOURCE_ID" VARCHAR2(25 BYTE) NOT NULL ENABLE,
"AMOUNT" NUMBER(30,3) NOT NULL ENABLE,
"VOUCHER_NO" NUMBER(20,0) NOT NULL ENABLE,
"STATUS" VARCHAR2(1 BYTE) NOT NULL ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "SYSTEM" ;
CREATE TABLE "TABLEB"
( "RESOURCE_ID" VARCHAR2(25 BYTE) NOT NULL ENABLE,
"AMOUNT" NUMBER(30,3) NOT NULL ENABLE,
"VOUCHER_NO" NUMBER(20,0) NOT NULL ENABLE,
"STATUS" VARCHAR2(1 BYTE) NOT NULL ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "SYSTEM" ;
INSERT INTO tablea (amount,resource_id,status,voucher_no) VALUES (6484.00000000,'400','N',30300352 );
INSERT INTO tablea (amount,resource_id,status,voucher_no) VALUES (1621.00000000,'100','U',30300338 );
INSERT INTO tablea (amount,resource_id,status,voucher_no) VALUES (6484.00000000,'400','U',30300352 );
INSERT INTO tablea (amount,resource_id,status,voucher_no) VALUES (6484.00000000,'500','U',30300356 );
INSERT INTO tablea (amount,resource_id,status,voucher_no) VALUES (28530.00000000,'300','U',30300346 );
INSERT INTO tablea (amount,resource_id,status,voucher_no) VALUES (25936.00000000,'200','U',30300340 );
INSERT INTO tablea (amount,resource_id,status,voucher_no) VALUES (25936.00000000,'300','U',30300350 );
INSERT INTO tablea (amount,resource_id,status,voucher_no) VALUES (7132.00000000,'100','U',30300342 );
INSERT INTO tablea (amount,resource_id,status,voucher_no) VALUES (6484.00000000,'500','U',30300354 );
INSERT INTO tablea (amount,resource_id,status,voucher_no) VALUES (1621.00000000,'100','T',30300338 );
INSERT INTO tablea (amount,resource_id,status,voucher_no) VALUES (25936.00000000,'300','T',30300350 );
INSERT INTO tablea (amount,resource_id,status,voucher_no) VALUES (7132.00000000,'100','T',30300342 );
INSERT INTO tablea (amount,resource_id,status,voucher_no) VALUES (6484.00000000,'500','N',30300354 );
INSERT INTO tablea (amount,resource_id,status,voucher_no) VALUES (25936.00000000,'200','T',30300340 );
INSERT INTO tablea (amount,resource_id,status,voucher_no) VALUES (6484.00000000,'500','N',30300356 );
INSERT INTO tablea (amount,resource_id,status,voucher_no) VALUES (28530.00000000,'300','T',30300346 );
INSERT INTO tableb (amount,resource_id,status,voucher_no) VALUES (0.00000000,'300','N',30300351 );
INSERT INTO tableb (amount,resource_id,status,voucher_no) VALUES (25936.00000000,'300','N',30300350 );
INSERT INTO tableb (amount,resource_id,status,voucher_no) VALUES (0.00000000,'100','N',30300338 );
INSERT INTO tableb (amount,resource_id,status,voucher_no) VALUES (0.00000000,'100','N',30300339 );
INSERT INTO tableb (amount,resource_id,status,voucher_no) VALUES (0.00000000,'100','N',30300342 );
INSERT INTO tableb (amount,resource_id,status,voucher_no) VALUES (0.00000000,'100','N',30300343 );
INSERT INTO tableb (amount,resource_id,status,voucher_no) VALUES (0.00000000,'200','N',30300341 );
INSERT INTO tableb (amount,resource_id,status,voucher_no) VALUES (35662.00000000,'200','N',30300344 );
INSERT INTO tableb (amount,resource_id,status,voucher_no) VALUES (0.00000000,'200','N',30300345 );
INSERT INTO tableb (amount,resource_id,status,voucher_no) VALUES (0.00000000,'300','N',30300347 );
INSERT INTO tableb (amount,resource_id,status,voucher_no) VALUES (28530.00000000,'300','N',30300346 );
INSERT INTO tableb (amount,resource_id,status,voucher_no) VALUES (2910.00000000,'400','N',30300349 );
INSERT INTO tableb (amount,resource_id,status,voucher_no) VALUES (28530.00000000,'400','N',30300348 );
INSERT INTO tableb (amount,resource_id,status,voucher_no) VALUES (661.00000000,'400','N',30300353 );
INSERT INTO tableb (amount,resource_id,status,voucher_no) VALUES (0.00000000,'500','N',30300355 );
INSERT INTO tableb (amount,resource_id,status,voucher_no) VALUES (6484.00000000,'500','N',30300354 );
INSERT INTO tableb (amount,resource_id,status,voucher_no) VALUES (0.00000000,'500','N',30300357 );
INSERT INTO tableb (amount,resource_id,status,voucher_no) VALUES (6484.00000000,'500','N',30300356 );
INSERT INTO tableb (amount,resource_id,status,voucher_no) VALUES (25936.00000000,'200','N',30300340 );
INSERT INTO tableb (amount,resource_id,status,voucher_no) VALUES (6484.00000000,'400','N',30300352 );
commit;