Oracle has been utilizing the schema SCOTT with its well-liked tables EMP and DEPT tables for a very long time. With advances in Oracle's know-how, those tables became insufficient to teach even the main simple positive aspects of the Oracle database and different Oracle items. for that reason, many different schemas were created through the years to fit the wishes of product documentation, courseware, and software program improvement and alertness demos.
Read Online or Download Oracle 9i. Sample Schemas PDF
Similar databases books
This ebook brings the entire components of database layout jointly in one quantity, saving the reader the time and cost of constructing a number of purchases. It consolidates either introductory and complex issues, thereby protecting the gamut of database layout method ? from ER and UML thoughts, to conceptual facts modeling and desk transformation, to storing XML and querying relocating gadgets databases.
Oracle Call Interface. Programmer's Guide
The Oracle name Interface (OCI) is an software programming interface (API) that permits purposes written in С or C++ to have interaction with a number of Oracle database servers. OCI provides your courses the aptitude to accomplish the total diversity of database operations which are attainable with an Oracle database server, together with SQL assertion processing and item manipulation.
Oracle Warehouse Builder 11g: Getting Started
This easy-to-understand instructional covers Oracle Warehouse Builder from the floor up, and faucets into the author's huge adventure as a software program and database engineer. Written in a calm kind with step by step reasons, plenty of screenshots are supplied during the booklet. there are lots of suggestions and invaluable tricks all through that aren't present in the unique documentation.
Additional resources for Oracle 9i. Sample Schemas
Example text
Sql Rem Rem Copyright (c) Oracle Corporation 2001. All Rights Reserved. sql Rem Rem Copyright (c) Oracle Corporation 2001. All Rights Reserved. sql - Create procedural objects for HR schema Rem Rem DESCRIPTION Rem Create a statement level trigger on EMPLOYEES Rem to allow DML during business hours. Rem Create a row level trigger on the EMPLOYEES table, Rem after UPDATES on the department_id or job_id columns. Rem Create a stored procedure to insert a row into the Rem JOB_HISTORY table. Have the above row level trigger Rem row level trigger call this stored procedure.
Does not store addresses / locations of customers. Contains 23 rows; references with the departments and countries tables. street_address IS 'Street address of an office, warehouse, or production site of a company. postal_code IS 'Postal code of the location of an office, warehouse, or production site of a company. city IS 'A not null column that shows city where an office, warehouse, or production site of a company is located. country_id IS 'Country where an office, warehouse, or production site of a company is located.
First_name IS 'First name of the employee. last_name IS 'Last name of the employee. hire_date IS 'Date when the employee started on this job. job_id IS 'Current job of the employee; foreign key to job_id column of the jobs table. salary Oracle9i Sample Schema Scripts 4-11 Human Resources (HR) Scripts IS 'Monthly salary of the employee. manager_id IS 'Manager id of the employee; has same domain as manager_id in departments table. Foreign key to employee_id column of employees table. sql Rem Rem Copyright (c) Oracle Corporation 2001.