Databases Reference
In-Depth Information
CLOB001 CLOB
BLOB001 BLOB
MD5 ORIGINAL VARCHAR2(4000)
SECURITY GROUP ID NOT NULL NUMBER
XMLTYPE001 SYS.XMLTYPE STORAGE BINARY
Public Collections Objects Inside the APEX Engine
As already said, APEX exposes its collection data to developers using in the form of the
APEX COLLECTIONS
public synonym. A quick glance at Listing 10-3 shows that the view associated with
APEX COLLECTIONS
,
WWV FLOW COLLECTIONS
, closely mirrors the columns in the
WWV FLOW COLLECTION MEMBERS$
table.
Listing 10-3.
Description of the APEX_COLLECTIONS View
SQL> desc APEX COLLECTIONS
Name Null? Type
----------------------------------------- -------- ----------------------------
COLLECTION NAME NOT NULL VARCHAR2(255)
SEQ ID NOT NULL NUMBER
C001 VARCHAR2(4000)
C002 VARCHAR2(4000)
C003 VARCHAR2(4000)
C004 VARCHAR2(4000)
C005 VARCHAR2(4000)
C006 VARCHAR2(4000)
C007 VARCHAR2(4000)
C008 VARCHAR2(4000)
C009 VARCHAR2(4000)
C010 VARCHAR2(4000)
C011 VARCHAR2(4000)
C012 VARCHAR2(4000)
C013 VARCHAR2(4000)
C014 VARCHAR2(4000)
C015 VARCHAR2(4000)
C016 VARCHAR2(4000)
C017 VARCHAR2(4000)
C018 VARCHAR2(4000)
C019 VARCHAR2(4000)
C020 VARCHAR2(4000)
C021 VARCHAR2(4000)
C022 VARCHAR2(4000)
C023 VARCHAR2(4000)
C024 VARCHAR2(4000)
C025 VARCHAR2(4000)
C026 VARCHAR2(4000)
C027 VARCHAR2(4000)
C028 VARCHAR2(4000)
C029 VARCHAR2(4000)
C030 VARCHAR2(4000)
C031 VARCHAR2(4000)
C032 VARCHAR2(4000)
