By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table_name (varr SYS.ODCINUMBERLIST);
CREATE INDEX table_name__varr__idx ON table_name (varr);
ORA-02327: cannot create index on expression with datatype NAMED ARRAY TYPE
SELECT *
FROM all_types
WHERE OWNER = 'SYS'
AND TYPE_NAME = 'ODCINUMBERLIST';
| 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 |
select text
from all_source
where type = 'TYPE'
and owner = 'MDSYS'
and name = 'SDO_ORDINATE_ARRAY'
ORDER BY line
| TEXT |
|---|
| TYPE SDO_ORDINATE_ARRAY |
| |
| AS VARRAY(1048576) OF NUMBER |
select text
from all_source
where type = 'TYPE'
and owner = 'MDSYS'
and name = 'SDO_GEOMETRY'
ORDER BY line
| 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 |