ORACLE database 10g: administration workshop i and ii (英文3.1原版)目...

rem rem Header: hr_popul.sql 09-jan-01 rem rem Copyright (c) 2001, 2002, Oracle Corporation. All rights reserved. rem rem Owner : ahunold rem rem NAME rem hr_popul.sql - Populate script for HR schema rem rem DESCRIPTON rem rem rem NOTES rem There is a circular foreign key reference between rem EMPLOYESS and DEPARTMENTS. That's why we disable rem the FK constraints here rem rem CREATED rem Nancy Greenberg, Nagavalli Pataballa - 06/01/00 rem rem MODIFIED (MM/DD/YY) rem hyeh 08/29/02 - hyeh_mv_comschema_to_rdbms rem ahunold 03/07/01 - small data errors corrected rem - Modified region values of countries table rem - Replaced ID sequence values for employees rem and departments tables with numbers rem - Moved create sequence statements to hr_cre rem - Removed dn values for employees and rem departments tables rem - Removed currency columns values from rem countries table rem ngreenbe - Updated employee 178 for no department rem pnathan - Insert new rows to job_history table rem ahunold 02/20/01 - NLS_LANGUAGE, replacing non American rem ahunold 01/09/01 - checkin ADE SET VERIFY OFF ALTER SESSION SET NLS_LANGUAGE=American; REM ***************************insert data into the REGIONS table Prompt ****** Populating REGIONS table .... INSERT INTO regions VALUES ( 1 , 'Europe' ); INSERT INTO regions VALUES ( 2 , 'Americas' ); INSERT INTO regions VALUES ( 3 , 'Asia' ); INSERT INTO regions VALUES ( 4 , 'Middle East and Africa' ); REM ***************************insert data into the COUNTRIES table Prompt ****** Populating COUNTIRES table .... INSERT INTO countries VALUES ( 'IT' , 'Italy' , 1 ); INSERT INTO countries VALUES ( 'JP' , 'Japan' , 3 ); INSERT INTO countries VALUES ( 'US' , 'United States of America' , 2 ); INSERT INTO countries VALUES ( 'CA' , 'Canada' , 2 ); INSERT INTO countries VALUES ( 'CN' , 'China' , 3 ); INSERT INTO countries VALUES ( 'IN' , 'India' , 3 ); INSERT INTO countries VALUES ( 'AU' , 'Australia' , 3 ); INSERT INTO countries VALUES ( 'ZW' , 'Zimbabwe' , 4 ); INSERT INTO countries VALUES ( 'SG' , 'Singapore' , 3 ); INSERT INTO countries VALUES ( 'UK' , 'United Kingdom' , 1 ); INSERT INTO countries VALUES ( 'FR' , 'France' , 1 ); INSERT INTO countries VALUES ( 'DE' , 'Germany' , 1 ); INSERT INTO countries VALUES ( 'ZM' , 'Zambia' , 4 ); INSERT INTO countries VALUES ( 'EG' , 'Egypt' , 4 ); INSERT INTO countries VALUES ( 'BR' , 'Brazil' , 2 ); INSERT INTO countries VALUES ( 'CH' , 'Switzerland' , 1 ); INSERT INTO countries VALUES ( 'NL' , 'Netherlands' , 1 ); INSERT INTO countries VALUES ( 'MX' , 'Mexico' , 2 ); INSERT INTO countries VALUES ( 'KW' , 'Kuwait' , 4 ); INSERT INTO countries VALUES ( 'IL' , 'Israel' , 4 ); INSERT INTO countries VALUES ( 'DK' , 'Denmark' , 1 ); INSERT INTO countries VALUES ( 'HK' , 'HongKong' , 3 ); INSERT INTO countries VALUES ( 'NG' , 'Nigeria' , 4 ); INSERT INTO countries VALUES ( 'AR' , 'Argentina' , 2 ); INSERT INTO countries VALUES ( 'BE' , 'Belgium' , 1 ); REM ***************************insert data into the LOCATIONS table Prompt ****** Populating LOCATIONS table .... INSERT INTO locations VALUES ( 1000 , '1297 Via Cola di Rie' , '00989' , 'Roma' , NULL , 'IT' ); INSERT INTO locations VALUES ( 1100 , '93091 Calle della Testa' , '10934' , 'Venice' , NULL , 'IT' ); INSERT INTO locations VALUES ( 1200 , '2017 Shinjuku-ku' , '1689' , 'Tokyo' , 'Tokyo Prefecture' , 'JP' ); INSERT INTO locations VALUES ( 1300 , '9450 Kamiya-cho' , '6823' , 'Hiroshima' , NULL , 'JP' ); INSERT INTO locations VALUES ( 1400 , '2014 Jabberwocky Rd' , '26192' , 'Southlake' , 'Texas' , 'US' ); INSERT INTO locations VALUES ( 1500 , '2011 Interiors Blvd' , '99236' , 'South San Francisco' , 'California' , 'US' ); INSERT INTO locations VALUES ( 1600 , '2007 Zagora St' , '50090' , 'South Brunswick' , 'New Jersey' , 'US' ); INSERT INTO locations VALUES ( 1700 , '2004 Charade Rd' , '98199' , 'Seattle' , 'Washington' , 'US' ); INSERT INTO locations VALUES ( 1800 , '147 Spadina Ave' , 'M5V 2L7' , 'Toronto' , 'Ontario' , 'CA' ); INSERT INTO locations VALUES ( 1900 , '6092 Boxwood St' , 'YSW 9T2' , 'Whitehorse' , 'Yukon' , 'CA' ); INSERT INTO locations VALUES ( 2000 , '40-5-12 Laogianggen' , '190518' , 'Beijing' , NULL , 'CN' ); INSERT INTO locations VALUES ( 2100 , '1298 Vileparle (E)' , '490231' , 'Bombay' , 'Maharashtra' , 'IN' ); INSERT INTO locations VALUES ( 2200 , '12-98 Victoria Street' , '2901' , 'Sydney' , 'New South Wales' , 'AU' ); INSERT INTO locations VALUES ( 2300 , '198 Clementi North' , '540198' , 'Singapore' , NULL , 'SG' ); INSERT INTO locations VALUES ( 2400 , '8204 Arthur St' , NULL , 'London' , NULL , 'UK' ); INSERT INTO locations VALUES ( 2500 , 'Magdalen Centre, The Oxford Science Park' , 'OX9 9ZB' , 'Oxford' , 'Oxford' , 'UK' ); INSERT INTO locations VALUES ( 2600 , '9702 Chester Road' , '09629850293' , 'Stretford' , 'Manchester' , 'UK' ); INSERT INTO locations VALUES ( 2700 , 'Schwanthalerstr. 7031' , '80925' , 'Munich' , 'Bavaria' , 'DE' ); INSERT INTO locations VALUES ( 2800 , 'Rua Frei Caneca 1360 ' , '01307-002' , 'Sao Paulo' , 'Sao Paulo' , 'BR' ); INSERT INTO locations VALUES ( 2900 , '20 Rue des Corps-Saints' , '1730' , 'Geneva' , 'Geneve' , 'CH' ); INSERT INTO locations VALUES ( 3000 , 'Murtenstrasse 921' , '3095' , 'Bern' , 'BE' , 'CH' ); INSERT INTO locations VALUES ( 3100 , 'Pieter Breughelstraat 837' , '3029SK' , 'Utrecht' , 'Utrecht' , 'NL' ); INSERT INTO locations VALUES ( 3200 , 'Mariano Escobedo 9991' , '11