Oracle Built-In Arrays
Version 11.2
 
General Information
Through the years, and 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
SYSMAN N/A VARCHAR2(32) MGMT_GENSVC_OBJID_ARRAY IS TABLE OF VARCHAR2(32);
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(256) SMP_EMD_STRING_ARRAY 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);
SYS N/A VARCHAR2(1000) DBMS_DEBUG_VC2COLL TABLE OF VARCHAR2(1000);
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);
SYSMAN N/A VARCHAR2(4000) SMP_EMD_LARGE_STRING_ARRAY AS TABLE OF VARCHAR2(4000);
 Varrays
Owner Rows Data Type DDL
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 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);
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) NAME406_COLL AS VARRAY(2147483647) OF VARCHAR2(64 CHAR);
ORDSYS 2147483647 VARCHAR2(64 CHAR) NAME486_COLL AS VARRAY(2147483647) OF VARCHAR2(64 CHAR);
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);
ORDSYS 2147483647 VARCHAR2(128 CHAR) NAME587_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);
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);
ORDSYS 2147483647 VARCHAR2(1999 CHAR) ATTRIBUTE_TAG577_COLL AS VARRAY(2147483647) OF VARCHAR2(1999 CHAR);
SYSMAN 128 VARCHAR2(4000) ECM_GENDIFF_KEYVALUE_ARRAY AS VARRAY(128) OF VARCHAR2(4000);
SYS 999 VARCHAR2(4000) JDM_STR_VALS IS VARRAY (999) OF VARCHAR2(4000) NOT NULL;
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 CHAR) ChildName35_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);
 
 
Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: