Oracle Demo Schema

wikibot

Oracle Demo Schema (v090502)

Tables

AQ$_ORDERS_QUEUETABLE_G (IX)

AQ$_ORDERS_QUEUETABLE_H (IX)

AQ$_ORDERS_QUEUETABLE_I (IX)

AQ$_ORDERS_QUEUETABLE_S (IX)

AQ$_ORDERS_QUEUETABLE_T (IX)

AQ$_STREAMS_QUEUE_TABLE_G (IX)

AQ$_STREAMS_QUEUE_TABLE_H (IX)

AQ$_STREAMS_QUEUE_TABLE_I (IX)

AQ$_STREAMS_QUEUE_TABLE_S (IX)

AQ$_STREAMS_QUEUE_TABLE_T (IX)

CAL_MONTH_SALES_MV (SH)

CATEGORIES_TAB (OE)

CHANNELS (SH)

COSTS (SH)

COUNTRIES (SH)

COUNTRIES (HR)

CUSTOMERS (OE)

CUSTOMERS (SH)

DEPARTMENTS (HR)

DR$SUP_TEXT_IDX$I (SH)

DR$SUP_TEXT_IDX$K (SH)

DR$SUP_TEXT_IDX$N (SH)

DR$SUP_TEXT_IDX$R (SH)

EMPLOYEES (HR)

FWEEK_PSCAT_SALES_MV (SH)

INVENTORIES (OE)

JOB_HISTORY (HR)

JOBS (HR)

LOCATIONS (HR)

MVIEW$_EXCEPTIONS (SH)

ONLINE_MEDIA (PM)

ORDER_ITEMS (OE)

ORDERS (OE)

ORDERS_QUEUETABLE (IX)

PRINT_MEDIA (PM)

PRODUCT_DESCRIPTIONS (OE)

PRODUCT_INFORMATION (OE)

PRODUCT_REF_LIST_NESTEDTAB (OE)

PRODUCTS (SH)

PROMOTIONS (SH)

PROMOTIONS (OE)

PURCHASEORDERS (OE)

REGIONS (HR)

SALES (SH)

SALES_TRANSACTIONS_EXT (SH)

STREAMS_QUEUE_TABLE (IX)

STYLESHEET_TAB (OE)

SUBCATEGORY_REF_LIST_NESTEDTAB (OE)

SUPPLEMENTARY_DEMOGRAPHICS (SH)

SYS_IOT_OVER_49905 (IX)

SYS_IOT_OVER_49922 (IX)

TEXTDOCS_NESTEDTAB (PM)

TIMES (SH)

WAREHOUSES (OE)

Views

ACCOUNT_MANAGERS (OE)

AQ$ORDERS_QUEUETABLE (IX)

AQ$ORDERS_QUEUETABLE_R (IX)

AQ$ORDERS_QUEUETABLE_S (IX)

AQ$STREAMS_QUEUE_TABLE (IX)

AQ$STREAMS_QUEUE_TABLE_R (IX)

AQ$STREAMS_QUEUE_TABLE_S (IX)

BOMBAY_INVENTORY (OE)

CUSTOMERS_VIEW (OE)

DEPTVIEW (OE)

EMP_DETAILS_VIEW (HR)

OC_CORPORATE_CUSTOMERS (OE)

OC_CUSTOMERS (OE)

OC_INVENTORIES (OE)

OC_ORDERS (OE)

OC_PRODUCT_INFORMATION (OE)

ORDERS_VIEW (OE)

PRODUCT_PRICES (OE)

PRODUCTS (OE)

PROFITS (SH)

SYDNEY_INVENTORY (OE)

TORONTO_INVENTORY (OE)

Procedures

ADD_JOB_HISTORY (HR)

SECURE_DML (HR)

Functions

GET_PHONE_NUMBER_F (OE)