Database Objects Oracle Demo Schema

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 ===

[IX AQ$_ORDERS_QUEUETABLE_G (table)|AQ$_ORDERS_QUEUETABLE_G (IX)] {br}
	
[IX AQ$_ORDERS_QUEUETABLE_H (table)|AQ$_ORDERS_QUEUETABLE_H (IX)] {br}
	
[IX AQ$_ORDERS_QUEUETABLE_I (table)|AQ$_ORDERS_QUEUETABLE_I (IX)] {br}
	
[IX AQ$_ORDERS_QUEUETABLE_S (table)|AQ$_ORDERS_QUEUETABLE_S (IX)] {br}
	
[IX AQ$_ORDERS_QUEUETABLE_T (table)|AQ$_ORDERS_QUEUETABLE_T (IX)] {br}
	
[IX AQ$_STREAMS_QUEUE_TABLE_G (table)|AQ$_STREAMS_QUEUE_TABLE_G (IX)] {br}
	
[IX AQ$_STREAMS_QUEUE_TABLE_H (table)|AQ$_STREAMS_QUEUE_TABLE_H (IX)] {br}
	
[IX AQ$_STREAMS_QUEUE_TABLE_I (table)|AQ$_STREAMS_QUEUE_TABLE_I (IX)] {br}
	
[IX AQ$_STREAMS_QUEUE_TABLE_S (table)|AQ$_STREAMS_QUEUE_TABLE_S (IX)] {br}
	
[IX AQ$_STREAMS_QUEUE_TABLE_T (table)|AQ$_STREAMS_QUEUE_TABLE_T (IX)] {br}
	
[SH CAL_MONTH_SALES_MV (table)|CAL_MONTH_SALES_MV (SH)] {br}
	
[OE CATEGORIES_TAB (table)|CATEGORIES_TAB (OE)] {br}
	
[SH CHANNELS (table)|CHANNELS (SH)] {br}
	
[SH COSTS (table)|COSTS (SH)] {br}
	
[HR COUNTRIES (table)|COUNTRIES (HR)] {br}
	
[SH COUNTRIES (table)|COUNTRIES (SH)] {br}
	
[OE CUSTOMERS (table)|CUSTOMERS (OE)] {br}
	
[SH CUSTOMERS (table)|CUSTOMERS (SH)] {br}
	
[HR DEPARTMENTS (table)|DEPARTMENTS (HR)] {br}
	
[SH DR$SUP_TEXT_IDX$I (table)|DR$SUP_TEXT_IDX$I (SH)] {br}
	
[SH DR$SUP_TEXT_IDX$K (table)|DR$SUP_TEXT_IDX$K (SH)] {br}
	
[SH DR$SUP_TEXT_IDX$N (table)|DR$SUP_TEXT_IDX$N (SH)] {br}
	
[SH DR$SUP_TEXT_IDX$R (table)|DR$SUP_TEXT_IDX$R (SH)] {br}
	
[HR EMPLOYEES (table)|EMPLOYEES (HR)] {br}
	
[SH FWEEK_PSCAT_SALES_MV (table)|FWEEK_PSCAT_SALES_MV (SH)] {br}
	
[OE INVENTORIES (table)|INVENTORIES (OE)] {br}
	
[HR JOB_HISTORY (table)|JOB_HISTORY (HR)] {br}
	
[HR JOBS (table)|JOBS (HR)] {br}
	
[HR LOCATIONS (table)|LOCATIONS (HR)] {br}
	
[SH MVIEW$_EXCEPTIONS (table)|MVIEW$_EXCEPTIONS (SH)] {br}
	
[PM ONLINE_MEDIA (table)|ONLINE_MEDIA (PM)] {br}
	
[OE ORDER_ITEMS (table)|ORDER_ITEMS (OE)] {br}
	
[OE ORDERS (table)|ORDERS (OE)] {br}
	
[IX ORDERS_QUEUETABLE (table)|ORDERS_QUEUETABLE (IX)] {br}
	
[PM PRINT_MEDIA (table)|PRINT_MEDIA (PM)] {br}
	
[OE PRODUCT_DESCRIPTIONS (table)|PRODUCT_DESCRIPTIONS (OE)] {br}
	
[OE PRODUCT_INFORMATION (table)|PRODUCT_INFORMATION (OE)] {br}
	
[OE PRODUCT_REF_LIST_NESTEDTAB (table)|PRODUCT_REF_LIST_NESTEDTAB (OE)] {br}
	
[SH PRODUCTS (table)|PRODUCTS (SH)] {br}
	
[OE PROMOTIONS (table)|PROMOTIONS (OE)] {br}
	
[SH PROMOTIONS (table)|PROMOTIONS (SH)] {br}
	
[OE PURCHASEORDERS (table)|PURCHASEORDERS (OE)] {br}
	
[HR REGIONS (table)|REGIONS (HR)] {br}
	
[SH SALES (table)|SALES (SH)] {br}
	
[SH SALES_TRANSACTIONS_EXT (table)|SALES_TRANSACTIONS_EXT (SH)] {br}
	
[IX STREAMS_QUEUE_TABLE (table)|STREAMS_QUEUE_TABLE (IX)] {br}
	
[OE STYLESHEET_TAB (table)|STYLESHEET_TAB (OE)] {br}
	
[OE SUBCATEGORY_REF_LIST_NESTEDTAB (table)|SUBCATEGORY_REF_LIST_NESTEDTAB (OE)] {br}
	
[SH SUPPLEMENTARY_DEMOGRAPHICS (table)|SUPPLEMENTARY_DEMOGRAPHICS (SH)] {br}
	
[IX SYS_IOT_OVER_49905 (table)|SYS_IOT_OVER_49905 (IX)] {br}
	
[IX SYS_IOT_OVER_49922 (table)|SYS_IOT_OVER_49922 (IX)] {br}
	
[PM TEXTDOCS_NESTEDTAB (table)|TEXTDOCS_NESTEDTAB (PM)] {br}
	
[SH TIMES (table)|TIMES (SH)] {br}
	
[OE WAREHOUSES (table)|WAREHOUSES (OE)] {br}
	
=== Views ===

[OE ACCOUNT_MANAGERS (view)|ACCOUNT_MANAGERS (OE)] {br}
	
[IX AQ$ORDERS_QUEUETABLE (view)|AQ$ORDERS_QUEUETABLE (IX)] {br}
	
[IX AQ$ORDERS_QUEUETABLE_R (view)|AQ$ORDERS_QUEUETABLE_R (IX)] {br}
	
[IX AQ$ORDERS_QUEUETABLE_S (view)|AQ$ORDERS_QUEUETABLE_S (IX)] {br}
	
[IX AQ$STREAMS_QUEUE_TABLE (view)|AQ$STREAMS_QUEUE_TABLE (IX)] {br}
	
[IX AQ$STREAMS_QUEUE_TABLE_R (view)|AQ$STREAMS_QUEUE_TABLE_R (IX)] {br}
	
[IX AQ$STREAMS_QUEUE_TABLE_S (view)|AQ$STREAMS_QUEUE_TABLE_S (IX)] {br}
	
[OE BOMBAY_INVENTORY (view)|BOMBAY_INVENTORY (OE)] {br}
	
[OE CUSTOMERS_VIEW (view)|CUSTOMERS_VIEW (OE)] {br}
	
[OE DEPTVIEW (view)|DEPTVIEW (OE)] {br}
	
[HR EMP_DETAILS_VIEW (view)|EMP_DETAILS_VIEW (HR)] {br}
	
[OE OC_CORPORATE_CUSTOMERS (view)|OC_CORPORATE_CUSTOMERS (OE)] {br}
	
[OE OC_CUSTOMERS (view)|OC_CUSTOMERS (OE)] {br}
	
[OE OC_INVENTORIES (view)|OC_INVENTORIES (OE)] {br}
	
[OE OC_ORDERS (view)|OC_ORDERS (OE)] {br}
	
[OE OC_PRODUCT_INFORMATION (view)|OC_PRODUCT_INFORMATION (OE)] {br}
	
[OE ORDERS_VIEW (view)|ORDERS_VIEW (OE)] {br}
	
[OE PRODUCT_PRICES (view)|PRODUCT_PRICES (OE)] {br}
	
[OE PRODUCTS (view)|PRODUCTS (OE)] {br}
	
[SH PROFITS (view)|PROFITS (SH)] {br}
	
[OE SYDNEY_INVENTORY (view)|SYDNEY_INVENTORY (OE)] {br}
	
[OE TORONTO_INVENTORY (view)|TORONTO_INVENTORY (OE)] {br}
	
=== Procedures ===

[HR ADD_JOB_HISTORY (procedure)|ADD_JOB_HISTORY (HR)] {br}
	
[HR SECURE_DML (procedure)|SECURE_DML (HR)] {br}
	
=== Functions ===

[OE GET_PHONE_NUMBER_F (function)|GET_PHONE_NUMBER_F (OE)] {br}
	
=== Types ===

[PM ADHEADER_TYP (type)|ADHEADER_TYP (PM)] {br}
	
[OE CATALOG_TYP (type)|CATALOG_TYP (OE)] {br}
	
[OE CATEGORY_TYP (type)|CATEGORY_TYP (OE)] {br}
	
[OE COMPOSITE_CATEGORY_TYP (type)|COMPOSITE_CATEGORY_TYP (OE)] {br}
	
[OE CORPORATE_CUSTOMER_TYP (type)|CORPORATE_CUSTOMER_TYP (OE)] {br}
	
[OE CUST_ADDRESS_TYP (type)|CUST_ADDRESS_TYP (OE)] {br}
	
[OE CUSTOMER_TYP (type)|CUSTOMER_TYP (OE)] {br}
	
[OE INVENTORY_LIST_TYP (type)|INVENTORY_LIST_TYP (OE)] {br}
	
[OE INVENTORY_TYP (type)|INVENTORY_TYP (OE)] {br}
	
[OE LEAF_CATEGORY_TYP (type)|LEAF_CATEGORY_TYP (OE)] {br}
	
[IX ORDER_EVENT_TYP (type)|ORDER_EVENT_TYP (IX)] {br}
	
[OE ORDER_ITEM_LIST_TYP (type)|ORDER_ITEM_LIST_TYP (OE)] {br}
	
[OE ORDER_ITEM_TYP (type)|ORDER_ITEM_TYP (OE)] {br}
	
[OE ORDER_LIST_TYP (type)|ORDER_LIST_TYP (OE)] {br}
	
[OE ORDER_TYP (type)|ORDER_TYP (OE)] {br}
	
[OE PHONE_LIST_TYP (type)|PHONE_LIST_TYP (OE)] {br}
	
[OE PRODUCT_INFORMATION_TYP (type)|PRODUCT_INFORMATION_TYP (OE)] {br}
	
[OE PRODUCT_REF_LIST_TYP (type)|PRODUCT_REF_LIST_TYP (OE)] {br}
	
[OE SUBCATEGORY_REF_LIST_TYP (type)|SUBCATEGORY_REF_LIST_TYP (OE)] {br}
	
[OE SYS_YOID0000050342$ (type)|SYS_YOID0000050342$ (OE)] {br}
	
[OE SYS_YOID0000050344$ (type)|SYS_YOID0000050344$ (OE)] {br}
	
[OE SYS_YOID0000050346$ (type)|SYS_YOID0000050346$ (OE)] {br}
	
[OE SYS_YOID0000050348$ (type)|SYS_YOID0000050348$ (OE)] {br}
	
[OE SYS_YOID0000050350$ (type)|SYS_YOID0000050350$ (OE)] {br}
	
[PM TEXTDOC_TAB (type)|TEXTDOC_TAB (PM)] {br}
	
[PM TEXTDOC_TYP (type)|TEXTDOC_TYP (PM)] {br}
	
[OE WAREHOUSE_TYP (type)|WAREHOUSE_TYP (OE)] {br}
	
[OE XDBPO_ACTION_COLLECTION (type)|XDBPO_ACTION_COLLECTION (OE)] {br}
	
[OE XDBPO_ACTION_TYPE (type)|XDBPO_ACTION_TYPE (OE)] {br}
	
[OE XDBPO_ACTIONS_TYPE (type)|XDBPO_ACTIONS_TYPE (OE)] {br}
	
[OE XDBPO_LINEITEM_COLLECTION (type)|XDBPO_LINEITEM_COLLECTION (OE)] {br}
	
[OE XDBPO_LINEITEM_TYPE (type)|XDBPO_LINEITEM_TYPE (OE)] {br}
	
[OE XDBPO_LINEITEMS_TYPE (type)|XDBPO_LINEITEMS_TYPE (OE)] {br}
	
[OE XDBPO_PART_TYPE (type)|XDBPO_PART_TYPE (OE)] {br}
	
[OE XDBPO_REJECTION_TYPE (type)|XDBPO_REJECTION_TYPE (OE)] {br}
	
[OE XDBPO_SHIPINSTRUCTIONS_TYPE (type)|XDBPO_SHIPINSTRUCTIONS_TYPE (OE)] {br}
	
[OE XDBPO_TYPE (type)|XDBPO_TYPE (OE)] {br}
	
=== Sequences ===

[IX AQ$_ORDERS_QUEUETABLE_N (sequence)|AQ$_ORDERS_QUEUETABLE_N (IX)] {br}
	
[IX AQ$_STREAMS_QUEUE_TABLE_N (sequence)|AQ$_STREAMS_QUEUE_TABLE_N (IX)] {br}
	
[HR DEPARTMENTS_SEQ (sequence)|DEPARTMENTS_SEQ (HR)] {br}
	
[HR EMPLOYEES_SEQ (sequence)|EMPLOYEES_SEQ (HR)] {br}
	
[HR LOCATIONS_SEQ (sequence)|LOCATIONS_SEQ (HR)] {br}
	
[OE ORDERS_SEQ (sequence)|ORDERS_SEQ (OE)] {br}
devio dbscript ScrewTurn Wiki

Navigation¶

Database Objects Oracle Demo Schema
