Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Database Objects Oracle Demo Schema

RSS
Modified on 2011/08/27 12:09 by wikibot Categorized as Uncategorized

wikibot

Oracle Demo Schema (test 104 17.02.2011 23:58:21)

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 (HR)
COUNTRIES (SH)
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 (OE)
PROMOTIONS (SH)
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)

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.