Oracle ODCIVARCHAR2LIST
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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'));

Related Topics
Built-in Functions
Built-in Packages
Database Security
OdciArgDescList
OdciBFileList
OdciColInfoList
OdciDateList
OdciNumberList
OdciObjectList
OdciPatInfoList
OdciRawList
OdciRidList
DBMS_ODCI
ODCICONST
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx