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 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 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 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 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 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 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 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 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 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 IMPORT_ORDER_ITEM_INFO 
   (	TRAN_ID VARCHAR2(20) NOT NULL ENABLE, 
	DOC_ID CHAR(20), 
	DOC_NAME VARCHAR2(120), 
	MODIFY_ITEM_CODE CHAR(20), 
	MODIFY_ITEM_DESCR VARCHAR2(130), 
	EXTRACTED_DESCR VARCHAR2(130), 
	VECTOR_ITEM_CODE CHAR(20), 
	VECTOR_ITEM_DESCR VARCHAR2(130), 
	LOOKUP_ITEM_CODE CHAR(20), 
	LOOKUP_ITEM_DESCR VARCHAR2(130), 
	ADD_DATE DATE NOT NULL ENABLE, 
	ADD_TERM VARCHAR2(15) NOT NULL ENABLE, 
	ADD_USER CHAR(10) NOT NULL ENABLE
   ) SEGMENT CREATION DEFERRED 
  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 NET_PRINTERS_LOG 
   (	TRAN_ID VARCHAR2(255) NOT NULL ENABLE, 
	USER_ID VARCHAR2(255), 
	PRINTER_NAME VARCHAR2(255), 
	SERVER_URI VARCHAR2(255), 
	REPORT_DATA BLOB, 
	ERROR_INFO CLOB, 
	PRINT_STATUS VARCHAR2(10), 
	ADD_DATE TIMESTAMP (6) NOT NULL ENABLE, 
	ADD_USER VARCHAR2(255) NOT NULL ENABLE, 
	ADD_TERM VARCHAR2(255) NOT NULL ENABLE
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS 
 LOB (REPORT_DATA) STORE AS SECUREFILE (
  TABLESPACE USERS ENABLE STORAGE IN ROW CHUNK 8192
  NOCACHE LOGGING  NOCOMPRESS  KEEP_DUPLICATES ) 
 LOB (ERROR_INFO) STORE AS SECUREFILE (
  TABLESPACE USERS ENABLE STORAGE IN ROW CHUNK 8192
  NOCACHE LOGGING  NOCOMPRESS  KEEP_DUPLICATES );
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 GST_AUTH_INFO 
   (	GSTIN_NO VARCHAR2(30) NOT NULL ENABLE, 
	TOKEN_INIT_DATE DATE, 
	TOKEN_EXPIRY DATE, 
	AUTH_SEK BLOB, 
	AUTH_TOKEN VARCHAR2(50), 
	APP_KEY VARCHAR2(250)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS 
 LOB (AUTH_SEK) STORE AS SECUREFILE (
  TABLESPACE USERS ENABLE STORAGE IN ROW CHUNK 8192
  NOCACHE LOGGING  NOCOMPRESS  KEEP_DUPLICATES );
CREATE TABLE UNIT_DETER_METHOD 
   (	UNIT_DETER_METHOD CHAR(10) NOT NULL ENABLE, 
	LINE_NO NUMBER(4,0) NOT NULL ENABLE, 
	MIN_QTY NUMBER(14,3), 
	MAX_QTY NUMBER(14,3), 
	UNIT CHAR(3)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;
CREATE TABLE TESTMANGESQL 
   (	TRAN_ID NUMBER, 
	TRAN_DATE DATE, 
	DESCR VARCHAR2(255)
   ) SEGMENT CREATION DEFERRED 
  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 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 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 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 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 PERIOD 
   (	ACCT_PRD CHAR(6) NOT NULL ENABLE, 
	CODE CHAR(6) NOT NULL ENABLE, 
	DESCR VARCHAR2(10) NOT NULL ENABLE, 
	FR_DATE DATE, 
	TO_DATE DATE, 
	UD_STAT VARCHAR2(10), 
	STAT_IC CHAR(1), 
	STAT_FIN CHAR(1), 
	STAT_ADM CHAR(1), 
	STAT_PUR CHAR(1), 
	STAT_SAL CHAR(1), 
	STAT_MFG CHAR(1), 
	CHG_DATE DATE NOT NULL ENABLE, 
	CHG_USER CHAR(10) NOT NULL ENABLE, 
	CHG_TERM VARCHAR2(300) NOT NULL ENABLE, 
	DOC_PREFIX VARCHAR2(5) NOT NULL ENABLE, 
	SH_DESCR VARCHAR2(20), 
	PRD_QTR CHAR(13), 
	PRD_ROUND CHAR(13), 
	PRD_QUATRET CHAR(13)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE ITM_DATA;
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;

-- No of Rows = 31
