gvSIG data provider for Oracle

-- Insert SQL

INSERT INTO "P1"."TEST" ( 

    "ID", "Byte", "Bool1", "Long", "Timestamp", "Date", "Time", 

    "Bool2", "String", "Bool3", "Double", "Bool4", "Float", "Bool5", 

    "Decimal", "Geometry" 

) VALUES ( 

    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NVL2((?),SDO_GEOMETRY((?), (?)),NULL) 

);

-- Delete SQL

DELETE FROM "P1"."TEST" WHERE ( ("ID") = (?) );

-- Update SQL

UPDATE "P1"."TEST" 

    SET 

        "Byte" = ?, 

        "Bool1" = ?, 

        "Long" = ?, 

        "Timestamp" = ?, 

        "Date" = ?, 

        "Time" = ?, 

        "Bool2" = ?, 

        "String" = ?, 

        "Bool3" = ?, 

        "Double" = ?, 

        "Bool4" = ?, 

        "Float" = ?, 

        "Bool5" = ?, 

        "Decimal" = ?, 

        "Geometry" = NVL2((?),SDO_GEOMETRY((?), (?)),NULL) 

    WHERE 

        ( ("ID") = (?) );

-- Update Table SQL

ALTER TABLE "P1"."TEST" ADD "Byte" NUMBER(3,0) DEFAULT NULL NULL;

ALTER TABLE "P1"."TEST" ADD "Bool1" CHAR(1) DEFAULT NULL NULL;

ALTER TABLE "P1"."TEST" ADD "Long" NUMBER(18,0) DEFAULT NULL NULL;

ALTER TABLE "P1"."TEST" ADD "Timestamp" TIMESTAMP DEFAULT NULL NULL;

ALTER TABLE "P1"."TEST" ADD "Date" DATE DEFAULT NULL NULL;

ALTER TABLE "P1"."TEST" ADD "Time" TIMESTAMP DEFAULT NULL NULL;

ALTER TABLE "P1"."TEST" ADD "Bool2" CHAR(1) DEFAULT NULL NULL;

ALTER TABLE "P1"."TEST" ADD "String" NVARCHAR2(30) DEFAULT NULL NULL;

ALTER TABLE "P1"."TEST" ADD "Bool3" CHAR(1) DEFAULT NULL NULL;

ALTER TABLE "P1"."TEST" ADD "Double" BINARY_DOUBLE DEFAULT NULL NULL;

ALTER TABLE "P1"."TEST" ADD "Bool4" CHAR(1) DEFAULT NULL NULL;

ALTER TABLE "P1"."TEST" ADD "Float" BINARY_FLOAT DEFAULT NULL NULL;

ALTER TABLE "P1"."TEST" ADD "Bool5" CHAR(1) DEFAULT NULL NULL;

ALTER TABLE "P1"."TEST" ADD "Decimal" NUMBER(6,3) DEFAULT NULL NULL;

ALTER TABLE "P1"."TEST" ADD "Geometry" SDO_GEOMETRY DEFAULT NULL NULL;

DELETE FROM MDSYS.OGIS_GEOMETRY_COLUMNS 

    WHERE F_TABLE_SCHEMA = 'P1' 

    AND F_TABLE_NAME = 'test' 

    AND F_GEOMETRY_COLUMN = 'Geometry';

INSERT INTO MDSYS.OGIS_GEOMETRY_COLUMNS (

    F_TABLE_SCHEMA, F_TABLE_NAME, F_GEOMETRY_COLUMN, GEOMETRY_TYPE) 

    VALUES ('P1', 'test', 'Geometry', 1001);