text: --------------------------------------------------------
  --  File created - Tuesday-July-10-2012   
  --------------------------------------------------------
  --------------------------------------------------------
  --  DDL for Table EMPLOYEES
  --------------------------------------------------------
  
    CREATE TABLE "MULEDEMO"."EMPLOYEES" 
     (	"ID" NUMBER, 
  	"FIRSTNAME" VARCHAR2(50 BYTE), 
  	"LASTNAME" VARCHAR2(20 BYTE), 
  	"STATUS" VARCHAR2(20 BYTE)
     ) SEGMENT CREATION IMMEDIATE 
    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 "USERS" ;
  REM INSERTING into MULEDEMO.EMPLOYEES
  SET DEFINE OFF;
  Insert into MULEDEMO.EMPLOYEES (ID,FIRSTNAME,LASTNAME,STATUS) values (1,'Jesus','De Oliveira','ACTIVE');
  Insert into MULEDEMO.EMPLOYEES (ID,FIRSTNAME,LASTNAME,STATUS) values (2,'John ','Doe','ACTIVE');
  Insert into MULEDEMO.EMPLOYEES (ID,FIRSTNAME,LASTNAME,STATUS) values (3,'Jane','Doe','ACTIVE');
  --------------------------------------------------------
  --  DDL for Index EMPLOYEES_PK
  --------------------------------------------------------
  
    CREATE UNIQUE INDEX "MULEDEMO"."EMPLOYEES_PK" ON "MULEDEMO"."EMPLOYEES" ("ID") 
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
    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 "USERS" ;
  --------------------------------------------------------
  --  Constraints for Table EMPLOYEES
  --------------------------------------------------------
  
    ALTER TABLE "MULEDEMO"."EMPLOYEES" ADD CONSTRAINT "EMPLOYEES_PK" PRIMARY KEY ("ID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
    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 "USERS"  ENABLE;
    ALTER TABLE "MULEDEMO"."EMPLOYEES" MODIFY ("ID" NOT NULL ENABLE);
  
  