Databases Reference
In-Depth Information
C033 VARCHAR2(4000)
C034 VARCHAR2(4000)
C035 VARCHAR2(4000)
C036 VARCHAR2(4000)
C037 VARCHAR2(4000)
C038 VARCHAR2(4000)
C039 VARCHAR2(4000)
C040 VARCHAR2(4000)
C041 VARCHAR2(4000)
C042 VARCHAR2(4000)
C043 VARCHAR2(4000)
C044 VARCHAR2(4000)
C045 VARCHAR2(4000)
C046 VARCHAR2(4000)
C047 VARCHAR2(4000)
C048 VARCHAR2(4000)
C049 VARCHAR2(4000)
C050 VARCHAR2(4000)
CLOB001 CLOB
BLOB001 BLOB
XMLTYPE001 SYS.XMLTYPE STORAGE BINARY
N001 NUMBER
N002 NUMBER
N003 NUMBER
N004 NUMBER
N005 NUMBER
D001 DATE
D002 DATE
D003 DATE
D004 DATE
D005 DATE
MD5 ORIGINAL VARCHAR2(4000)
So, although APEX developers do not need to be aware of the underlying tables in the main APEX
engine schema, familiarizing oneself with the structure of the exposed
APEX COLLECTIONS
view is helpful
when developing. The most important points to glean from this are
The data in
APEX COLLECTIONS
is effectively keyed off by the
COLLECTION NAME
and
SEQ ID
columns.
•
•
The remaining columns of the APEX collections infrastructure allows for the
storing of multiple datatypes:
•
Varchar2
•
BLOBs
•
CLOBs
•
XMLTYPEs
•
Numbers
•
Dates
