--------------------------------------------------------
--  File created - Saturday-February-01-2014   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table CLOB_TEST
--------------------------------------------------------

  CREATE TABLE "SYSTEM"."CLOB_TEST" 
   (	"VAR_TEST" VARCHAR2(20 BYTE), 
	"CLOB_TEST" CLOB
   ) 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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM" 
 LOB ("CLOB_TEST") STORE AS BASICFILE (
  TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION 
  NOCACHE LOGGING 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
REM INSERTING into SYSTEM.CLOB_TEST
SET DEFINE OFF;
INSERT INTO "SYSTEM"."CLOB_TEST" (VAR_TEST, CLOB_TEST) VALUES ('this is a varchar', 'this is a clob');
INSERT INTO "SYSTEM"."CLOB_TEST" (VAR_TEST, CLOB_TEST) VALUES ('this is another var', 'this is another clob');
