SCOTT Schema下有两张最广为人知的Demo表(EMP and DEPT),看到不少人还不知道,其实除了SCOTT这个Sample Schema,Oracle还OEM了几个比较复杂的Sample Schema用于学习。
- 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