[Home] [Help] [Dependency Information]
Object Name: | IBW_SITE_VISITS_TMP_GT |
---|---|
Object Type: | TABLE |
Owner: | IBW |
Subobject Name: | |
Status: | VALID |
IBW.IBW_SITE_VISITS_TMP_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SITE_VISIT_ID | NUMBER | (15) | Yes | |
VISIT_ID | NUMBER | (15) | Yes | |
SITE_ID | NUMBER | (15) | Yes | |
VISIT_START_TIME | DATE | Yes | ||
USER_ID | NUMBER | (15) | Yes | |
REFERRAL_CATEGORY_ID | NUMBER | (15) | ||
VISITOR_ID | NUMBER | (15) | Yes | |
PARTY_ID | NUMBER | (15) | Yes | |
VISITANT_ID | VARCHAR2 | (256) | Yes | |
SITE_VISIT_DURATION | NUMBER | (10) | ||
CAMPAIGN_SOURCE_CODE_ID | NUMBER | (15) | ||
TOTAL_OPT_OUTS | NUMBER | (10) | ||
NUM_PAGE_VIEWS | NUMBER | (10) | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
REPEAT_VISIT_FLAG | VARCHAR2 | (1) | ||
TOTAL_CARTS_CREATED | NUMBER | (10) | ||
TOTAL_ORDERS_CREATED | NUMBER | (10) | ||
TOTAL_ORDER_INQUIRIES | NUMBER | (10) | ||
TOTAL_PAYMENT_INQUIRIES | NUMBER | (10) | ||
TOTAL_INVOICE_INQUIRIES | NUMBER | (10) | ||
TOTAL_WEB_REGISTRATIONS | NUMBER | (10) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | |||
PROGRAM_LOGIN_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
REQUEST_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SITE_VISIT_ID
, VISIT_ID
, SITE_ID
, VISIT_START_TIME
, USER_ID
, REFERRAL_CATEGORY_ID
, VISITOR_ID
, PARTY_ID
, VISITANT_ID
, SITE_VISIT_DURATION
, CAMPAIGN_SOURCE_CODE_ID
, TOTAL_OPT_OUTS
, NUM_PAGE_VIEWS
, OBJECT_VERSION_NUMBER
, REPEAT_VISIT_FLAG
, TOTAL_CARTS_CREATED
, TOTAL_ORDERS_CREATED
, TOTAL_ORDER_INQUIRIES
, TOTAL_PAYMENT_INQUIRIES
, TOTAL_INVOICE_INQUIRIES
, TOTAL_WEB_REGISTRATIONS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
FROM IBW.IBW_SITE_VISITS_TMP_GT;
IBW.IBW_SITE_VISITS_TMP_GT does not reference any database object
IBW.IBW_SITE_VISITS_TMP_GT is referenced by following:
|
|
|