5 Common example schemas for Oracle 11g

Source: Internet
Author: User

HR (Human resources, 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, biz 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, orders 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

5 Common example schemas for Oracle 11g

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.