Oracle Demo Schema

wikibot

Oracle Demo Schema (v090824)

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)

Types

ADHEADER_TYP (PM)

CATALOG_TYP (OE)

CATEGORY_TYP (OE)

COMPOSITE_CATEGORY_TYP (OE)

CORPORATE_CUSTOMER_TYP (OE)

CUST_ADDRESS_TYP (OE)

CUSTOMER_TYP (OE)

INVENTORY_LIST_TYP (OE)

INVENTORY_TYP (OE)

LEAF_CATEGORY_TYP (OE)

ORDER_EVENT_TYP (IX)

ORDER_ITEM_LIST_TYP (OE)

ORDER_ITEM_TYP (OE)

ORDER_LIST_TYP (OE)

ORDER_TYP (OE)

PHONE_LIST_TYP (OE)

PRODUCT_INFORMATION_TYP (OE)

PRODUCT_REF_LIST_TYP (OE)

SUBCATEGORY_REF_LIST_TYP (OE)

SYS_YOID0000050342$ (OE)

SYS_YOID0000050344$ (OE)

SYS_YOID0000050346$ (OE)

SYS_YOID0000050348$ (OE)

SYS_YOID0000050350$ (OE)

TEXTDOC_TAB (PM)

TEXTDOC_TYP (PM)

WAREHOUSE_TYP (OE)

XDBPO_ACTION_COLLECTION (OE)

XDBPO_ACTION_TYPE (OE)

XDBPO_ACTIONS_TYPE (OE)

XDBPO_LINEITEM_COLLECTION (OE)

XDBPO_LINEITEM_TYPE (OE)

XDBPO_LINEITEMS_TYPE (OE)

XDBPO_PART_TYPE (OE)

XDBPO_REJECTION_TYPE (OE)

XDBPO_SHIPINSTRUCTIONS_TYPE (OE)

XDBPO_TYPE (OE)

Sequences

AQ$_ORDERS_QUEUETABLE_N (IX)

AQ$_STREAMS_QUEUE_TABLE_N (IX)

DEPARTMENTS_SEQ (HR)

EMPLOYEES_SEQ (HR)

LOCATIONS_SEQ (HR)

ORDERS_SEQ (OE)