Latest revision |
Your text |
Line 1: |
Line 1: |
| == wikibot == | | == wikibot == |
− | Oracle Demo Schema (test 104 17.02.2011 23:58:21) | + | Oracle Demo Schema (v090502) |
− | | |
| === Tables === | | === Tables === |
| | | |
Line 31: |
Line 30: |
| | | |
| [[SH.COSTS_(table)|COSTS (SH)]] | | [[SH.COSTS_(table)|COSTS (SH)]] |
| + | |
| + | [[SH.COUNTRIES_(table)|COUNTRIES (SH)]] |
| | | |
| [[HR.COUNTRIES_(table)|COUNTRIES (HR)]] | | [[HR.COUNTRIES_(table)|COUNTRIES (HR)]] |
− |
| |
− | [[SH.COUNTRIES_(table)|COUNTRIES (SH)]]
| |
| | | |
| [[OE.CUSTOMERS_(table)|CUSTOMERS (OE)]] | | [[OE.CUSTOMERS_(table)|CUSTOMERS (OE)]] |
Line 81: |
Line 80: |
| | | |
| [[SH.PRODUCTS_(table)|PRODUCTS (SH)]] | | [[SH.PRODUCTS_(table)|PRODUCTS (SH)]] |
| + | |
| + | [[SH.PROMOTIONS_(table)|PROMOTIONS (SH)]] |
| | | |
| [[OE.PROMOTIONS_(table)|PROMOTIONS (OE)]] | | [[OE.PROMOTIONS_(table)|PROMOTIONS (OE)]] |
− |
| |
− | [[SH.PROMOTIONS_(table)|PROMOTIONS (SH)]]
| |
| | | |
| [[OE.PURCHASEORDERS_(table)|PURCHASEORDERS (OE)]] | | [[OE.PURCHASEORDERS_(table)|PURCHASEORDERS (OE)]] |
Line 168: |
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 === | + | === Synonyms === |
| + | |
| + | === Schemas === |
| + | |
| | | |
− | [[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)]]
| + | === XML Schema Collections === |
− |
| |
− | [[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)]]
| |