首页 > 代码库 > Oracle 11g 的5个常用示例SCHEMA
Oracle 11g 的5个常用示例SCHEMA
HR(Human Resources,人力资源) SCHEMA
COUNTRIES TABLE
DEPARTMENTS TABLE
EMPLOYEES TABLE
EMP_DETAILS_VIEW VIEW
JOBS TABLE
JOB_HISTORY TABLE
LOCATIONS TABLE
REGIONS TABLE
BI(Business Intelligence,商务智能) SCHEMA
CHANNELS SYNONYM
COSTS SYNONYM
COUNTRIES SYNONYM
CUSTOMERS SYNONYM
PRODUCTS SYNONYM
PROMOTIONS SYNONYM
SALES SYNONYM
TIMES SYNONYM
PM(Product Media,产品媒体) SCHEMA
ONLINE_MEDIA TABLE
PRINT_MEDIA TABLE
TEXTDOCS_NESTEDTAB TABLE
OE(Order Entry,订单录入) SCHEMA
ACCOUNT_MANAGERS VIEW
ACTION_TABLE TABLE
BOMBAY_INVENTORY VIEW
CATEGORIES_TAB TABLE
COUNTRIES SYNONYM
CUSTOMERS TABLE
CUSTOMERS_VIEW VIEW
DEPARTMENTS SYNONYM
EMPLOYEES SYNONYM
INVENTORIES TABLE
JOBS SYNONYM
JOB_HISTORY SYNONYM
LARGE_ORDERS TABLE
LARGE_ORDERS1 TABLE
LINEITEM_TABLE TABLE
LOCATIONS SYNONYM
MEDIUM_ORDERS TABLE
MEDIUM_ORDERS1 TABLE
OC_CORPORATE_CUSTOMERS VIEW
OC_CUSTOMERS VIEW
OC_INVENTORIES VIEW
OC_ORDERS VIEW
OC_PRODUCT_INFORMATION VIEW
ORDERS TABLE
ORDERS_VIEW VIEW
ORDER_ITEMS TABLE
PRODUCTS VIEW
PRODUCT_DESCRIPTIONS TABLE
PRODUCT_INFORMATION TABLE
PRODUCT_PRICES VIEW
PRODUCT_REF_LIST_NESTEDTAB TABLE
PROMOTIONS TABLE
PURCHASEORDER TABLE
SMALL_ORDERS TABLE
SMALL_ORDERS1 TABLE
SPECIAL_ORDERS TABLE
SPECIAL_ORDERS1 TABLE
SUBCATEGORY_REF_LIST_NESTEDTAB TABLE
SYDNEY_INVENTORY VIEW
TORONTO_INVENTORY VIEW
WAREHOUSES TABLE
SH(Sales History,销售历史) SCHEMA
CAL_MONTH_SALES_MV TABLE
CHANNELS TABLE
COSTS TABLE
COUNTRIES TABLE
CUSTOMERS TABLE
DIMENSION_EXCEPTIONS TABLE
DR$SUP_TEXT_IDX$I TABLE
DR$SUP_TEXT_IDX$K TABLE
DR$SUP_TEXT_IDX$N TABLE
DR$SUP_TEXT_IDX$R TABLE
FWEEK_PSCAT_SALES_MV TABLE
PRODUCTS TABLE
PROFITS VIEW
PROMOTIONS TABLE
SALES TABLE
SALES_TRANSACTIONS_EXT TABLE
SUPPLEMENTARY_DEMOGRAPHICS TABLE
TIMES TABLE
Oracle 11g 的5个常用示例SCHEMA