Difference between revisions of "Oracle Demo Schema"
(→Synonyms) |
|||
(2 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
== wikibot == | == wikibot == | ||
− | Oracle Demo Schema ( | + | Oracle Demo Schema (test 104 17.02.2011 23:58:21) |
+ | |||
=== Tables === | === Tables === | ||
Line 30: | Line 31: | ||
[[SH.COSTS_(table)|COSTS (SH)]] | [[SH.COSTS_(table)|COSTS (SH)]] | ||
+ | |||
+ | [[HR.COUNTRIES_(table)|COUNTRIES (HR)]] | ||
[[SH.COUNTRIES_(table)|COUNTRIES (SH)]] | [[SH.COUNTRIES_(table)|COUNTRIES (SH)]] | ||
− | |||
− | |||
[[OE.CUSTOMERS_(table)|CUSTOMERS (OE)]] | [[OE.CUSTOMERS_(table)|CUSTOMERS (OE)]] | ||
Line 80: | Line 81: | ||
[[SH.PRODUCTS_(table)|PRODUCTS (SH)]] | [[SH.PRODUCTS_(table)|PRODUCTS (SH)]] | ||
+ | |||
+ | [[OE.PROMOTIONS_(table)|PROMOTIONS (OE)]] | ||
[[SH.PROMOTIONS_(table)|PROMOTIONS (SH)]] | [[SH.PROMOTIONS_(table)|PROMOTIONS (SH)]] | ||
− | |||
− | |||
[[OE.PURCHASEORDERS_(table)|PURCHASEORDERS (OE)]] | [[OE.PURCHASEORDERS_(table)|PURCHASEORDERS (OE)]] | ||
Line 166: | Line 167: | ||
[[OE.GET_PHONE_NUMBER_F_(function)|GET_PHONE_NUMBER_F (OE)]] | [[OE.GET_PHONE_NUMBER_F_(function)|GET_PHONE_NUMBER_F (OE)]] | ||
+ | |||
+ | === Types === | ||
+ | |||
+ | [[PM.ADHEADER_TYP_(type)|ADHEADER_TYP (PM)]] | ||
+ | |||
+ | [[OE.CATALOG_TYP_(type)|CATALOG_TYP (OE)]] | ||
+ | |||
+ | [[OE.CATEGORY_TYP_(type)|CATEGORY_TYP (OE)]] | ||
+ | |||
+ | [[OE.COMPOSITE_CATEGORY_TYP_(type)|COMPOSITE_CATEGORY_TYP (OE)]] | ||
+ | |||
+ | [[OE.CORPORATE_CUSTOMER_TYP_(type)|CORPORATE_CUSTOMER_TYP (OE)]] | ||
+ | |||
+ | [[OE.CUST_ADDRESS_TYP_(type)|CUST_ADDRESS_TYP (OE)]] | ||
+ | |||
+ | [[OE.CUSTOMER_TYP_(type)|CUSTOMER_TYP (OE)]] | ||
+ | |||
+ | [[OE.INVENTORY_LIST_TYP_(type)|INVENTORY_LIST_TYP (OE)]] | ||
+ | |||
+ | [[OE.INVENTORY_TYP_(type)|INVENTORY_TYP (OE)]] | ||
+ | |||
+ | [[OE.LEAF_CATEGORY_TYP_(type)|LEAF_CATEGORY_TYP (OE)]] | ||
+ | |||
+ | [[IX.ORDER_EVENT_TYP_(type)|ORDER_EVENT_TYP (IX)]] | ||
+ | |||
+ | [[OE.ORDER_ITEM_LIST_TYP_(type)|ORDER_ITEM_LIST_TYP (OE)]] | ||
+ | |||
+ | [[OE.ORDER_ITEM_TYP_(type)|ORDER_ITEM_TYP (OE)]] | ||
+ | |||
+ | [[OE.ORDER_LIST_TYP_(type)|ORDER_LIST_TYP (OE)]] | ||
+ | |||
+ | [[OE.ORDER_TYP_(type)|ORDER_TYP (OE)]] | ||
+ | |||
+ | [[OE.PHONE_LIST_TYP_(type)|PHONE_LIST_TYP (OE)]] | ||
+ | |||
+ | [[OE.PRODUCT_INFORMATION_TYP_(type)|PRODUCT_INFORMATION_TYP (OE)]] | ||
+ | |||
+ | [[OE.PRODUCT_REF_LIST_TYP_(type)|PRODUCT_REF_LIST_TYP (OE)]] | ||
+ | |||
+ | [[OE.SUBCATEGORY_REF_LIST_TYP_(type)|SUBCATEGORY_REF_LIST_TYP (OE)]] | ||
+ | |||
+ | [[OE.SYS_YOID0000050342$_(type)|SYS_YOID0000050342$ (OE)]] | ||
+ | |||
+ | [[OE.SYS_YOID0000050344$_(type)|SYS_YOID0000050344$ (OE)]] | ||
+ | |||
+ | [[OE.SYS_YOID0000050346$_(type)|SYS_YOID0000050346$ (OE)]] | ||
+ | |||
+ | [[OE.SYS_YOID0000050348$_(type)|SYS_YOID0000050348$ (OE)]] | ||
+ | |||
+ | [[OE.SYS_YOID0000050350$_(type)|SYS_YOID0000050350$ (OE)]] | ||
+ | |||
+ | [[PM.TEXTDOC_TAB_(type)|TEXTDOC_TAB (PM)]] | ||
+ | |||
+ | [[PM.TEXTDOC_TYP_(type)|TEXTDOC_TYP (PM)]] | ||
+ | |||
+ | [[OE.WAREHOUSE_TYP_(type)|WAREHOUSE_TYP (OE)]] | ||
+ | |||
+ | [[OE.XDBPO_ACTION_COLLECTION_(type)|XDBPO_ACTION_COLLECTION (OE)]] | ||
+ | |||
+ | [[OE.XDBPO_ACTION_TYPE_(type)|XDBPO_ACTION_TYPE (OE)]] | ||
+ | |||
+ | [[OE.XDBPO_ACTIONS_TYPE_(type)|XDBPO_ACTIONS_TYPE (OE)]] | ||
+ | |||
+ | [[OE.XDBPO_LINEITEM_COLLECTION_(type)|XDBPO_LINEITEM_COLLECTION (OE)]] | ||
+ | |||
+ | [[OE.XDBPO_LINEITEM_TYPE_(type)|XDBPO_LINEITEM_TYPE (OE)]] | ||
+ | |||
+ | [[OE.XDBPO_LINEITEMS_TYPE_(type)|XDBPO_LINEITEMS_TYPE (OE)]] | ||
+ | |||
+ | [[OE.XDBPO_PART_TYPE_(type)|XDBPO_PART_TYPE (OE)]] | ||
+ | |||
+ | [[OE.XDBPO_REJECTION_TYPE_(type)|XDBPO_REJECTION_TYPE (OE)]] | ||
+ | |||
+ | [[OE.XDBPO_SHIPINSTRUCTIONS_TYPE_(type)|XDBPO_SHIPINSTRUCTIONS_TYPE (OE)]] | ||
+ | |||
+ | [[OE.XDBPO_TYPE_(type)|XDBPO_TYPE (OE)]] | ||
+ | |||
+ | === Sequences === | ||
+ | |||
+ | [[IX.AQ$_ORDERS_QUEUETABLE_N_(sequence)|AQ$_ORDERS_QUEUETABLE_N (IX)]] | ||
+ | |||
+ | [[IX.AQ$_STREAMS_QUEUE_TABLE_N_(sequence)|AQ$_STREAMS_QUEUE_TABLE_N (IX)]] | ||
+ | |||
+ | [[HR.DEPARTMENTS_SEQ_(sequence)|DEPARTMENTS_SEQ (HR)]] | ||
+ | |||
+ | [[HR.EMPLOYEES_SEQ_(sequence)|EMPLOYEES_SEQ (HR)]] | ||
+ | |||
+ | [[HR.LOCATIONS_SEQ_(sequence)|LOCATIONS_SEQ (HR)]] | ||
+ | |||
+ | [[OE.ORDERS_SEQ_(sequence)|ORDERS_SEQ (OE)]] |
Latest revision as of 10:33, 27 August 2011
wikibot[edit]
Oracle Demo Schema (test 104 17.02.2011 23:58:21)
Tables[edit]
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)
PRODUCT_REF_LIST_NESTEDTAB (OE)
SUBCATEGORY_REF_LIST_NESTEDTAB (OE)
SUPPLEMENTARY_DEMOGRAPHICS (SH)
Views[edit]
Procedures[edit]
Functions[edit]
Types[edit]
XDBPO_LINEITEM_COLLECTION (OE)
XDBPO_SHIPINSTRUCTIONS_TYPE (OE)