[Home] [Help] [Dependency Information]
Object Name: | OTA_TESTS# |
---|---|
Object Type: | VIEW |
Owner: | OTA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEST_ID | NUMBER | (15) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
DURATION_FLAG | VARCHAR2 | (1) | Yes | |
GRADE_FLAG | VARCHAR2 | (1) | Yes | |
DISPLAY_ORDER_FLAG | VARCHAR2 | (1) | Yes | |
QUESTIONS_PER_PAGE | NUMBER | (15) | ||
MAX_ATTEMPTS | NUMBER | (15) | ||
DURATION_BETWEEN_ATTEMPT | NUMBER | (3) | ||
TYPE_FLAG | VARCHAR2 | (1) | Yes | |
FEEDBACK_TYPE_FLAG | VARCHAR2 | (1) | Yes | |
DURATION | NUMBER | (15) | ||
WARNING_DURATION | NUMBER | (15) | ||
WARNING_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
INHERIT_FEEDBACK_FLAG | VARCHAR2 | (1) | Yes | |
TEST_TYPE_FLAG | VARCHAR2 | (1) | Yes | |
TEST_INSTRUCTIONS | VARCHAR2 | (4000) | ||
CORRECT_FEEDBACK | VARCHAR2 | (4000) | ||
WRONG_FEEDBACK | VARCHAR2 | (4000) | ||
POST_TEST_FEEDBACK | VARCHAR2 | (4000) | ||
RESUME_FLAG | VARCHAR2 | (1) | Yes | |
RESUME_INSTRUCTIONS | VARCHAR2 | (4000) | ||
QUESTION_REVIEW_FLAG | VARCHAR2 | (1) | Yes | |
FEEDBACK_SHOW_ANSWER_FLAG | VARCHAR2 | (1) | Yes | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
SHOW_SUMMARY_FLAG | VARCHAR2 | (1) | Yes | |
SHOW_CONFIRMATION_FLAG | VARCHAR2 | (1) | Yes | |
SHOW_EXIT_FLAG | VARCHAR2 | (1) | Yes | |
SHOW_SCORE_FLAG | VARCHAR2 | (1) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT TEST_ID
, BUSINESS_GROUP_ID
, DURATION_FLAG
, GRADE_FLAG
, DISPLAY_ORDER_FLAG
, QUESTIONS_PER_PAGE
, MAX_ATTEMPTS
, DURATION_BETWEEN_ATTEMPT
, TYPE_FLAG
, FEEDBACK_TYPE_FLAG
, DURATION
, WARNING_DURATION
, WARNING_ENABLED_FLAG
, INHERIT_FEEDBACK_FLAG
, TEST_TYPE_FLAG
, TEST_INSTRUCTIONS
, CORRECT_FEEDBACK
, WRONG_FEEDBACK
, POST_TEST_FEEDBACK
, RESUME_FLAG
, RESUME_INSTRUCTIONS
, QUESTION_REVIEW_FLAG
, FEEDBACK_SHOW_ANSWER_FLAG
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, SHOW_SUMMARY_FLAG
, SHOW_CONFIRMATION_FLAG
, SHOW_EXIT_FLAG
, SHOW_SCORE_FLAG
FROM OTA.OTA_TESTS#;
|
|
|