[Home] [Help] [Dependency Information]
Object Name: | PSA_BC_XML_CLOB |
---|---|
Object Type: | TABLE |
Owner: | PSA |
Subobject Name: | |
Status: | VALID |
The table is used to store the XML data out put. The table stores the XML data in CLOB format
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000409914C00003$$ | LOB | UNIQUE | APPS_TS_TX_DATA |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | Unique Application Identifier | |
SEQUENCE_ID | NUMBER | (15) | Sequence Number Identfier | |
XML | CLOB | (4000) | XML Data Output File stored in CLOB format | |
SERIAL_ID | NUMBER | (15) | Serial Identification Number of the DB Session | |
SESSION_ID | NUMBER | (15) | Session Identification Number of DB | |
CREATION_DATE | DATE | Standard who column - date when this row was created. |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, SEQUENCE_ID
, XML
, SERIAL_ID
, SESSION_ID
, CREATION_DATE
FROM PSA.PSA_BC_XML_CLOB;
PSA.PSA_BC_XML_CLOB does not reference any database object
PSA.PSA_BC_XML_CLOB is referenced by following:
|
|
|