Oracle OdciVarchar2List
Version 11.2.0.3

General Information
Purpose Varray of VARCHAR2(4000)s
Dependencies
CTX_DDL DBMS_SCHEDULER DRVPARX
DBMS_ISCHED DRVDML  
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source CREATE OR REPLACE TYPE SYS.ODCIVARCHAR2LIST
AS VARRAY(32767) OF VARCHAR2(4000);
 
Demo
Type Usage Demo conn uwclass/uwclass

SELECT DISTINCT program_id
FROM airplanes
INTERSECT
SELECT *
FROM TABLE(sys.OdciVarchar2List('717', '727', '737', '747'));

Related Topics
OdciArgDescList
OdciBFileList
OdciColInfoList
OdciDateList
OdciNumberList
OdciObjectList
OdciPatInfoList
OdciRawList
OdciRidList

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: © 2012 Daniel A. Morgan All Rights Reserved