DBA Data[Home] [Help] [Dependency Information]


TABLE: MSC.MSC_ANSWERS

Object Details
Object Name: MSC_ANSWERS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_ANSWERS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_ANSWERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnANSWER_ID
ColumnSEQ_NUM
MSC_ANSWERS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSESSION_ID
ColumnANSWER_ID
ColumnSEQ_NUM
Columns
Name Datatype Length Mandatory Comments
ANSWER_ID NUMBER
Yes
QUESTION_ID NUMBER

SEQ_NUM NUMBER

SESSION_ID NUMBER

ANSWER_TEXT VARCHAR2 (2000)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ANSWER_ID
,      QUESTION_ID
,      SEQ_NUM
,      SESSION_ID
,      ANSWER_TEXT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM MSC.MSC_ANSWERS;

Dependencies

[top of page]

MSC.MSC_ANSWERS does not reference any database object

MSC.MSC_ANSWERS is referenced by following:

SchemaMSC
ViewMSC_ANSWERS#