gvSIG data provider for Oracle

-- FetchFeatureType first row SQL

SELECT * FROM "P1"."TEST" WHERE  ROWNUM <= 0;

SELECT "USER_TAB_COLS"."COLUMN_NAME", "ALL_CONSTRAINTS"."CONSTRAINT_TYPE" 

FROM USER_TAB_COLS 

JOIN ALL_CONS_COLUMNS on (ALL_CONS_COLUMNS.TABLE_NAME = USER_TAB_COLS.TABLE_NAME and ALL_CONS_COLUMNS.COLUMN_NAME = USER_TAB_COLS.COLUMN_NAME) 

LEFT JOIN ALL_CONSTRAINTS on ALL_CONSTRAINTS.CONSTRAINT_NAME = ALL_CONS_COLUMNS.CONSTRAINT_NAME 

WHERE ( 

    (( ("USER_TAB_COLS"."TABLE_NAME") LIKE ('TEST') )) 

    AND 

    (( ("ALL_CONSTRAINTS"."CONSTRAINT_TYPE") = ('P') )) 

);