Title: SQL

SQL

CREATE TABLE "ICT"."IMS" ("ID_IMS" NUMBER(6) NOT NULL, "IMSNAME"  

    VARCHAR2(255) NOT NULL, "EVALUATOR" VARCHAR2(255), "ORGANISM"

    VARCHAR2(255), "DATEOFEVALUATION" DATE, "REFERENCE"

    VARCHAR2(255), "VERSION" VARCHAR2(255), "MANUFACTURER"

    VARCHAR2(255), "NATURE" VARCHAR2(255), "COUNTRY"

    VARCHAR2(255), "GEOGSCOP" VARCHAR2(255), "LANGUAGE"

    VARCHAR2(255), "STATE" VARCHAR2(255), "OPEN_CLOSED"

    VARCHAR2(255), "REQUIREMENT" VARCHAR2(2000), "USERBASE"

    VARCHAR2(255), "STANDARD" VARCHAR2(255), "SERVER"

    VARCHAR2(255), "CONTROL" VARCHAR2(2000), "CLIENT"

    VARCHAR2(255), "SEALS" VARCHAR2(3), "WHICHSEAL" VARCHAR2(255),

    "VAL3RDPARTY" VARCHAR2(3), "WHICH3RD" VARCHAR2(255),

    "FEATURES" VARCHAR2(4000), "SCREENSHOT" VARCHAR2(255),

    "FLOWCHART" VARCHAR2(255), "PRICE" NUMBER(15), "TYPEIMS"

    VARCHAR2(255), "IMSCLASS" VARCHAR2(255), "IMSFUNCTION"

    VARCHAR2(255), "SUGGESTIONS" VARCHAR2(4000), "COSTCOMMENT"

    VARCHAR2(255),

    CONSTRAINT "SYS_C003268_1_1" PRIMARY KEY("ID_IMS")

    USING INDEX  

    TABLESPACE "T_ICT"

    STORAGE ( INITIAL 10K NEXT 10K MINEXTENTS 1 MAXEXTENTS 121

    PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1) PCTFREE 10

INITRANS 2 MAXTRANS 255,

    CONSTRAINT "SYS_C003269_1_1" UNIQUE("ID_IMS"),

    CONSTRAINT "SYS_C003270_1_1" UNIQUE("IMSNAME")

USING INDEX

    TABLESPACE "T_ICT"

    STORAGE ( INITIAL 10K NEXT 10K MINEXTENTS 1 MAXEXTENTS 121

    PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1) PCTFREE 10

INITRANS 2 MAXTRANS 255)

    TABLESPACE "T_ICT" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS

255

    STORAGE ( INITIAL 10K NEXT 24K MINEXTENTS 1 MAXEXTENTS 121

    PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1)

    LOGGING