標籤：ack nes order 許可證 led tail 線上 ping htm
本文在Creative Commons許可證下發布
最近在鑽研Oracle 11gR2,寫SQL缺乏Demo表，研究他家的官方資料時發現一塊甲骨文已經給我們準備Sample Schemas。比如說SCOTT Schema下有兩張最廣為人知的Demo表（EMP and DEPT），其實除了SCOTT這個Sample Schema，Oracle還OEM了幾個比較複雜的Sample Schema用於學習。 小夥伴們可以直接拿來學習寫SQL練手。吼吼…..
- HR Schema:The Human Resources division tracks information about the employees and the facilities.
- OE Schema:The Order Entry division tracks product inventories and sales of company‘s products through various channels.
- PM Schema:The Product Media division maintains descriptions and detailed information about each product sold by the company.
- IX Schema:The Information Exchange division manages shipping through B2B applications.
- SH Schema:The Sales division tracks business statistics to facilitate business decisions
- OC Schema:The Online Catalog (OC) subschema is a collection of object-relational database objects built inside the OE schema.
更詳細說明可以查閱官方線上文檔：Oracle Database Sample Schemas 11gR2
Oracle Database Sample Schemas
