add remove split language show hidden hide
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ORA-02327: cannot create index on expression with datatype NAMED ARRAY TYPE
OWNER TYPE_NAME TYPE_OID TYPECODE ATTRIBUTES METHODS PREDEFINED INCOMPLETE FINAL INSTANTIABLE PERSISTABLE SUPERTYPE_OWNER SUPERTYPE_NAME LOCAL_ATTRIBUTES LOCAL_METHODS TYPEID
SYS ODCINUMBERLIST 0xC9CAE027DEC46FE1E0532783E80AB721 COLLECTION 0 0 NO NO YES YES YES null null null null 0x
TEXT
TYPE SDO_ORDINATE_ARRAY
                                                                      
AS VARRAY(1048576) OF NUMBER
TEXT
TYPE SDO_GEOMETRY AS OBJECT (
           SDO_GTYPE NUMBER,
           SDO_SRID NUMBER,
           SDO_POINT SDO_POINT_TYPE,
           SDO_ELEM_INFO SDO_ELEM_INFO_ARRAY,
           SDO_ORDINATES SDO_ORDINATE_ARRAY,
           MEMBER FUNCTION GET_GTYPE
           RETURN NUMBER DETERMINISTIC PARALLEL_ENABLE,
           MEMBER FUNCTION GET_DIMS
           RETURN NUMBER DETERMINISTIC PARALLEL_ENABLE,
           MEMBER FUNCTION GET_LRS_DIM
           RETURN NUMBER DETERMINISTIC PARALLEL_ENABLE)
 
  ALTER TYPE SDO_GEOMETRY
  ADD MEMBER FUNCTION GET_WKB RETURN BLOB DETERMINISTIC PARALLEL_ENABLE,
  ADD MEMBER FUNCTION GET_WKT RETURN CLOB DETERMINISTIC PARALLEL_ENABLE,
  ADD MEMBER FUNCTION ST_CoordDim RETURN SMALLINT DETERMINISTIC
    PARALLEL_ENABLE ,
  ADD MEMBER FUNCTION ST_IsValid RETURN INTEGER DETERMINISTIC PARALLEL_ENABLE,
  ADD MEMBER FUNCTION GET_GML RETURN CLOB
    DETERMINISTIC PARALLEL_ENABLE,
  ADD MEMBER FUNCTION GET_GML(srsNameSpace IN varchar2,
    srsNSAlias IN varchar2) RETURN CLOB DETERMINISTIC PARALLEL_ENABLE,
  ADD MEMBER FUNCTION GET_GML(coordOrder IN number)
    RETURN CLOB DETERMINISTIC PARALLEL_ENABLE,
  ADD MEMBER FUNCTION GET_GML(srsNameSpace IN varchar2,
    srsNSAlias IN varchar2, coordOrder IN number)
    RETURN CLOB DETERMINISTIC PARALLEL_ENABLE,
  ADD MEMBER FUNCTION GET_GML311 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE,
  ADD MEMBER FUNCTION GET_GML311(srsNameSpace IN varchar2,
    srsNSAlias IN varchar2) RETURN CLOB DETERMINISTIC PARALLEL_ENABLE,
  ADD MEMBER FUNCTION GET_GML311(coordOrder IN number) RETURN CLOB
    DETERMINISTIC PARALLEL_ENABLE,
  ADD MEMBER FUNCTION GET_GML311(srsNameSpace IN varchar2,
    srsNSAlias IN varchar2, coordOrder IN number)
    RETURN CLOB DETERMINISTIC PARALLEL_ENABLE,
  ADD MEMBER FUNCTION GET_GML321 RETURN CLOB DETERMINISTIC PARALLEL_ENABLE,
  ADD MEMBER FUNCTION GET_GML321(srsNameSpace IN varchar2,
    srsNSAlias IN varchar2) RETURN CLOB DETERMINISTIC PARALLEL_ENABLE,
  ADD MEMBER FUNCTION GET_GML321(coordOrder IN number)
    RETURN CLOB DETERMINISTIC PARALLEL_ENABLE,
  ADD MEMBER FUNCTION GET_GML321(srsNameSpace IN varchar2,
    srsNSAlias IN varchar2, coordOrder IN number)
    RETURN CLOB DETERMINISTIC PARALLEL_ENABLE,
  ADD MEMBER FUNCTION GET_KML RETURN CLOB DETERMINISTIC PARALLEL_ENABLE,
  ADD MEMBER FUNCTION GET_GEOJSON RETURN CLOB DETERMINISTIC PARALLEL_ENABLE,
  ADD CONSTRUCTOR FUNCTION SDO_GEOMETRY(wkt IN CLOB,
    srid IN INTEGER DEFAULT NULL) RETURN SELF AS RESULT
    DETERMINISTIC PARALLEL_ENABLE,
  ADD CONSTRUCTOR FUNCTION SDO_GEOMETRY(wkt IN VARCHAR2,
    srid IN INTEGER DEFAULT NULL) RETURN SELF AS RESULT
    DETERMINISTIC PARALLEL_ENABLE,
  ADD CONSTRUCTOR FUNCTION SDO_GEOMETRY(wkb IN BLOB,
    srid IN INTEGER DEFAULT NULL) RETURN SELF AS RESULT
    DETERMINISTIC PARALLEL_ENABLE,
  ADD CONSTRUCTOR FUNCTION SDO_GEOMETRY(input_clob IN clob,
    auxiliary_info IN varchar2, crs IN VARCHAR2 DEFAULT NULL)
    RETURN SELF AS RESULT DETERMINISTIC PARALLEL_ENABLE,
  ADD CONSTRUCTOR FUNCTION SDO_GEOMETRY(input_vchar IN varchar2,
    auxiliary_info IN varchar2, crs IN VARCHAR2 DEFAULT NULL)
    RETURN SELF AS RESULT DETERMINISTIC PARALLEL_ENABLE
  CASCADE