Oracle Built-In Arrays
Version 11.2.0.2
 
General Information
Through the years, and many examples, I have run into numerous built in arrays in the Oracle database that might prove really valuable if you could find them when you need them instead of declaring something new every time. This page serves as a collection point. If you find one not listed here please let me know about it.
Source Definition
Types
Owner Rows Data Type DDL
SYS N/A INTEGER MVSCHEDULEDEPENDENCIES AS TABLE OF INTEGER;
SYS N/A INTEGER ora_mining_number_nt AS table OF NUMBER;
SYSMAN N/A INTEGER MGMT_INTEGER_TABLE AS TABLE OF INTEGER;
SYSMAN N/A INTEGER numTableType IS TABLE OF NUMBER;
SYSMAN N/A INTEGER SMP_EMD_INTEGER_ARRAY AS TABLE OF INTEGER;
APEX_030200 N/A NUMBER wwv_flow_tree_num_arr AS TABLE OF NUMBER NOT NULL;
EXFSYS N/A NUMBER rlm$numval IS TABLE OF NUMBER;
MDSYS N/A NUMBER SDO_NUMTAB AS TABLE OF NUMBER;
MDSYS N/A NUMBER SDONUMLIST IS TABLE OF NUMBER;
SYS N/A NUMBER AWRRPT_INSTANCE_LIST_TYPE AS TABLE OF NUMBER
SYS N/A NUMBER ku$_XmlColSet_t IS TABLE OF NUMBER;
SYS N/A NUMBER ku$_ObjNumSet IS TABLE OF NUMBER;
SYSMAN N/A RAW CSTMZ_GUID_ARRAY AS TABLE OF RAW(16);
SYSMAN N/A RAW GUID_ARRAY AS TABLE OF RAW(16);
SYSMAN N/A RAW MGMT_BCN_RAW_GUID_ARRAY  AS TABLE OF RAW(16);
SYSMAN N/A RAW MGMT_BLACKOUT_GUID_ARRAY AS TABLE OF RAW(16);
SYSMAN N/A RAW MGMT_BLACKOUT_TGT_GUID_ARRAY AS TABLE OF RAW(16);
SYSMAN N/A RAW MGMT_CS_GUID_ARRAY IS TABLE OF RAW(16);
SYSMAN N/A RAW MGMT_GENSVC_GUID_ARRAY IS TABLE OF RAW(16);
SYSMAN N/A RAW MGMT_IP_TGT_GUID_ARRAY AS TABLE OF RAW(16);
SYSMAN N/A RAW MGMT_JOB_GUID_ARRAY AS TABLE OF RAW(16);
SYSMAN N/A RAW mgmt_member_guids AS TABLE OF RAW(16);
SYSMAN N/A RAW MGMT_TARGET_GUID_ARRAY AS TABLE OF RAW(16);
SYSMAN N/A RAW MGMT_USER_GUID_ARRAY IS TABLE OF RAW(16);
EXFSYS N/A TIMESTAMP rlm$dateval IS TABLE OF TIMESTAMP;
SYSMAN N/A VARCHAR2(10) MGMT_CREDS_SOUTPUT AS TABLE OF VARCHAR2(10);
MDSYS N/A VARCHAR2(24) sdoridtable AS TABLE OF VARCHAR2(24);
SYS N/A VARCHAR2(30); HSBLKNamLst AS TABLE OF VARCHAR2(30);
SYSMAN N/A VARCHAR2(30); ECM_GENDIFF_TABLENAME_TABLE AS TABLE OF VARCHAR2(30);
SYSMAN N/A VARCHAR2(32); HA_HOST_CREDS_SET_ARR IS TABLE OF VARCHAR2(32);
SYSMAN N/A VARCHAR2(32); MGMT_BCN_GUID_ARRAY AS TABLE OF VARCHAR2(32);
SYSMAN N/A VARCHAR2(32); MGMT_BCN_STEPGROUPID_ARRAY AS TABLE OF VARCHAR2(32);
SYSMAN N/A VARCHAR2(32) MGMT_GENSVC_OBJID_ARRAY IS TABLE OF VARCHAR2(32);
EXFSYS N/A VARCHAR2(38) rlm$rowidtab IS TABLE OF VARCHAR2(38);
SYSMAN N/A VARCHAR2(64) CHARTABLETYPE AS TABLE OF VARCHAR2(64);
SYSMAN N/A VARCHAR2(64) MGMT_BCN_NAME_ARRAY AS TABLE OF VARCHAR2(64);
SYSMAN N/A VARCHAR2(64) MGMT_BCN_PNAMES_ARRAY AS TABLE OF VARCHAR2(64);
SYSMAN N/A VARCHAR2(64) MGMT_BCN_STEPID_ARRAY AS TABLE OF VARCHAR2(64);
SYSMAN N/A VARCHAR2(64) MGMT_CATEGORY_PROP_ARRAY IS TABLE OF VARCHAR2(64);
SYSMAN N/A VARCHAR2(64) MGMT_CS_KEYWORD_ARRAY IS TABLE OF VARCHAR2(64);
SYSMAN N/A VARCHAR2(64) MGMT_IP_STRING_ARRAY AS TABLE OF VARCHAR(64);
SYSMAN N/A VARCHAR2(64) MGMT_IP_TARGET_TYPES as TABLE OF VARCHAR(64);
SYSMAN N/A VARCHAR2(64) MGMT_SHORT_STRING_TABLE AS TABLE OF VARCHAR2(64);
SYSMAN N/A VARCHAR2(64) MGMT_SWLIB_PLATFORM_LIST IS TABLE OF VARCHAR2(64);
EXFSYS N/A VARCHAR2(110) namelist IS TABLE OF VARCHAR2(110);
SYSMAN N/A VARCHAR2(128) mgmt_dm_array_list AS TABLE OF VARCHAR2(128);
SYSMAN N/A VARCHAR2(128) MGMT_CREDS_LOUTPUT AS TABLE OF VARCHAR2(128);
SYSMAN N/A VARCHAR2(255) MGMT_SWLIB_PATH_LIST IS TABLE OF VARCHAR2(255);
SYSMAN N/A VARCHAR2(256) MgmtChrnsRegionMembers AS TABLE OF VARCHAR2(256);
SYSMAN N/A VARCHAR2(256) MgmtChrnsAnlzFxdAxesMembers AS TABLE OF VARCHAR2(256);
SYSMAN N/A VARCHAR2(256) MGMT_MEDIUM_STRING_TABLE AS TABLE OF VARCHAR2(256);
SYSMAN N/A VARCHAR2(256) SMP_EMD_STRING_ARRAY AS TABLE OF VARCHAR2(256);
SYSMAN N/A VARCHAR2(256) STORAGE_VARCHAR2_TABLE IS TABLE OF VARCHAR2(256);
SYSMAN N/A VARCHAR2(256) TARGET_METRIC_TABLE is table of varchar2(256);
SYSMAN N/A VARCHAR2(256) TOKEN_LIST IS TABLE OF VARCHAR2(256);
SYSMAN N/A VARCHAR2(256) VARCHAR2_TABLE AS TABLE OF VARCHAR2(256);
SYSMAN N/A VARCHAR2(512) MGMT_GENSVC_TGT_NAME_ARRAY IS TABLE OF VARCHAR2(512);
SYSMAN N/A VARCHAR2(512) MGMT_GENSVC_VAR_NAME_ARRAY IS TABLE OF VARCHAR2(512);
EXFSYS N/A VARCHAR2(1000) rlm$keyval IS TABLE OF VARCHAR2(1000);
SYS N/A VARCHAR2(1000) DBMS_DEBUG_VC2COLL TABLE OF VARCHAR2(1000);
SYSMAN N/A VARCHAR2(1000) MGMT_IP_PARAM_CLASSES as TABLE OF VARCHAR(1000);
SYSMAN N/A VARCHAR2(1024) EMDSYSTEM_ARGS IS TABLE OF VARCHAR2(1024);
SYSMAN N/A VARCHAR2(1024) MGMT_CS_CHOICE_LIST_ARRAY IS TABLE OF VARCHAR2(1024);
SYSMAN N/A VARCHAR2(1024) SMP_EMD_LONG_STRING_ARRAY AS TABLE OF VARCHAR2(1024);
MDSYS N/A VARCHAR2(4000) RowPointerList IS TABLE OF VARCHAR2(4000)
SYS N/A VARCHAR2(4000) KU$_VCNT AS TABLE OF VARCHAR2(4000);
SYS N/A VARCHAR2(4000) ORA_MINING_VARCHAR2_NT AS TABLE OF VARCHAR2(4000);
SYSMAN N/A VARCHAR2(4000) emxCellStringAggCollectType AS TABLE OF VARCHAR2(4000);
SYSMAN N/A VARCHAR2(4000) MGMT_STORAGE_STRING_TABLE AS TABLE OF VARCHAR2(4000);
SYSMAN N/A VARCHAR2(4000) SMP_EMD_LARGE_STRING_ARRAY AS TABLE OF VARCHAR2(4000);
SYSMAN N/A VARCHAR2(4000) VARCHAR_TABLE AS TABLE OF VARCHAR2(2500);
APEX_030200 N/A VARCHAR2(32767) VC4000ARRAY AS TABLE OF VARCHAR2(32767);
Varrays
Owner Rows Data Type DDL
SYS 32 SYS.ANYDATA ODCICOLVALLIST AS VARRAY(32) OF SYS.ANYDATA;
SYS 32767 BFILE ODCIBFILELIST AS VARRAY(32767) OF BFILE;
SYS 1000000 BINARY_DOUBLE UTL_NLA_ARRAY_DBL is VARRAY(1000000) OF BINARY_DOUBLE;
SYS 1000000 BINARY_FLOAT UTL_NLA_ARRAY_FLT is VARRAY(1000000) OF BINARY_FLOAT;
ORDSYS 5 BINARY PRECISION TEXTUREENCODING AS VARRAY(5) OF DOUBLE PRECISION;
ORDSYS 27 BINARY PRECISION FLAT_COLORPOSITIONS AS VARRAY(27) OF DOUBLE PRECISION;
SYSMAN 128 CHAR(1) ECM_GENDIFF_RES_ARRAY AS VARRAY(128) OF CHAR(1);
SYS 30 CLOB AWRRPT_CLB_ARY IS VARRAY(30) OF CLOB;
EXFSYS 100 DATE EXF$XPDATELST IS VARRAY(100) OF DATE;
SYS 32767 DATE ODCIDATELIST AS VARRAY(32767) OF DATE;
MDSYS 1048576 DOUBLE PRECISION ST_DOUBLE_PRECISION_ARRAY AS VARRAY(1048576) OF DOUBLE PRECISION;
ORDSYS 3 INTEGER FLAT_AVERAGECOLOR AS VARRAY(3) OF INTEGER;
SYS 1000 INTEGER SCHEDULER$_INT_ARRAY_TYPE IS VARRAY (1000) OF INTEGER;
SYSMAN 5000 INTEGER MGMT_INTEGER_ARRAY AS VARRAY(5000) OF INTEGER;
SYSMAN 5000 INTEGER MGMT_JOB_INT_ARRAY AS VARRAY(5000) OF INTEGER;
SYS 1000000 INTEGER UTL_NLA_ARRAY_INT IS VARRAY(1000000) OF INTEGER;
SYS 30 NUMBER AWRRPT_NUM_ARY IS VARRAY(30) OF NUMBER;
EXFSYS 32 NUMBER RLM$APNUMBLST IS VARRAY(32) OF NUMBER;
MDSYS 64 NUMBER SDO_VPOINT_TYPE AS VARRAY(64) OF NUMBER;
EXFSYS 100 NUMBER EXF$XPNUMBLST IS VARRAY(100) OF NUMBER;
EXFSYS 100 NUMBER EXF$XPPOSLST IS VARRAY(100) OF NUMBER;
MDSYS 100 NUMBER NUM_ARRAY AS VARRAY(100) OF NUMBER;
SYS 100 NUMBER DBMS_UADV_ARR AS VARRAY(100) of NUMBER;
SYS 999 NUMBER JDM_NUM_VALS IS VARRAY (999) OF NUMBER NOT NULL;
SYS 2000 NUMBER SQL_OBJECTS AS VARRAY(2000) OF NUMBER;
SYS 5000 NUMBER DBMS_XS_PRIVID_LIST AS VARRAY(5000) OF NUMBER;
SYS 32767 NUMBER ODCINumberList AS VARRAY(32767) OF NUMBER;
SYS 65536 NUMBER ODCIGRANULELIST AS VARRAY(65535) OF NUMBER;
MDSYS 1048576 NUMBER SDO_SRID_CHAIN AS VARRAY(1048576) OF NUMBER;
MDSYS 1048576 NUMBER SDO_ELEM_INFO_ARRAY AS VARRAY (1048576) OF NUMBER;
MDSYS 1048576 NUMBER SDO_SRID_LIST AS VARRAY(1048576) OF NUMBER;
MDSYS 2147483647 NUMBER SDO_LIST_TYPE AS VARRAY (2147483647) OF NUMBER;
SYS 100 RAW XID_ARRAY TYPE XID_ARRAY AS VARRAY(100) OF RAW(8);
SYS 32767 RAW ODCIRAWLIST AS VARRAY(32767) OF RAW(2000);
SYS 32767 RAW GENRAWSEQUENCE AS VARRAY(32767) OF RAW(32767);
EXFSYS 20 VARCHAR2(15) EXF$INDEXOPER AS VARRAY(20) OF VARCHAR2(15);
OE 5 VARCHAR2(25) PHONE_LIST_TYP AS VARRAY(5) OF VARCHAR2(25);
SYS 1024 VARCHAR2(30) RE$NAME_ARRAY AS VARRAY(1024) OF VARCHAR2(30);
SYS 100 VARCHAR2(30) FLASHBACKTBLIST AS VARRAY(100) OF VARCHAR2(30);
EXFSYS 32 VARCHAR2(32) RLM$EQUALATTR AS VARRAY(32) OF VARCHAR2(32);
EXFSYS 1000 VARCHAR2(32) EXF$EXPFUNCREFS IS VARRAY(1000) OF VARCHAR2(32);
MDSYS 1048576 VARCHAR2(32) SDO_STRING_ARRAY AS VARRAY(1048576) OF VARCHAR2(32);
WMSYS 50 VARCHAR2(50) IntToStr_array_type IS VARRAY(50) OF VARCHAR2(50);
SYS 999 VARCHAR2(60) JDM_ATTR_NAMES IS VARRAY (999) OF VARCHAR2(60) NOT NULL;
SYSMAN 20 VARCHAR2(64) METRIC_COLUMN_ARRAY AS VARRAY(20) OF VARCHAR2(64);
SYSMAN 1000 VARCHAR2(64) SEVERITY_GUID_ARRAY IS VARRAY(1000) OF VARCHAR2(64);
SYSMAN 5000 VARCHAR2(64) MGMT_SHORT_STRING_ARRAY AS VARRAY(5000) OF VARCHAR2(64);
MDSYS 1048576 VARCHAR2(64) OPENLS_ORDINATES AS VARRAY(1048576) OF VARCHAR2(64);
ORDSYS 2147483647 VARCHAR2(64 CHAR) NAME260_COLL AS VARRAY(2147483647) OF VARCHAR2(64 CHAR)
ORDSYS 2147483647 VARCHAR2(64 CHAR) NAME340_COLL AS VARRAY(2147483647) OF VARCHAR2(64 CHAR)
ORDSYS 2147483647 VARCHAR2(64 CHAR) NAME420_COLL AS VARRAY(2147483647) OF VARCHAR2(64 CHAR)
SYS 1024 VARCHAR2(65) RE$RULE_LIST AS VARRAY(1024) OF VARCHAR2(65);
SYS 30 VARCHAR2(80 CHAR) AWRRPT_VCH_ARY IS VARRAY(30) OF VARCHAR2(80 CHAR);
EXFSYS 32 VARCHAR2(100) RLM$APVARCLST IS VARRAY(32) OF VARCHAR2(100);
WMSYS 15 VARCHAR2(100) trigOptionsType IS VARRAY(15) OF VARCHAR2(100);
ORDSYS 2147483647 VARCHAR2(128 CHAR) NAME521_COLL AS VARRAY(2147483647) OF VARCHAR2(128 CHAR);
SYSMAN 5 VARCHAR2(256) MGMT_KEY_VALUE_OBJ AS VARRAY(5) OF VARCHAR2(256);
SYS 100 VARCHAR2(256) TXNAME_ARRAY AS VARRAY(100) OF VARCHAR2(256);
SYSMAN 5000 VARCHAR2(256) MGMT_MEDIUM_STRING_ARRAY AS VARRAY(5000) OF VARCHAR2(256);
MDSYS 1048576 VARCHAR2(256) STRING_ARRAY AS VARRAY(1048576) OF VARCHAR2(256);
EXFSYS 100 VARCHAR2(500) EXF$XPVARCLST IS VARRAY(100) OF VARCHAR2(500);
SYS 2000 VARCHAR2(500) SQLPROF_ATTR AS VARRAY(2000) OF VARCHAR2(500);
SYS 4000 VARCHAR2(1000) KUPC$_LOBPIECES AS VARRAY(4000) OF VARCHAR2(1000);
XDB 1000 VARCHAR2(1024) XDB XDB$ENUM_VALUES_T AS VARRAY(1000) of VARCHAR2(1024);
SYS 4096 VARCHAR2(1024) DBMS_XS_ROLELIST IS VARRAY(4096) OF VARCHAR2(1024);
SYSMAN 5000 VARCHAR2(1024) MGMT_LONG_STRING_ARRAY AS VARRAY(5000) OF VARCHAR2(1024);
SYSMAN 5000 VARCHAR2(2000) MGMT_JOB_VECTOR_PARAMS AS VARRAY(5000) OF VARCHAR2(2000);
ORDSYS 2147483647 VARCHAR2(4000 CHAR) supplementalCategory498_COLL AS VARRAY(2147483647) OF VARCHAR2(4000 CHAR);
SYSMAN 128 VARCHAR2(4000) ECM_GENDIFF_KEYVALUE_ARRAY AS VARRAY(128) OF VARCHAR2(4000);
SYS 250 VARCHAR2(4000) HSBLKVALARY AS VARRAY(250) OF VARCHAR2(4000);
SYS 999 VARCHAR2(4000) NOT NULL JDM_STR_VALS IS VARRAY (999) OF VARCHAR2(4000) NOT NULL;
SYS 1000 VARCHAR2(4000) KU$_DROPCOLLIST AS VARRAY(1000) OF VARCHAR2(4000);
SYSMAN 5000 VARCHAR2(4000) MGMT_MAX_STRING_ARRAY AS VARRAY(5000) OF VARCHAR2(4000);
SYS 32767 VARCHAR2(4000) ODCIVARCHAR2LIST AS VARRAY(32767) OF VARCHAR2(4000);
XDB 2147483647 VARCHAR2(4000) XDB XDB$STRING_LIST_T AS VARRAY(2147483647) OF VARCHAR2(4000);
XDB 2147483647 VARCHAR2(4000 CHAR) ChildName35_COLL AS VARRAY(2147483647) OF VARCHAR2(4000 CHAR);
MDSYS 2147483647 VARCHAR2(4000 CHAR) Coordinate719_COLL AS VARRAY(2147483647) OF VARCHAR2(4000 CHAR);
MDSYS 2147483647 VARCHAR2(4000 CHAR) Logo741_COLL AS VARRAY(2147483647) OF VARCHAR2(4000 CHAR);
MDSYS 2147483647 VARCHAR2(4096) SDO_STRING2_ARRAY AS VARRAY(2147483647) OF VARCHAR2(4096);
SYS 32767 VARCHAR2(5072) ODCIRIDLIST AS VARRAY(32767) OF VARCHAR2(5072);
MDSYS 10000 VARCHAR2(9000) SDO_KEYWORDARRAY as VARRAY(10000) OF VARCHAR2(9000);
SYS 32767 VARCHAR2(10922) GENWSTRINGSEQUENCE AS VARRAY(32767) OF NVARCHAR2(10922);
SYS 2147483647 VARCHAR2(32767) DBMSOUTPUT_LINESARRAY IS VARRAY(2147483647) OF VARCHAR2(32767);
 
Related Topics
Arrays
Array Processing
Collections
DBMS_SQL
VARRAYS
 
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-2013 Daniel A. Morgan All Rights Reserved