Oracle Database Sample Schemas

This article was released under the Creative Commons license

Recently in the study of Oracle 11gR2, writing SQL lack of demo table, studying the official information of his family found that a piece of Oracle has been prepared for US sample Schemas. For example, the Scott schema has two of the most well-known demo tables (EMP and DEPT), in fact, in addition to Scott This sample schema,oracle also OEM a few more complex sample Schema for learning. Small friends can learn to write SQL practiced hand directly. Roar .....

• 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 Cha Nnels.

• PM Schema: The Product Media Division maintains descriptions and detailed information about each product sold by T He company.

• IX Schema: The information Exchange Division manages shipping through business-to-business 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 th E OE schema.

More detailed information can be found in the official online documentation: Oracle Database Sample Schemas 11gR2

Oracle Database Sample Schemas