ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
DDL
CREATE OR REPLACE TYPE ODCIVarchar2List FORCE
OID '0000000000000000000000000002121C' AS VARRAY(32767) OF VARCHAR2(4000);
/
Dependencies
CTX_DDL
RDF_APIS
SEM_RDFCTX_DR
CTX_QUERY
RDF_APIS_INTERNAL
SEM_RDFCTX_IR
DBMS_ISCHED
RDF_MATCH_IMPL_T
SEM_RDFSA_DR
DBMS_SCHEDULER
SDO_RDF
S_SDO_RDF_INFO
DRVDML
SDO_RDF_INTERNAL
S_SDO_RDF_INTERNAL
DRVLSB
SDO_RDF_JAVA_STP
S_SDO_RDF_QUERY
DRVPARX
SDO_SEM_INF_INTERNAL
S_SEM_RDFCTX_DR
PRLLIDX_CREATE
SEM_OLS
S_SEM_RDFSA_DR
Documented
No
First Available
Not Known
Security Model
Owned by SYS with EXECUTE granted to PUBLIC
Source
{ORACLE_HOME}/rdbms/admin/catodci.sql
Demo
Type Usage Demo
conn uwclass/uwclass@pdbdev
col program_id format a11
SELECT DISTINCT program_id
FROM airplanes
INTERSECT
SELECT *
FROM TABLE(sys.OdciVarchar2List('717', '727', '737', '747'));
