CREATE TABLE TB_123456
( SEQUENCE_NO NUMBER(15,0),
CARD_NO VARCHAR2(25 CHAR),
STMT_END_DATE VARCHAR2(10 CHAR),
STMT_BEGIN_DATE VARCHAR2(10 CHAR),
CARD_TYPE VARCHAR2(1 CHAR),
BILL_TYPE VARCHAR2(1 CHAR),
TRANSFER_CARD_NO VARCHAR2(4000 CHAR),
MASK_ACC_NO VARCHAR2(16 CHAR),
PK_TB_COMPANY_DETAILS NUMBER(10,0),
SYS_DEFAULT_DATE VARCHAR2(10 CHAR),
PAPER_STMT_OPT_OUT VARCHAR2(1 CHAR),
COUNTRY VARCHAR2(20 CHAR),
COUNTRY_CODE VARCHAR2(5 CHAR),
IS_IPC_COUNTRY VARCHAR2(1 CHAR),
CURRENCY_FORMAT VARCHAR2(25 CHAR),
DESPATCH_TYPE_FLAG VARCHAR2(2 CHAR),
EMAIL VARCHAR2(4000 CHAR),
SORT_ORD_ONE VARCHAR2(1 CHAR),
SORT_ORD_TWO VARCHAR2(1 CHAR),
SINGLE_PAYMENT VARCHAR2(1 CHAR),
ORG_ID VARCHAR2(3 BYTE),
CARDHLDR_LOGO VARCHAR2(5 CHAR),
CYCLE_DAY VARCHAR2(2 CHAR),
STMT_CREATED_ON DATE,
IS_MCLODGE VARCHAR2(1 CHAR),
REGION VARCHAR2(2 CHAR),
STATUS VARCHAR2(2 CHAR),
CREATED_ON DATE
) partition by range (STMT_CREATED_ON) interval (interval '1' day)
(
partition p0 values less than (date '2017-03-01')
);
Insert into TB_123456 (SEQUENCE_NO,CARD_NO,STMT_END_DATE,STMT_BEGIN_DATE,CARD_TYPE,BILL_TYPE,TRANSFER_CARD_NO,MASK_ACC_NO,PK_TB_COMPANY_DETAILS,SYS_DEFAULT_DATE,PAPER_STMT_OPT_OUT,COUNTRY,COUNTRY_CODE,IS_IPC_COUNTRY,CURRENCY_FORMAT,DESPATCH_TYPE_FLAG,EMAIL,SORT_ORD_ONE,SORT_ORD_TWO,SINGLE_PAYMENT,ORG_ID,CARDHLDR_LOGO,CYCLE_DAY,STMT_CREATED_ON,IS_MCLODGE,REGION,STATUS,CREATED_ON) values (201609080000355,'4611559000023331','11/06/2012','12/06/2012',' ',' ',null,'L10',15249,null,'0','INDIA','IN','N',null,null,'111987~CARD_EMBOSSED_NAME_DOB~%~@~% ',null,null,null,null,null,null,to_date('08-SEP-16','DD-MON-RR'),'N','AP','A',to_date('07-MAR-17','DD-MON-RR'));
Insert into TB_123456 (SEQUENCE_NO,CARD_NO,STMT_END_DATE,STMT_BEGIN_DATE,CARD_TYPE,BILL_TYPE,TRANSFER_CARD_NO,MASK_ACC_NO,PK_TB_COMPANY_DETAILS,SYS_DEFAULT_DATE,PAPER_STMT_OPT_OUT,COUNTRY,COUNTRY_CODE,IS_IPC_COUNTRY,CURRENCY_FORMAT,DESPATCH_TYPE_FLAG,EMAIL,SORT_ORD_ONE,SORT_ORD_TWO,SINGLE_PAYMENT,ORG_ID,CARDHLDR_LOGO,CYCLE_DAY,STMT_CREATED_ON,IS_MCLODGE,REGION,STATUS,CREATED_ON) values (201609080000356,'4611559000003804','31/10/2012','01/11/2012',' ',' ',null,'L10',15232,null,'0',null,'IN','N',null,null,'~CARD_EMBOSSED_NAME_DOB~%~@~% ',null,null,null,null,null,null,to_date('08-SEP-16','DD-MON-RR'),'N','AP','A',to_date('07-MAR-17','DD-MON-RR'));
Insert into TB_123456 (SEQUENCE_NO,CARD_NO,STMT_END_DATE,STMT_BEGIN_DATE,CARD_TYPE,BILL_TYPE,TRANSFER_CARD_NO,MASK_ACC_NO,PK_TB_COMPANY_DETAILS,SYS_DEFAULT_DATE,PAPER_STMT_OPT_OUT,COUNTRY,COUNTRY_CODE,IS_IPC_COUNTRY,CURRENCY_FORMAT,DESPATCH_TYPE_FLAG,EMAIL,SORT_ORD_ONE,SORT_ORD_TWO,SINGLE_PAYMENT,ORG_ID,CARDHLDR_LOGO,CYCLE_DAY,STMT_CREATED_ON,IS_MCLODGE,REGION,STATUS,CREATED_ON) values (201609080000357,'4611559000005627','30/09/2012','01/10/2012',' ',' ',null,'L10',15232,null,'0','INDIA','IN','N',null,null,'051986~CARD_EMBOSSED_NAME_DOB~%~@~% ',null,null,null,null,null,null,to_date('08-SEP-16','DD-MON-RR'),'N','AP','A',to_date('07-MAR-17','DD-MON-RR'));
Insert into TB_123456 (SEQUENCE_NO,CARD_NO,STMT_END_DATE,STMT_BEGIN_DATE,CARD_TYPE,BILL_TYPE,TRANSFER_CARD_NO,MASK_ACC_NO,PK_TB_COMPANY_DETAILS,SYS_DEFAULT_DATE,PAPER_STMT_OPT_OUT,COUNTRY,COUNTRY_CODE,IS_IPC_COUNTRY,CURRENCY_FORMAT,DESPATCH_TYPE_FLAG,EMAIL,SORT_ORD_ONE,SORT_ORD_TWO,SINGLE_PAYMENT,ORG_ID,CARDHLDR_LOGO,CYCLE_DAY,STMT_CREATED_ON,IS_MCLODGE,REGION,STATUS,CREATED_ON) values (201609080000358,'4611559000008043','31/10/2012','01/11/2012',' ',' ',null,'L10',15232,null,'0',null,'IN','N',null,null,'051991~CARD_EMBOSSED_NAME_DOB~%~@~% ',null,null,null,null,null,null,to_date('08-SEP-16','DD-MON-RR'),'N','AP','A',to_date('07-MAR-17','DD-MON-RR'));
Insert into TB_123456 (SEQUENCE_NO,CARD_NO,STMT_END_DATE,STMT_BEGIN_DATE,CARD_TYPE,BILL_TYPE,TRANSFER_CARD_NO,MASK_ACC_NO,PK_TB_COMPANY_DETAILS,SYS_DEFAULT_DATE,PAPER_STMT_OPT_OUT,COUNTRY,COUNTRY_CODE,IS_IPC_COUNTRY,CURRENCY_FORMAT,DESPATCH_TYPE_FLAG,EMAIL,SORT_ORD_ONE,SORT_ORD_TWO,SINGLE_PAYMENT,ORG_ID,CARDHLDR_LOGO,CYCLE_DAY,STMT_CREATED_ON,IS_MCLODGE,REGION,STATUS,CREATED_ON) values (201609080000355,'4611559000023331','11/06/2012','12/06/2012',' ',' ',null,'L10',15249,null,'0','INDIA','IN','N',null,null,'111987~CARD_EMBOSSED_NAME_DOB~%~@~% ',null,null,null,null,null,null,to_date('09-SEP-16','DD-MON-RR'),'N','AP','A',to_date('07-MAR-17','DD-MON-RR'));
Insert into TB_123456 (SEQUENCE_NO,CARD_NO,STMT_END_DATE,STMT_BEGIN_DATE,CARD_TYPE,BILL_TYPE,TRANSFER_CARD_NO,MASK_ACC_NO,PK_TB_COMPANY_DETAILS,SYS_DEFAULT_DATE,PAPER_STMT_OPT_OUT,COUNTRY,COUNTRY_CODE,IS_IPC_COUNTRY,CURRENCY_FORMAT,DESPATCH_TYPE_FLAG,EMAIL,SORT_ORD_ONE,SORT_ORD_TWO,SINGLE_PAYMENT,ORG_ID,CARDHLDR_LOGO,CYCLE_DAY,STMT_CREATED_ON,IS_MCLODGE,REGION,STATUS,CREATED_ON) values (201609080000356,'4611559000003804','31/10/2012','01/11/2012',' ',' ',null,'L10',15232,null,'0',null,'IN','N',null,null,'~CARD_EMBOSSED_NAME_DOB~%~@~% ',null,null,null,null,null,null,to_date('09-SEP-16','DD-MON-RR'),'N','AP','A',to_date('07-MAR-17','DD-MON-RR'));
Insert into TB_123456 (SEQUENCE_NO,CARD_NO,STMT_END_DATE,STMT_BEGIN_DATE,CARD_TYPE,BILL_TYPE,TRANSFER_CARD_NO,MASK_ACC_NO,PK_TB_COMPANY_DETAILS,SYS_DEFAULT_DATE,PAPER_STMT_OPT_OUT,COUNTRY,COUNTRY_CODE,IS_IPC_COUNTRY,CURRENCY_FORMAT,DESPATCH_TYPE_FLAG,EMAIL,SORT_ORD_ONE,SORT_ORD_TWO,SINGLE_PAYMENT,ORG_ID,CARDHLDR_LOGO,CYCLE_DAY,STMT_CREATED_ON,IS_MCLODGE,REGION,STATUS,CREATED_ON) values (201609080000357,'4611559000005627','30/09/2012','01/10/2012',' ',' ',null,'L10',15232,null,'0','INDIA','IN','N',null,null,'051986~CARD_EMBOSSED_NAME_DOB~%~@~% ',null,null,null,null,null,null,to_date('09-SEP-16','DD-MON-RR'),'N','AP','A',to_date('07-MAR-17','DD-MON-RR'));
Insert into TB_123456 (SEQUENCE_NO,CARD_NO,STMT_END_DATE,STMT_BEGIN_DATE,CARD_TYPE,BILL_TYPE,TRANSFER_CARD_NO,MASK_ACC_NO,PK_TB_COMPANY_DETAILS,SYS_DEFAULT_DATE,PAPER_STMT_OPT_OUT,COUNTRY,COUNTRY_CODE,IS_IPC_COUNTRY,CURRENCY_FORMAT,DESPATCH_TYPE_FLAG,EMAIL,SORT_ORD_ONE,SORT_ORD_TWO,SINGLE_PAYMENT,ORG_ID,CARDHLDR_LOGO,CYCLE_DAY,STMT_CREATED_ON,IS_MCLODGE,REGION,STATUS,CREATED_ON) values (201609080000358,'4611559000008043','31/10/2012','01/11/2012',' ',' ',null,'L10',15232,null,'0',null,'IN','N',null,null,'051991~CARD_EMBOSSED_NAME_DOB~%~@~% ',null,null,null,null,null,null,to_date('09-SEP-16','DD-MON-RR'),'N','AP','A',to_date('07-MAR-17','DD-MON-RR'));