CREATE TABLE TESTDEMO30 
   (	EMP_ID NUMBER, 
	EMP_NAME VARCHAR2(100), 
	SALARY NUMBER(10,2), 
	JOIN_DATE DATE, 
	STATUS CHAR(1)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE SITE_MANPOWER_DEPLOYMENT 
   (	SITE_CODE CHAR(10) NOT NULL ENABLE, 
	TRAN_DATE DATE NOT NULL ENABLE, 
	ITEM_TYPE CHAR(10) NOT NULL ENABLE, 
	MANPOWER_COUNT NUMBER NOT NULL ENABLE, 
	ADD_DATE DATE, 
	ADD_USER CHAR(10), 
	ADD_TERM VARCHAR2(15), 
	CHG_DATE DATE, 
	CHG_USER CHAR(10), 
	CHG_TERM VARCHAR2(15)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE TRANSPORTER_BILL_CHGS 
   (	TRAN_ID CHAR(10) NOT NULL ENABLE, 
	LINE_NO CHAR(3) NOT NULL ENABLE, 
	CHARGE_CODE CHAR(5), 
	CHARGE_TYPE CHAR(1), 
	AMOUNT NUMBER(18,3), 
	TAX_CLASS CHAR(5), 
	TAX_CHAP CHAR(10), 
	TAX_ENV CHAR(10), 
	TAX_AMT NUMBER(18,3), 
	NET_AMT NUMBER(18,3), 
	CHARGE_BASE_VALUE NUMBER(18,3), 
	CHARGE_RATE NUMBER(14,3), 
	STD_CHARGE_AMT NUMBER(18,3), 
	VARIANCE_AMT NUMBER(18,3)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE ATTENDANCEMASTERBACKUP 
   (	SNO NUMBER(10,0) NOT NULL ENABLE, 
	EMP_CD CHAR(10), 
	DATE_PUNCH DATE, 
	TIME_PUNCH VARCHAR2(6), 
	PREFIX VARCHAR2(4), 
	INOUT VARCHAR2(1), 
	CARDCODE CHAR(10)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 20 PCTUSED 60 INITRANS 2 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE TEST_TABLE120125_1 
   (	ID NUMBER(*,0), 
	NAME VARCHAR2(100)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE TEST_072023 
   (	TEST1 NUMBER(5,0), 
	TEST2 VARCHAR2(10)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE TEST_072022 
   (	TEST1 NUMBER(5,0), 
	TEST2 VARCHAR2(10)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE PAYMENT_PLAN_HDR 
   (	PAY_PLAN_ID CHAR(10) NOT NULL ENABLE, 
	TRAN_DATE DATE NOT NULL ENABLE, 
	PROJ_CODE CHAR(10) NOT NULL ENABLE, 
	SITE_CODE CHAR(5), 
	SITE_DESCR VARCHAR2(50), 
	CHG_USER CHAR(10), 
	CHG_DATE DATE, 
	CHG_TERM VARCHAR2(15)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE INTEREST_CAL_DETAILS 
   (	SALE_ORDER CHAR(10), 
	RECV_REF_SER CHAR(6), 
	RECV_REF_NO CHAR(10), 
	DUE_DATE DATE, 
	DUE_AMOUNT NUMBER(14,4), 
	ADJ_AMT NUMBER(14,4), 
	REF_TYPE CHAR(1), 
	REF_NO CHAR(10), 
	RECEIVED_DATE DATE, 
	REF_AMT NUMBER(14,4), 
	OUTSTANDING_AMT NUMBER(14,4), 
	NO_DAYS_DELAYED NUMBER, 
	INTEREST_AMT NUMBER(14,4), 
	CURRENT_RUN_DATE DATE, 
	LAST_INT_CALC_DATE DATE, 
	TRAN_ID CHAR(10) NOT NULL ENABLE, 
	LINE_NO NUMBER NOT NULL ENABLE, 
	UID_NO CHAR(10)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE EMP_EXITFORM_EMP 
   (	EXIT_INTERVIEW_ID CHAR(10) NOT NULL ENABLE, 
	LINE_NO CHAR(3) NOT NULL ENABLE, 
	QUEST_ID CHAR(10), 
	RESPONSE VARCHAR2(1000)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE DEMO20 
   (	SALES_PER VARCHAR2(50) NOT NULL ENABLE, 
	PRD_CODE CHAR(6) NOT NULL ENABLE
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE EMP_EXITFORM_HR 
   (	EXIT_INTERVIEW_ID CHAR(10) NOT NULL ENABLE, 
	LINE_NO CHAR(3) NOT NULL ENABLE, 
	QUEST_ID CHAR(10), 
	RESPONSE VARCHAR2(1000)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE EMP_EXIT_CLEARANCE 
   (	CLEARANCE_ID CHAR(10) NOT NULL ENABLE, 
	EMP_CODE CHAR(10) NOT NULL ENABLE, 
	RESIGNATION_ID CHAR(10), 
	CLEARANCE_DATE DATE, 
	CLEARANCE_STATUS CHAR(1), 
	DEPT_CODE_CLEARANCE CHAR(5), 
	CLEARANCE_NOTE VARCHAR2(250), 
	TOTAL_RECOVERY_AMT NUMBER(14,8), 
	REMARKS VARCHAR2(250), 
	CHG_DATE DATE, 
	CHG_USER CHAR(10), 
	CHG_TERM VARCHAR2(15), 
	SITE_CODE CHAR(5), 
	EMP_CODE__CLR CHAR(10), 
	STATUS CHAR(1)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE ASSET_DEPR_YEARLY 
   (	ASSET_CODE CHAR(15), 
	ACCT_PRD CHAR(6), 
	NO_DAYS NUMBER(16,0), 
	TOTAL_VALUE NUMBER(16,3), 
	DEPR_TYPE CHAR(1), 
	DEPR_PERC_1 NUMBER(16,2), 
	DEPR_METHOD_1 CHAR(1), 
	DEPR_AMT_1 NUMBER(16,3), 
	WDV_AMT_1 NUMBER(16,3), 
	DEPR_PERC_2 NUMBER(16,2), 
	DEPR_METHOD_2 CHAR(1), 
	DEPR_AMT_2 NUMBER(16,3), 
	WDV_AMT_2 NUMBER(16,3), 
	DEPR_WB_AMT NUMBER(16,3), 
	DEPR_AMT_1_OPEN NUMBER(16,3), 
	WDV_AMT_1_OPEN NUMBER(16,3), 
	DEPR_AMT_2_OPEN NUMBER(16,3), 
	WDV_AMT_2_OPEN NUMBER(16,3), 
	CONFIRM CHAR(1), 
	CONFIRMED CHAR(1), 
	TRAN_ID__POST CHAR(10), 
	ITEM_SER CHAR(5), 
	GRP_CODE CHAR(5), 
	SITE_CODE CHAR(5), 
	PARENT__TRAN_ID CHAR(10), 
	REV__TRAN CHAR(1), 
	DEPR_AMT_REVL_1 NUMBER(14,3), 
	DEPR_AMT_REVL_2 NUMBER(14,3), 
	WDV_AMT_REVL_1 NUMBER(14,3), 
	WDV_AMT_REVL_2 NUMBER(14,3), 
	REV_JV CHAR(1), 
	USEFUL_LIFE NUMBER(4,2), 
	CHG_DATE DATE NOT NULL ENABLE, 
	CHG_USER CHAR(10) NOT NULL ENABLE, 
	CHG_TERM VARCHAR2(300) NOT NULL ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE RPT_PRINT_LOG 
   (	TRAN_ID CHAR(12) NOT NULL ENABLE, 
	REPORT_NAME VARCHAR2(60), 
	PARAMETER_VAL VARCHAR2(100), 
	USER_ID__PRINT CHAR(10), 
	REPRINT_ON DATE, 
	REPRINT_CNT NUMBER(2,0), 
	TRAN_ID__CTRL CHAR(12)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE ITM_DATA;
CREATE TABLE RETAIL_SALES_TARGET 
   (	SALES_PER VARCHAR2(50) NOT NULL ENABLE, 
	PRD_CODE CHAR(6) NOT NULL ENABLE, 
	SITE_CODE CHAR(10) NOT NULL ENABLE, 
	ITEM_TYPE CHAR(10) NOT NULL ENABLE, 
	TARGET_AMT NUMBER NOT NULL ENABLE, 
	ADD_USER CHAR(10), 
	ADD_DATE DATE, 
	ADD_TERM VARCHAR2(15), 
	CHG_USER CHAR(10), 
	CHG_DATE DATE, 
	CHG_TERM VARCHAR2(15)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE WORKING_DAYS 
   (	SITE_CODE CHAR(10) NOT NULL ENABLE, 
	PRD_CODE CHAR(6) NOT NULL ENABLE, 
	WORKING_DAYS NUMBER NOT NULL ENABLE, 
	ADD_DATE DATE, 
	ADD_USER CHAR(10), 
	ADD_TERM VARCHAR2(15), 
	CHG_DATE DATE, 
	CHG_USER CHAR(10), 
	CHG_TERM VARCHAR2(15)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE EMP_EXITFORM_HDR 
   (	EXIT_INTERVIEW_ID CHAR(10) NOT NULL ENABLE, 
	EMP_CODE CHAR(10) NOT NULL ENABLE, 
	INTERVIEW_DATE DATE, 
	EMP_CODE__INTERVIEW CHAR(10), 
	WF_STATUS CHAR(1), 
	EMP_CODE__APRV CHAR(10), 
	RESIGNATION_ID CHAR(10), 
	CHG_DATE DATE, 
	CHG_USER CHAR(10), 
	CHG_TERM VARCHAR2(15), 
	SITE_CODE CHAR(5), 
	STATUS CHAR(1)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE TEST_TABLE 
   (	TEST VARCHAR2(100), 
	NAME VARCHAR2(100), 
	AGE NUMBER(*,0), 
	EMAIL VARCHAR2(100)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE DEMO_TABLE150125 
   (	ID NUMBER(*,0), 
	NAME VARCHAR2(100)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE USERS_GEOFENCE 
   (	USER_ID VARCHAR2(10), 
	GEO_FENCE_ENABLE CHAR(1), 
	GEO_FENCE_OPTION CHAR(1), 
	GEO_FENCE_STARTTIME VARCHAR2(5), 
	GEO_FENCE_ENDTIME VARCHAR2(5), 
	CHG_DATE DATE, 
	CHG_USER VARCHAR2(10), 
	CHG_TERM VARCHAR2(20), 
	TRAN_ID VARCHAR2(20) NOT NULL ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE RESIGNATION_FORM 
   (	RESIGNATION_ID CHAR(10), 
	RESI_DATE DATE, 
	EMP_CODE CHAR(10), 
	REASON CHAR(5), 
	REASON_DESCR VARCHAR2(500), 
	REMARKS VARCHAR2(200), 
	NOTICE_PRD_STD NUMBER(3,0), 
	NOTICE_PRD_REQUESTED NUMBER(3,0), 
	NOTICE_PRD_AGREED NUMBER(3,0), 
	RELIEVE_DATE DATE, 
	APPRV_STATUS CHAR(1), 
	REAS_ALT_NOTICE_PRD CHAR(5), 
	NOTICE_PAY_TYPE CHAR(1), 
	REASON_NOTICE_PAY CHAR(5), 
	WF_STATUS CHAR(1), 
	CONFIRMED CHAR(1), 
	CONF_DATE DATE, 
	EMP_CODE___APRV CHAR(10), 
	SITE_CODE CHAR(5), 
	EMP_CODE__REP CHAR(10), 
	EMP_CODE__MGR CHAR(10), 
	EMP_CODE__HOD CHAR(10), 
	EMP_CODE__HR CHAR(10), 
	CHG_DATE DATE, 
	CHG_USER CHAR(10), 
	CHG_TERM VARCHAR2(15), 
	STATUS CHAR(1)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE CRM_CONTACTS 
   (	CONTACT_ID CHAR(10), 
	PREFIX VARCHAR2(5), 
	FIRST_NAME VARCHAR2(25) NOT NULL ENABLE, 
	MIDDLE_NAME VARCHAR2(25), 
	LAST_NAME VARCHAR2(25), 
	CONTACT_TYPE CHAR(1) NOT NULL ENABLE, 
	ADDRESS_AS VARCHAR2(75), 
	SEX CHAR(1), 
	ADDR1 VARCHAR2(45) NOT NULL ENABLE, 
	ADDR2 VARCHAR2(40), 
	ADDR3 VARCHAR2(40), 
	PIN VARCHAR2(10) NOT NULL ENABLE, 
	CITY VARCHAR2(40) NOT NULL ENABLE, 
	DISTRICT VARCHAR2(20), 
	STAN_CODE CHAR(5) NOT NULL ENABLE, 
	STATE_CODE CHAR(5) NOT NULL ENABLE, 
	COUNT_CODE CHAR(5) NOT NULL ENABLE, 
	LOCALITY_CODE VARCHAR2(10) NOT NULL ENABLE, 
	TELE1 VARCHAR2(15), 
	TELE2 VARCHAR2(15), 
	TELE3 VARCHAR2(15), 
	MOBILE_NO VARCHAR2(15), 
	EMAIL_ADDR VARCHAR2(120), 
	SORG_CODE CHAR(10), 
	SORG_NAME VARCHAR2(120), 
	SECTOR CHAR(5), 
	COMMENTS VARCHAR2(300), 
	SALES_PERS__INIT CHAR(10) NOT NULL ENABLE, 
	SALES_PERS__LEAD CHAR(10), 
	STATUS CHAR(1) NOT NULL ENABLE, 
	STATUS_DATE DATE NOT NULL ENABLE, 
	STATUS_CHANGED_BY CHAR(10), 
	DEACTIVATE_REASON VARCHAR2(100), 
	UPLOAD_FILE_NAME VARCHAR2(120), 
	SC_CODE CHAR(10), 
	ADD_DATE DATE, 
	ADD_USER CHAR(10), 
	ADD_TERM VARCHAR2(300), 
	CHG_DATE DATE, 
	CHG_USER CHAR(10), 
	CHG_TERM VARCHAR2(300), 
	LAST_EXTRACTED_ON DATE, 
	LAST_EXTRACTED_BY CHAR(10), 
	EXTRATION_CRITERIA VARCHAR2(4000), 
	LEAD_ASSIGNED_ON DATE, 
	LEAD_ASSIGNED_BY CHAR(10), 
	INFORMATION_SOURCE VARCHAR2(120), 
	ADDED_SOURCE VARCHAR2(1)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE SAMPLE_TABLE 
   (	ID NUMBER(*,0), 
	NAME VARCHAR2(100), 
	EMAIL VARCHAR2(150), 
	CREATED_AT DATE
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE INTEREST_CAL_DET 
   (	UNIT_NO CHAR(10), 
	REF_SER CHAR(6), 
	REF_NO CHAR(10), 
	DUE_DATE DATE, 
	DUE_AMOUNT NUMBER(14,4), 
	ADJ_AMT NUMBER(14,4), 
	OUTSTANDING_AMOUNT NUMBER(14,4), 
	RECEIVED_DATE DATE, 
	NO_DAYS_DELAYED NUMBER, 
	CR_TERM CHAR(5), 
	INTEREST_PERCENTAGE NUMBER(5,2), 
	INTEREST_AMOUNT NUMBER(14,4), 
	INTEREST_STATUS CHAR(10), 
	LAST_CALC_DATE DATE, 
	INTEREST_DEBIT_NOTE DATE, 
	WAIVED CHAR(1), 
	WAIVED_AMT NUMBER(14,4), 
	TRAN_ID CHAR(10), 
	LINE_NO NUMBER, 
	PRD_CODE VARCHAR2(50)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE ENTERPRISE_CP_ACC 
   (	ENTERPRISE VARCHAR2(10) NOT NULL ENABLE, 
	ENTERPRISE_ACC VARCHAR2(10) NOT NULL ENABLE, 
	SETTING_STATUS CHAR(1), 
	STATUS_DATE DATE, 
	CHG_DATE DATE NOT NULL ENABLE, 
	CHG_USER CHAR(10) NOT NULL ENABLE, 
	CHG_TERM VARCHAR2(15) NOT NULL ENABLE, 
	ADD_DATE DATE NOT NULL ENABLE, 
	ADD_USER CHAR(10) NOT NULL ENABLE, 
	ADD_TERM VARCHAR2(15) NOT NULL ENABLE, 
	REMARKS VARCHAR2(100), 
	CUST_CODE CHAR(10), 
	SUPP_CODE CHAR(10), 
	REPLICATE_DATA_STATUS CHAR(1), 
	SITE_CODE_CP CHAR(5), 
	SITE_CODE CHAR(5)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE ALLWDEDN_BKP 
   (	AD_CODE CHAR(5) NOT NULL ENABLE, 
	SH_DESCR VARCHAR2(10) NOT NULL ENABLE, 
	DESCR VARCHAR2(40) NOT NULL ENABLE, 
	TYPE CHAR(1) NOT NULL ENABLE, 
	SEQ_NO CHAR(3), 
	RND_OFF CHAR(1) NOT NULL ENABLE, 
	RND_TO NUMBER(14,5), 
	PROP_YN CHAR(1) NOT NULL ENABLE, 
	PROP_ON CHAR(1), 
	PAYABLE CHAR(1) NOT NULL ENABLE, 
	POST_YN CHAR(1) NOT NULL ENABLE, 
	SLAB_OPTION CHAR(1) NOT NULL ENABLE, 
	BASE_FORMULA VARCHAR2(3000), 
	SLAB_FORMULA VARCHAR2(3000), 
	RES_FORMULA VARCHAR2(3000), 
	BAL_OPT CHAR(1) NOT NULL ENABLE, 
	FOR_CONDN CHAR(1), 
	SQL_EXPR VARCHAR2(1000), 
	SQL_INPUT VARCHAR2(1000), 
	MIN_VAL VARCHAR2(250), 
	MAX_VAL VARCHAR2(250), 
	IT_PROJ CHAR(1) NOT NULL ENABLE, 
	IT_SECTION CHAR(10), 
	PRT_SEQ CHAR(3), 
	DROP_YN CHAR(1) NOT NULL ENABLE, 
	COST_COMPANY CHAR(1) NOT NULL ENABLE, 
	SPLIT_YN CHAR(1) NOT NULL ENABLE, 
	ACCT_CODE__SAL CHAR(10), 
	CCTR_CODE__SAL CHAR(4), 
	CHG_DATE DATE, 
	CHG_USER CHAR(10), 
	CHG_TERM VARCHAR2(15), 
	PAY_TAX CHAR(1), 
	TAUTH_CODE CHAR(10), 
	DIRECT_VOUCHER CHAR(1), 
	DELETE_ARR CHAR(1), 
	BAL_FROM NUMBER(2,0), 
	BAL_TO NUMBER(2,0), 
	DROP_SEQ CHAR(3), 
	DROP_OPT CHAR(1), 
	FREQUENCY CHAR(1), 
	IT_PROOF_REQ CHAR(1), 
	PRINT_OPT CHAR(1), 
	GEN_NEGT_ARR CHAR(1), 
	APPLICABLE_IN_FFS CHAR(1), 
	UDF_TYPE VARCHAR2(5), 
	APPLICABLE_TO CHAR(1), 
	INPUT_TYPE CHAR(1)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE ITM_ADM_D1;
CREATE TABLE TYMT 
   (	COL1 NUMBER(*,0), 
	COL2 VARCHAR2(50), 
	COL3 VARCHAR2(50), 
	COL4 DATE
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE KEYBOARD 
   (	COL1 NUMBER(*,0), 
	COL2 VARCHAR2(50), 
	COL3 VARCHAR2(50), 
	COL4 DATE
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE RECORD1 
   (	SALES_PER VARCHAR2(50) NOT NULL ENABLE, 
	PRD_CODE CHAR(6) NOT NULL ENABLE, 
	SITE_CODE CHAR(10) NOT NULL ENABLE
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE DEMO_TABLE120125 
   (	ID NUMBER(*,0), 
	NAME VARCHAR2(100)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE EXAMPLE_TABLE 
   (	ID NUMBER(*,0), 
	NAME VARCHAR2(100), 
	CREATED_AT DATE
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE WAIVE_OFF_HDR 
   (	TRAN_ID CHAR(10) NOT NULL ENABLE, 
	TRAN_DATE DATE, 
	CUST_CODE CHAR(10) NOT NULL ENABLE, 
	CUST_NAME VARCHAR2(50), 
	WAIVE_OFF_AMT NUMBER(14,4) NOT NULL ENABLE, 
	REASON VARCHAR2(250), 
	REMARKS VARCHAR2(250), 
	CONFIRMED CHAR(1), 
	CONF_DATE DATE, 
	WF_STATUS CHAR(1), 
	SITE_CODE CHAR(5), 
	SITE_DESCR VARCHAR2(50), 
	CHG_USER CHAR(10), 
	CHG_DATE DATE, 
	CHG_TERM VARCHAR2(15), 
	PENDING_WAIVE_OFF_AMT NUMBER(14,4), 
	IS_USED CHAR(1), 
	SALE_ORDER CHAR(10)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE BUYER_TRANSFER_HDR 
   (	TRAN_ID CHAR(10) NOT NULL ENABLE, 
	TRAN_DATE DATE NOT NULL ENABLE, 
	CUST_CODE CHAR(10) NOT NULL ENABLE, 
	CUST_NAME VARCHAR2(50), 
	CUST_CODE_OLD CHAR(10) NOT NULL ENABLE, 
	CUST_NAME_OLD VARCHAR2(50), 
	SALE_ORDER CHAR(10) NOT NULL ENABLE, 
	SALE_ORDER_NEW CHAR(10), 
	BOOK_AMT NUMBER, 
	BAL_AMT NUMBER, 
	REMARKS VARCHAR2(250), 
	CONFIRMED CHAR(1), 
	CONF_DATE DATE, 
	STATUS CHAR(1), 
	CHG_USER CHAR(10), 
	CHG_DATE DATE, 
	CHG_TERM VARCHAR2(15)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE TEST_DEMO24 
   (	SALES_PER VARCHAR2(50) NOT NULL ENABLE, 
	PRD_CODE CHAR(6) NOT NULL ENABLE
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE APPLICANT_INFO 
   (	APPLICANT_NAME CHAR(50) NOT NULL ENABLE, 
	WHATSAPP_MOBILE VARCHAR2(12) NOT NULL ENABLE, 
	VEHICLE_DESC VARCHAR2(30) NOT NULL ENABLE, 
	VEHICLE_REG_NO VARCHAR2(13) NOT NULL ENABLE, 
	FINANCE_AMOUNT NUMBER(10,2) NOT NULL ENABLE, 
	PINCODE VARCHAR2(6) NOT NULL ENABLE, 
	TRAN_DATE DATE NOT NULL ENABLE, 
	TRAN_ID VARCHAR2(20) NOT NULL ENABLE, 
	CHG_DATE DATE, 
	CHG_USER VARCHAR2(10), 
	CHG_TERM VARCHAR2(15), 
	ADD_USER CHAR(10), 
	ADD_DATE DATE, 
	ADD_TERM VARCHAR2(15), 
	ALLOCATED_TO CHAR(10), 
	WF_STATUS CHAR(1), 
	STATUS VARCHAR2(1), 
	STATUS_DATE DATE, 
	STATUS_REMARKS VARCHAR2(500)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE PAYMENT_PLAN_DET 
   (	PAY_PLAN_ID CHAR(10) NOT NULL ENABLE, 
	LINE_NO CHAR(3) NOT NULL ENABLE, 
	ITEM_TYPE CHAR(10), 
	ITEM_CODE CHAR(10), 
	AMT_TYPE CHAR(2), 
	AMOUNT NUMBER(14,3), 
	SEQ_NO CHAR(10), 
	DUE_DATE DATE, 
	ACTIVE CHAR(1)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE UNIT_TRANSFER_HDR 
   (	TRAN_ID CHAR(10) NOT NULL ENABLE, 
	TRAN_DATE DATE NOT NULL ENABLE, 
	SALE_ORDER CHAR(10) NOT NULL ENABLE, 
	SALE_ORDER_NEW CHAR(10), 
	CUST_CODE CHAR(10), 
	AMOUNT NUMBER, 
	REMARKS VARCHAR2(250), 
	CONFIRMED CHAR(1), 
	CONF_DATE DATE, 
	STATUS CHAR(1), 
	CHG_USER CHAR(10), 
	CHG_DATE DATE, 
	CHG_TERM VARCHAR2(15), 
	SITE_CODE CHAR(5)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE TEST_0725 
   (	TEST1 NUMBER(5,0), 
	TEST2 VARCHAR2(10)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE RETAIL_FOOTFALL 
   (	SITE_CODE CHAR(10) NOT NULL ENABLE, 
	TRAN_DATE DATE NOT NULL ENABLE, 
	HOURS CHAR(10) NOT NULL ENABLE, 
	WALKIN NUMBER NOT NULL ENABLE, 
	ADD_DATE DATE, 
	ADD_USER CHAR(10), 
	ADD_TERM VARCHAR2(15), 
	CHG_DATE DATE, 
	CHG_USER CHAR(10), 
	CHG_TERM VARCHAR2(15)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE USERTYPE_LIC_CHRGS 
   (	USER_LIC_TYPE CHAR(1) NOT NULL ENABLE, 
	CHRG_AMT NUMBER(14,3), 
	REMARKS VARCHAR2(60), 
	ADD_DATE DATE NOT NULL ENABLE, 
	ADD_USER CHAR(10) NOT NULL ENABLE, 
	ADD_TERM CHAR(15) NOT NULL ENABLE, 
	CHG_DATE DATE NOT NULL ENABLE, 
	CHG_USER CHAR(10) NOT NULL ENABLE, 
	CHG_TERM CHAR(15) NOT NULL ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE WO_OBSRV_DET 
   (	TRAN_ID CHAR(10), 
	LINE_NO NUMBER(3,0), 
	SEQ_NO NUMBER(3,0), 
	OBSERV_DATA XMLTYPE
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS 
 XMLTYPE COLUMN OBSERV_DATA STORE AS SECUREFILE BINARY XML (
  TABLESPACE USERS ENABLE STORAGE IN ROW CHUNK 8192
  NOCACHE LOGGING  NOCOMPRESS  KEEP_DUPLICATES ) ALLOW NONSCHEMA DISALLOW ANYSCHEMA;
CREATE TABLE POS_AMENDMENT 
   (	POS_ID CHAR(10) NOT NULL ENABLE, 
	STATUS CHAR(1) NOT NULL ENABLE, 
	EFF_DATE DATE, 
	DESP_ID CHAR(10), 
	TRAN_CODE CHAR(10), 
	LR_NO VARCHAR2(25), 
	LR_DATE DATE, 
	OCTROI_RCP_NO VARCHAR2(10), 
	OCTROI_RCP_DATE DATE, 
	REMARKS VARCHAR2(60), 
	REF_NO CHAR(40), 
	REF_DATE DATE, 
	NO_ART NUMBER(5,0), 
	LORRY_NO VARCHAR2(30), 
	GP_NO CHAR(15), 
	GP_DATE DATE, 
	GR_NO VARCHAR2(20), 
	GR_DATE DATE, 
	CURR_CODE__FRT CHAR(5), 
	EXCH_RATE__FRT NUMBER(17,6), 
	FRT_AMT NUMBER(14,3), 
	CURR_CODE__INS CHAR(5), 
	EXCH_RATE__INS NUMBER(17,6), 
	INS_AMT NUMBER(14,3), 
	SAIL_DATE DATE, 
	SB_NO CHAR(15), 
	SB_DATE DATE, 
	STAN_CODE__INIT CHAR(5), 
	FRT_TYPE CHAR(1), 
	TRANS_MODE CHAR(1), 
	GROSS_WEIGHT NUMBER(14,3), 
	DATE_ARR DATE, 
	DATE_DEP DATE, 
	SHIPMENT_ID CHAR(10), 
	UDF__STR1 CHAR(20), 
	UDF__STR2 CHAR(20), 
	CHG_DATE DATE, 
	BL_REC_DATE DATE, 
	CONFIRMED CHAR(1), 
	CONF_DATE DATE, 
	EMP_CODE__APRV CHAR(10), 
	RD_PERMIT_NO CHAR(20), 
	SALES_SCH CHAR(10), 
	CUST_PORD VARCHAR2(50), 
	PORD_DATE DATE, 
	TRAN_ID VARCHAR2(10), 
	ADD_DATE DATE, 
	ADD_USER VARCHAR2(10), 
	ADD_TERM VARCHAR2(15), 
	ASN_FLAG_YN CHAR(1), 
	EXPORT_DATE DATE, 
	EXCH_RATE__CUSTOM NUMBER(17,6), 
	DUTY_DRAWABCK NUMBER(14,3), 
	SER_TAX_REFUND NUMBER(14,3), 
	DBK_REC_DATE DATE, 
	SER_TAX_REC_DATE DATE, 
	MEIS_CR_APPROX NUMBER(14,3), 
	MEIS_CR_ACTUAL NUMBER(14,3), 
	MEIS_APPLICABLE CHAR(1), 
	MEIS_REMARKS VARCHAR2(100), 
	MEIS_FILE_NO VARCHAR2(100), 
	MEIS_LIC_NO VARCHAR2(50), 
	MEIS_DATE DATE, 
	BOND_REFUND CHAR(1), 
	DUTY_AMT NUMBER(14,3), 
	REBATE_APPLY_DATE DATE, 
	REBATE_RECD_DATE DATE, 
	REBATE_RECD_AMT NUMBER(14,3), 
	POE_DOX_SEND_DATE DATE, 
	SPECIAL_REMARKS VARCHAR2(300), 
	ACTUAL_ARRVL_DATE DATE, 
	TRAN_DATE DATE, 
	SITE_CODE CHAR(5), 
	CHG_USER CHAR(10), 
	CHG_TERM VARCHAR2(15), 
	ARE1_NO CHAR(20), 
	CLG_AGENT VARCHAR2(30), 
	VEHICLE_NO CHAR(20), 
	FOB_VALUE NUMBER, 
	MEIS_AMT NUMBER, 
	NO_OF_PALLETS NUMBER
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE STUFF 
   (	NAME VARCHAR2(100), 
	AGE NUMBER(*,0), 
	SURNAME VARCHAR2(100), 
	EMAIL VARCHAR2(200)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE MISC_DRCR_INTEREST 
   (	UID_NO CHAR(10), 
	RECV_REF_NO CHAR(10), 
	REF_TYPE CHAR(1), 
	REF_SER CHAR(6), 
	REF_NO CHAR(10), 
	INTEREST_AMOUNT NUMBER(14,4), 
	TRAN_ID CHAR(10) NOT NULL ENABLE, 
	LINE_NO CHAR(3) NOT NULL ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE TESTING 
   (	SALES_PER VARCHAR2(50) NOT NULL ENABLE, 
	PRD_CODE CHAR(6) NOT NULL ENABLE, 
	SITE_CODE CHAR(10) NOT NULL ENABLE
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE RECD 
   (	SALES_PER VARCHAR2(50) NOT NULL ENABLE, 
	PRD_CODE CHAR(6) NOT NULL ENABLE, 
	SITE_CODE CHAR(10) NOT NULL ENABLE
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE PRODUCTION_TARGET 
   (	SITE_CODE CHAR(10) NOT NULL ENABLE, 
	ITEM_TYPE CHAR(10) NOT NULL ENABLE, 
	QUANTITY NUMBER, 
	ADD_USER CHAR(10), 
	ADD_DATE DATE, 
	ADD_TERM VARCHAR2(15), 
	CHG_USER CHAR(10), 
	CHG_DATE DATE, 
	CHG_TERM VARCHAR2(15), 
	PRD_CODE CHAR(6) NOT NULL ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE ACTIVITY_12 
   (	ID NUMBER(*,0), 
	NAME VARCHAR2(100)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE EMP_EXIT_CLEARANCE_CHECKLIST 
   (	CLEARANCE_ID CHAR(10), 
	LINE_NO CHAR(3), 
	QUEST_ID CHAR(10), 
	RESPONSE VARCHAR2(1000)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE SQLPLUS_PRODUCT_PROFILE 
   (	PRODUCT VARCHAR2(30) NOT NULL ENABLE, 
	USERID VARCHAR2(30), 
	ATTRIBUTE VARCHAR2(240), 
	SCOPE VARCHAR2(240), 
	NUMERIC_VALUE NUMBER(15,2), 
	CHAR_VALUE VARCHAR2(240), 
	DATE_VALUE DATE, 
	LONG_VALUE LONG
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE ITM_DATA_GEN;

-- No of Rows = 51
