Oracle 12c 多租户家族（12c [12.2.0.1]、18c [12.2.0.2]、19c [12.2.0.3]）如何在 PDB 中添加模式：19c (19.3) 手工添加示例 HR 用户
目录
1. 配置TNSNAMES.ora
2. 连接PDB
3. 执行脚本
1. 配置TNSNAMES.ora
略，请参考 12c 手工方式和 12c 数据泵方式
2. 连接PDB
1[oracle@henry ~]$ sqlplus sys/oracle@pdb1 as sysdba 2 3SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jun 7 23:45:27 2019 4Version 19.3.0.0.0 5 6Copyright (c) 1982, 2019, Oracle. All rights reserved. 7 8 9Connected to: 10Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production 11Version 19.3.0.0.0 12 13SQL> show pdbs 14 15 CON_ID CON_NAME OPEN MODE RESTRICTED 16---------- --------- ---------- ---------- 17 3 PDB1 READ WRITE NO
3. 执行脚本
SQL> @/home/oracle/hr.sql
脚本明细（我很长）
1DROP USER hr CASCADE; 2CREATE USER hr IDENTIFIED BY hr; 3ALTER USER hr DEFAULT TABLESPACE users QUOTA UNLIMITED ON users; 4ALTER USER hr TEMPORARY TABLESPACE temp; 5 6GRANT create session 7 , create table 8 , create procedure 9 , create sequence 10 , create trigger 11 , create view 12 , create synonym 13 , alter session 14TO hr; 15 16GRANT execute ON sys.dbms_stats TO hr; 17 18conn hr/hr@pdb1; 19CREATE TABLE regions 20 ( region_id NUMBER 21 CONSTRAINT region_id_nn NOT NULL 22 , region_name VARCHAR2(25) 23 ); 24 25CREATE UNIQUE INDEX reg_id_pk 26ON regions (region_id); 27 28ALTER TABLE regions 29ADD ( CONSTRAINT reg_id_pk 30 PRIMARY KEY (region_id) 31 ) ; 32 33 34CREATE TABLE countries 35 ( country_id CHAR(2) 36 CONSTRAINT country_id_nn NOT NULL 37 , country_name VARCHAR2(40) 38 , region_id NUMBER 39 , CONSTRAINT country_c_id_pk 40 PRIMARY KEY (country_id) 41 ) 42 ORGANIZATION INDEX; 43 44ALTER TABLE countries 45ADD ( CONSTRAINT countr_reg_fk 46 FOREIGN KEY (region_id) 47 REFERENCES regions(region_id) 48 ) ; 49 50 51CREATE TABLE locations 52 ( location_id NUMBER(4) 53 , street_address VARCHAR2(40) 54 , postal_code VARCHAR2(12) 55 , city VARCHAR2(30) 56 CONSTRAINT loc_city_nn NOT NULL 57 , state_province VARCHAR2(25) 58 , country_id CHAR(2) 59 ) ; 60 61CREATE UNIQUE INDEX loc_id_pk 62ON locations (location_id) ; 63 64ALTER TABLE locations 65ADD ( CONSTRAINT loc_id_pk 66 PRIMARY KEY (location_id) 67 , CONSTRAINT loc_c_id_fk 68 FOREIGN KEY (country_id) 69 REFERENCES countries(country_id) 70 ) ; 71 72 73CREATE SEQUENCE locations_seq 74 START WITH 3300 75 INCREMENT BY 100 76 MAXVALUE 9900 77 NOCACHE 78 NOCYCLE; 79 80CREATE TABLE departments 81 ( department_id NUMBER(4) 82 , department_name VARCHAR2(30) 83 CONSTRAINT dept_name_nn NOT NULL 84 , manager_id NUMBER(6) 85 , location_id NUMBER(4) 86 ) ; 87 88CREATE UNIQUE INDEX dept_id_pk 89ON departments (department_id) ; 90 91ALTER TABLE departments 92ADD ( CONSTRAINT dept_id_pk 93 PRIMARY KEY (department_id) 94 , CONSTRAINT dept_loc_fk 95 FOREIGN KEY (location_id) 96 REFERENCES locations (location_id) 97 ) ; 98 99CREATE SEQUENCE departments_seq 100 START WITH 280 101 INCREMENT BY 10 102 MAXVALUE 9990 103 NOCACHE 104 NOCYCLE; 105 106CREATE TABLE jobs 107 ( job_id VARCHAR2(10) 108 , job_title VARCHAR2(35) 109 CONSTRAINT job_title_nn NOT NULL 110 , min_salary NUMBER(6) 111 , max_salary NUMBER(6) 112 ) ; 113 114CREATE UNIQUE INDEX job_id_pk 115ON jobs (job_id) ; 116 117ALTER TABLE jobs 118ADD ( CONSTRAINT job_id_pk 119 PRIMARY KEY(job_id) 120 ) ; 121 122CREATE TABLE employees 123 ( employee_id NUMBER(6) 124 , first_name VARCHAR2(20) 125 , last_name VARCHAR2(25) 126 CONSTRAINT emp_last_name_nn NOT NULL 127 , email VARCHAR2(25) 128 CONSTRAINT emp_email_nn NOT NULL 129 , phone_number VARCHAR2(20) 130 , hire_date DATE 131 CONSTRAINT emp_hire_date_nn NOT NULL 132 , job_id VARCHAR2(10) 133 CONSTRAINT emp_job_nn NOT NULL 134 , salary NUMBER(8,2) 135 , commission_pct NUMBER(2,2) 136 , manager_id NUMBER(6) 137 , department_id NUMBER(4) 138 , CONSTRAINT emp_salary_min 139 CHECK (salary > 0) 140 , CONSTRAINT emp_email_uk 141 UNIQUE (email) 142 ) ; 143 144CREATE UNIQUE INDEX emp_emp_id_pk 145ON employees (employee_id) ; 146 147 148ALTER TABLE employees 149ADD ( CONSTRAINT emp_emp_id_pk 150 PRIMARY KEY (employee_id) 151 , CONSTRAINT emp_dept_fk 152 FOREIGN KEY (department_id) 153 REFERENCES departments 154 , CONSTRAINT emp_job_fk 155 FOREIGN KEY (job_id) 156 REFERENCES jobs (job_id) 157 , CONSTRAINT emp_manager_fk 158 FOREIGN KEY (manager_id) 159 REFERENCES employees 160 ) ; 161 162ALTER TABLE departments 163ADD ( CONSTRAINT dept_mgr_fk 164 FOREIGN KEY (manager_id) 165 REFERENCES employees (employee_id) 166 ) ; 167 168CREATE SEQUENCE employees_seq 169 START WITH 207 170 INCREMENT BY 1 171 NOCACHE 172 NOCYCLE; 173 174CREATE TABLE job_history 175 ( employee_id NUMBER(6) 176 CONSTRAINT jhist_employee_nn NOT NULL 177 , start_date DATE 178 CONSTRAINT jhist_start_date_nn NOT NULL 179 , end_date DATE 180 CONSTRAINT jhist_end_date_nn NOT NULL 181 , job_id VARCHAR2(10) 182 CONSTRAINT jhist_job_nn NOT NULL 183 , department_id NUMBER(4) 184 , CONSTRAINT jhist_date_interval 185 CHECK (end_date > start_date) 186 ) ; 187 188CREATE UNIQUE INDEX jhist_emp_id_st_date_pk 189ON job_history (employee_id, start_date) ; 190 191ALTER TABLE job_history 192ADD ( CONSTRAINT jhist_emp_id_st_date_pk 193 PRIMARY KEY (employee_id, start_date) 194 , CONSTRAINT jhist_job_fk 195 FOREIGN KEY (job_id) 196 REFERENCES jobs 197 , CONSTRAINT jhist_emp_fk 198 FOREIGN KEY (employee_id) 199 REFERENCES employees 200 , CONSTRAINT jhist_dept_fk 201 FOREIGN KEY (department_id) 202 REFERENCES departments 203 ) ; 204 205 206CREATE OR REPLACE VIEW emp_details_view 207 (employee_id, 208 job_id, 209 manager_id, 210 department_id, 211 location_id, 212 country_id, 213 first_name, 214 last_name, 215 salary, 216 commission_pct, 217 department_name, 218 job_title, 219 city, 220 state_province, 221 country_name, 222 region_name) 223AS SELECT 224 e.employee_id, 225 e.job_id, 226 e.manager_id, 227 e.department_id, 228 d.location_id, 229 l.country_id, 230 e.first_name, 231 e.last_name, 232 e.salary, 233 e.commission_pct, 234 d.department_name, 235 j.job_title, 236 l.city, 237 l.state_province, 238 c.country_name, 239 r.region_name 240FROM 241 employees e, 242 departments d, 243 jobs j, 244 locations l, 245 countries c, 246 regions r 247WHERE e.department_id = d.department_id 248 AND d.location_id = l.location_id 249 AND l.country_id = c.country_id 250 AND c.region_id = r.region_id 251 AND j.job_id = e.job_id 252WITH READ ONLY; 253 254COMMIT; 255 256INSERT INTO regions VALUES 257 ( 1 258 , 'Europe' 259 ); 260 261INSERT INTO regions VALUES 262 ( 2 263 , 'Americas' 264 ); 265 266INSERT INTO regions VALUES 267 ( 3 268 , 'Asia' 269 ); 270 271INSERT INTO regions VALUES 272 ( 4 273 , 'Middle East and Africa' 274 ); 275 276INSERT INTO countries VALUES 277 ( 'IT' 278 , 'Italy' 279 , 1 280 ); 281 282INSERT INTO countries VALUES 283 ( 'JP' 284 , 'Japan' 285 , 3 286 ); 287 288INSERT INTO countries VALUES 289 ( 'US' 290 , 'United States of America' 291 , 2 292 ); 293 294INSERT INTO countries VALUES 295 ( 'CA' 296 , 'Canada' 297 , 2 298 ); 299 300INSERT INTO countries VALUES 301 ( 'CN' 302 , 'China' 303 , 3 304 ); 305 306INSERT INTO countries VALUES 307 ( 'IN' 308 , 'India' 309 , 3 310 ); 311 312INSERT INTO countries VALUES 313 ( 'AU' 314 , 'Australia' 315 , 3 316 ); 317 318INSERT INTO countries VALUES 319 ( 'ZW' 320 , 'Zimbabwe' 321 , 4 322 ); 323 324INSERT INTO countries VALUES 325 ( 'SG' 326 , 'Singapore' 327 , 3 328 ); 329 330INSERT INTO countries VALUES 331 ( 'UK' 332 , 'United Kingdom' 333 , 1 334 ); 335 336INSERT INTO countries VALUES 337 ( 'FR' 338 , 'France' 339 , 1 340 ); 341 342INSERT INTO countries VALUES 343 ( 'DE' 344 , 'Germany' 345 , 1 346 ); 347 348INSERT INTO countries VALUES 349 ( 'ZM' 350 , 'Zambia' 351 , 4 352 ); 353 354INSERT INTO countries VALUES 355 ( 'EG' 356 , 'Egypt' 357 , 4 358 ); 359 360INSERT INTO countries VALUES 361 ( 'BR' 362 , 'Brazil' 363 , 2 364 ); 365 366INSERT INTO countries VALUES 367 ( 'CH' 368 , 'Switzerland' 369 , 1 370 ); 371 372INSERT INTO countries VALUES 373 ( 'NL' 374 , 'Netherlands' 375 , 1 376 ); 377 378INSERT INTO countries VALUES 379 ( 'MX' 380 , 'Mexico' 381 , 2 382 ); 383 384INSERT INTO countries VALUES 385 ( 'KW' 386 , 'Kuwait' 387 , 4 388 ); 389 390INSERT INTO countries VALUES 391 ( 'IL' 392 , 'Israel' 393 , 4 394 ); 395 396INSERT INTO countries VALUES 397 ( 'DK' 398 , 'Denmark' 399 , 1 400 ); 401 402INSERT INTO countries VALUES 403 ( 'HK' 404 , 'HongKong' 405 , 3 406 ); 407 408INSERT INTO countries VALUES 409 ( 'NG' 410 , 'Nigeria' 411 , 4 412 ); 413 414INSERT INTO countries VALUES 415 ( 'AR' 416 , 'Argentina' 417 , 2 418 ); 419 420INSERT INTO countries VALUES 421 ( 'BE' 422 , 'Belgium' 423 , 1 424 ); 425 426INSERT INTO locations VALUES 427 ( 1000 428 , '1297 Via Cola di Rie' 429 , '00989' 430 , 'Roma' 431 , NULL 432 , 'IT' 433 ); 434 435INSERT INTO locations VALUES 436 ( 1100 437 , '93091 Calle della Testa' 438 , '10934' 439 , 'Venice' 440 , NULL 441 , 'IT' 442 ); 443 444INSERT INTO locations VALUES 445 ( 1200 446 , '2017 Shinjuku-ku' 447 , '1689' 448 , 'Tokyo' 449 , 'Tokyo Prefecture' 450 , 'JP' 451 ); 452 453INSERT INTO locations VALUES 454 ( 1300 455 , '9450 Kamiya-cho' 456 , '6823' 457 , 'Hiroshima' 458 , NULL 459 , 'JP' 460 ); 461 462INSERT INTO locations VALUES 463 ( 1400 464 , '2014 Jabberwocky Rd' 465 , '26192' 466 , 'Southlake' 467 , 'Texas' 468 , 'US' 469 ); 470 471INSERT INTO locations VALUES 472 ( 1500 473 , '2011 Interiors Blvd' 474 , '99236' 475 , 'South San Francisco' 476 , 'California' 477 , 'US' 478 ); 479 480INSERT INTO locations VALUES 481 ( 1600 482 , '2007 Zagora St' 483 , '50090' 484 , 'South Brunswick' 485 , 'New Jersey' 486 , 'US' 487 ); 488 489INSERT INTO locations VALUES 490 ( 1700 491 , '2004 Charade Rd' 492 , '98199' 493 , 'Seattle' 494 , 'Washington' 495 , 'US' 496 ); 497 498INSERT INTO locations VALUES 499 ( 1800 500 , '147 Spadina Ave' 501 , 'M5V 2L7' 502 , 'Toronto' 503 , 'Ontario' 504 , 'CA' 505 ); 506 507INSERT INTO locations VALUES 508 ( 1900 509 , '6092 Boxwood St' 510 , 'YSW 9T2' 511 , 'Whitehorse' 512 , 'Yukon' 513 , 'CA' 514 ); 515 516INSERT INTO locations VALUES 517 ( 2000 518 , '40-5-12 Laogianggen' 519 , '190518' 520 , 'Beijing' 521 , NULL 522 , 'CN' 523 ); 524 525INSERT INTO locations VALUES 526 ( 2100 527 , '1298 Vileparle (E)' 528 , '490231' 529 , 'Bombay' 530 , 'Maharashtra' 531 , 'IN' 532 ); 533 534INSERT INTO locations VALUES 535 ( 2200 536 , '12-98 Victoria Street' 537 , '2901' 538 , 'Sydney' 539 , 'New South Wales' 540 , 'AU' 541 ); 542 543INSERT INTO locations VALUES 544 ( 2300 545 , '198 Clementi North' 546 , '540198' 547 , 'Singapore' 548 , NULL 549 , 'SG' 550 ); 551 552INSERT INTO locations VALUES 553 ( 2400 554 , '8204 Arthur St' 555 , NULL 556 , 'London' 557 , NULL 558 , 'UK' 559 ); 560 561INSERT INTO locations VALUES 562 ( 2500 563 , 'Magdalen Centre, The Oxford Science Park' 564 , 'OX9 9ZB' 565 , 'Oxford' 566 , 'Oxford' 567 , 'UK' 568 ); 569 570INSERT INTO locations VALUES 571 ( 2600 572 , '9702 Chester Road' 573 , '09629850293' 574 , 'Stretford' 575 , 'Manchester' 576 , 'UK' 577 ); 578 579INSERT INTO locations VALUES 580 ( 2700 581 , 'Schwanthalerstr. 7031' 582 , '80925' 583 , 'Munich' 584 , 'Bavaria' 585 , 'DE' 586 ); 587 588INSERT INTO locations VALUES 589 ( 2800 590 , 'Rua Frei Caneca 1360 ' 591 , '01307-002' 592 , 'Sao Paulo' 593 , 'Sao Paulo' 594 , 'BR' 595 ); 596 597INSERT INTO locations VALUES 598 ( 2900 599 , '20 Rue des Corps-Saints' 600 , '1730' 601 , 'Geneva' 602 , 'Geneve' 603 , 'CH' 604 ); 605 606INSERT INTO locations VALUES 607 ( 3000 608 , 'Murtenstrasse 921' 609 , '3095' 610 , 'Bern' 611 , 'BE' 612 , 'CH' 613 ); 614 615INSERT INTO locations VALUES 616 ( 3100 617 , 'Pieter Breughelstraat 837' 618 , '3029SK' 619 , 'Utrecht' 620 , 'Utrecht' 621 , 'NL' 622 ); 623 624INSERT INTO locations VALUES 625 ( 3200 626 , 'Mariano Escobedo 9991' 627 , '11932' 628 , 'Mexico City' 629 , 'Distrito Federal,' 630 , 'MX' 631 ); 632 633 634ALTER TABLE departments 635 DISABLE CONSTRAINT dept_mgr_fk; 636 637INSERT INTO departments VALUES 638 ( 10 639 , 'Administration' 640 , 200 641 , 1700 642 ); 643 644INSERT INTO departments VALUES 645 ( 20 646 , 'Marketing' 647 , 201 648 , 1800 649 ); 650 651INSERT INTO departments VALUES 652 ( 30 653 , 'Purchasing' 654 , 114 655 , 1700 656 ); 657 658INSERT INTO departments VALUES 659 ( 40 660 , 'Human Resources' 661 , 203 662 , 2400 663 ); 664 665INSERT INTO departments VALUES 666 ( 50 667 , 'Shipping' 668 , 121 669 , 1500 670 ); 671 672INSERT INTO departments VALUES 673 ( 60 674 , 'IT' 675 , 103 676 , 1400 677 ); 678 679INSERT INTO departments VALUES 680 ( 70 681 , 'Public Relations' 682 , 204 683 , 2700 684 ); 685 686INSERT INTO departments VALUES 687 ( 80 688 , 'Sales' 689 , 145 690 , 2500 691 ); 692 693INSERT INTO departments VALUES 694 ( 90 695 , 'Executive' 696 , 100 697 , 1700 698 ); 699 700INSERT INTO departments VALUES 701 ( 100 702 , 'Finance' 703 , 108 704 , 1700 705 ); 706 707INSERT INTO departments VALUES 708 ( 110 709 , 'Accounting' 710 , 205 711 , 1700 712 ); 713 714INSERT INTO departments VALUES 715 ( 120 716 , 'Treasury' 717 , NULL 718 , 1700 719 ); 720 721INSERT INTO departments VALUES 722 ( 130 723 , 'Corporate Tax' 724 , NULL 725 , 1700 726 ); 727 728INSERT INTO departments VALUES 729 ( 140 730 , 'Control And Credit' 731 , NULL 732 , 1700 733 ); 734 735INSERT INTO departments VALUES 736 ( 150 737 , 'Shareholder Services' 738 , NULL 739 , 1700 740 ); 741 742INSERT INTO departments VALUES 743 ( 160 744 , 'Benefits' 745 , NULL 746 , 1700 747 ); 748 749INSERT INTO departments VALUES 750 ( 170 751 , 'Manufacturing' 752 , NULL 753 , 1700 754 ); 755 756INSERT INTO departments VALUES 757 ( 180 758 , 'Construction' 759 , NULL 760 , 1700 761 ); 762 763INSERT INTO departments VALUES 764 ( 190 765 , 'Contracting' 766 , NULL 767 , 1700 768 ); 769 770INSERT INTO departments VALUES 771 ( 200 772 , 'Operations' 773 , NULL 774 , 1700 775 ); 776 777INSERT INTO departments VALUES 778 ( 210 779 , 'IT Support' 780 , NULL 781 , 1700 782 ); 783 784INSERT INTO departments VALUES 785 ( 220 786 , 'NOC' 787 , NULL 788 , 1700 789 ); 790 791INSERT INTO departments VALUES 792 ( 230 793 , 'IT Helpdesk' 794 , NULL 795 , 1700 796 ); 797 798INSERT INTO departments VALUES 799 ( 240 800 , 'Government Sales' 801 , NULL 802 , 1700 803 ); 804 805INSERT INTO departments VALUES 806 ( 250 807 , 'Retail Sales' 808 , NULL 809 , 1700 810 ); 811 812INSERT INTO departments VALUES 813 ( 260 814 , 'Recruiting' 815 , NULL 816 , 1700 817 ); 818 819INSERT INTO departments VALUES 820 ( 270 821 , 'Payroll' 822 , NULL 823 , 1700 824 ); 825 826 827INSERT INTO jobs VALUES 828 ( 'AD_PRES' 829 , 'President' 830 , 20000 831 , 40000 832 ); 833INSERT INTO jobs VALUES 834 ( 'AD_VP' 835 , 'Administration Vice President' 836 , 15000 837 , 30000 838 ); 839 840INSERT INTO jobs VALUES 841 ( 'AD_ASST' 842 , 'Administration Assistant' 843 , 3000 844 , 6000 845 ); 846 847INSERT INTO jobs VALUES 848 ( 'FI_MGR' 849 , 'Finance Manager' 850 , 8200 851 , 16000 852 ); 853 854INSERT INTO jobs VALUES 855 ( 'FI_ACCOUNT' 856 , 'Accountant' 857 , 4200 858 , 9000 859 ); 860 861INSERT INTO jobs VALUES 862 ( 'AC_MGR' 863 , 'Accounting Manager' 864 , 8200 865 , 16000 866 ); 867 868INSERT INTO jobs VALUES 869 ( 'AC_ACCOUNT' 870 , 'Public Accountant' 871 , 4200 872 , 9000 873 ); 874INSERT INTO jobs VALUES 875 ( 'SA_MAN' 876 , 'Sales Manager' 877 , 10000 878 , 20000 879 ); 880 881INSERT INTO jobs VALUES 882 ( 'SA_REP' 883 , 'Sales Representative' 884 , 6000 885 , 12000 886 ); 887 888INSERT INTO jobs VALUES 889 ( 'PU_MAN' 890 , 'Purchasing Manager' 891 , 8000 892 , 15000 893 ); 894 895INSERT INTO jobs VALUES 896 ( 'PU_CLERK' 897 , 'Purchasing Clerk' 898 , 2500 899 , 5500 900 ); 901 902INSERT INTO jobs VALUES 903 ( 'ST_MAN' 904 , 'Stock Manager' 905 , 5500 906 , 8500 907 ); 908INSERT INTO jobs VALUES 909 ( 'ST_CLERK' 910 , 'Stock Clerk' 911 , 2000 912 , 5000 913 ); 914 915INSERT INTO jobs VALUES 916 ( 'SH_CLERK' 917 , 'Shipping Clerk' 918 , 2500 919 , 5500 920 ); 921 922INSERT INTO jobs VALUES 923 ( 'IT_PROG' 924 , 'Programmer' 925 , 4000 926 , 10000 927 ); 928 929INSERT INTO jobs VALUES 930 ( 'MK_MAN' 931 , 'Marketing Manager' 932 , 9000 933 , 15000 934 ); 935 936INSERT INTO jobs VALUES 937 ( 'MK_REP' 938 , 'Marketing Representative' 939 , 4000 940 , 9000 941 ); 942 943INSERT INTO jobs VALUES 944 ( 'HR_REP' 945 , 'Human Resources Representative' 946 , 4000 947 , 9000 948 ); 949 950INSERT INTO jobs VALUES 951 ( 'PR_REP' 952 , 'Public Relations Representative' 953 , 4500 954 , 10500 955 ); 956 957 958INSERT INTO employees VALUES 959 ( 100 960 , 'Steven' 961 , 'King' 962 , 'SKING' 963 , '515.123.4567' 964 , TO_DATE('17-JUN-1987', 'dd-MON-yyyy') 965 , 'AD_PRES' 966 , 24000 967 , NULL 968 , NULL 969 , 90 970 ); 971 972INSERT INTO employees VALUES 973 ( 101 974 , 'Neena' 975 , 'Kochhar' 976 , 'NKOCHHAR' 977 , '515.123.4568' 978 , TO_DATE('21-SEP-1989', 'dd-MON-yyyy') 979 , 'AD_VP' 980 , 17000 981 , NULL 982 , 100 983 , 90 984 ); 985 986INSERT INTO employees VALUES 987 ( 102 988 , 'Lex' 989 , 'De Haan' 990 , 'LDEHAAN' 991 , '515.123.4569' 992 , TO_DATE('13-JAN-1993', 'dd-MON-yyyy') 993 , 'AD_VP' 994 , 17000 995 , NULL 996 , 100 997 , 90 998 ); 999 1000INSERT INTO employees VALUES 1001 ( 103 1002 , 'Alexander' 1003 , 'Hunold' 1004 , 'AHUNOLD' 1005 , '590.423.4567' 1006 , TO_DATE('03-JAN-1990', 'dd-MON-yyyy') 1007 , 'IT_PROG' 1008 , 9000 1009 , NULL 1010 , 102 1011 , 60 1012 ); 1013 1014INSERT INTO employees VALUES 1015 ( 104 1016 , 'Bruce' 1017 , 'Ernst' 1018 , 'BERNST' 1019 , '590.423.4568' 1020 , TO_DATE('21-MAY-1991', 'dd-MON-yyyy') 1021 , 'IT_PROG' 1022 , 6000 1023 , NULL 1024 , 103 1025 , 60 1026 ); 1027 1028INSERT INTO employees VALUES 1029 ( 105 1030 , 'David' 1031 , 'Austin' 1032 , 'DAUSTIN' 1033 , '590.423.4569' 1034 , TO_DATE('25-JUN-1997', 'dd-MON-yyyy') 1035 , 'IT_PROG' 1036 , 4800 1037 , NULL 1038 , 103 1039 , 60 1040 ); 1041 1042INSERT INTO employees VALUES 1043 ( 106 1044 , 'Valli' 1045 , 'Pataballa' 1046 , 'VPATABAL' 1047 , '590.423.4560' 1048 , TO_DATE('05-FEB-1998', 'dd-MON-yyyy') 1049 , 'IT_PROG' 1050 , 4800 1051 , NULL 1052 , 103 1053 , 60 1054 ); 1055 1056INSERT INTO employees VALUES 1057 ( 107 1058 , 'Diana' 1059 , 'Lorentz' 1060 , 'DLORENTZ' 1061 , '590.423.5567' 1062 , TO_DATE('07-FEB-1999', 'dd-MON-yyyy') 1063 , 'IT_PROG' 1064 , 4200 1065 , NULL 1066 , 103 1067 , 60 1068 ); 1069 1070INSERT INTO employees VALUES 1071 ( 108 1072 , 'Nancy' 1073 , 'Greenberg' 1074 , 'NGREENBE' 1075 , '515.124.4569' 1076 , TO_DATE('17-AUG-1994', 'dd-MON-yyyy') 1077 , 'FI_MGR' 1078 , 12000 1079 , NULL 1080 , 101 1081 , 100 1082 ); 1083 1084INSERT INTO employees VALUES 1085 ( 109 1086 , 'Daniel' 1087 , 'Faviet' 1088 , 'DFAVIET' 1089 , '515.124.4169' 1090 , TO_DATE('16-AUG-1994', 'dd-MON-yyyy') 1091 , 'FI_ACCOUNT' 1092 , 9000 1093 , NULL 1094 , 108 1095 , 100 1096 ); 1097 1098INSERT INTO employees VALUES 1099 ( 110 1100 , 'John' 1101 , 'Chen' 1102 , 'JCHEN' 1103 , '515.124.4269' 1104 , TO_DATE('28-SEP-1997', 'dd-MON-yyyy') 1105 , 'FI_ACCOUNT' 1106 , 8200 1107 , NULL 1108 , 108 1109 , 100 1110 ); 1111 1112INSERT INTO employees VALUES 1113 ( 111 1114 , 'Ismael' 1115 , 'Sciarra' 1116 , 'ISCIARRA' 1117 , '515.124.4369' 1118 , TO_DATE('30-SEP-1997', 'dd-MON-yyyy') 1119 , 'FI_ACCOUNT' 1120 , 7700 1121 , NULL 1122 , 108 1123 , 100 1124 ); 1125 1126INSERT INTO employees VALUES 1127 ( 112 1128 , 'Jose Manuel' 1129 , 'Urman' 1130 , 'JMURMAN' 1131 , '515.124.4469' 1132 , TO_DATE('07-MAR-1998', 'dd-MON-yyyy') 1133 , 'FI_ACCOUNT' 1134 , 7800 1135 , NULL 1136 , 108 1137 , 100 1138 ); 1139 1140INSERT INTO employees VALUES 1141 ( 113 1142 , 'Luis' 1143 , 'Popp' 1144 , 'LPOPP' 1145 , '515.124.4567' 1146 , TO_DATE('07-DEC-1999', 'dd-MON-yyyy') 1147 , 'FI_ACCOUNT' 1148 , 6900 1149 , NULL 1150 , 108 1151 , 100 1152 ); 1153 1154INSERT INTO employees VALUES 1155 ( 114 1156 , 'Den' 1157 , 'Raphaely' 1158 , 'DRAPHEAL' 1159 , '515.127.4561' 1160 , TO_DATE('07-DEC-1994', 'dd-MON-yyyy') 1161 , 'PU_MAN' 1162 , 11000 1163 , NULL 1164 , 100 1165 , 30 1166 ); 1167 1168INSERT INTO employees VALUES 1169 ( 115 1170 , 'Alexander' 1171 , 'Khoo' 1172 , 'AKHOO' 1173 , '515.127.4562' 1174 , TO_DATE('18-MAY-1995', 'dd-MON-yyyy') 1175 , 'PU_CLERK' 1176 , 3100 1177 , NULL 1178 , 114 1179 , 30 1180 ); 1181 1182INSERT INTO employees VALUES 1183 ( 116 1184 , 'Shelli' 1185 , 'Baida' 1186 , 'SBAIDA' 1187 , '515.127.4563' 1188 , TO_DATE('24-DEC-1997', 'dd-MON-yyyy') 1189 , 'PU_CLERK' 1190 , 2900 1191 , NULL 1192 , 114 1193 , 30 1194 ); 1195 1196INSERT INTO employees VALUES 1197 ( 117 1198 , 'Sigal' 1199 , 'Tobias' 1200 , 'STOBIAS' 1201 , '515.127.4564' 1202 , TO_DATE('24-JUL-1997', 'dd-MON-yyyy') 1203 , 'PU_CLERK' 1204 , 2800 1205 , NULL 1206 , 114 1207 , 30 1208 ); 1209 1210INSERT INTO employees VALUES 1211 ( 118 1212 , 'Guy' 1213 , 'Himuro' 1214 , 'GHIMURO' 1215 , '515.127.4565' 1216 , TO_DATE('15-NOV-1998', 'dd-MON-yyyy') 1217 , 'PU_CLERK' 1218 , 2600 1219 , NULL 1220 , 114 1221 , 30 1222 ); 1223 1224INSERT INTO employees VALUES 1225 ( 119 1226 , 'Karen' 1227 , 'Colmenares' 1228 , 'KCOLMENA' 1229 , '515.127.4566' 1230 , TO_DATE('10-AUG-1999', 'dd-MON-yyyy') 1231 , 'PU_CLERK' 1232 , 2500 1233 , NULL 1234 , 114 1235 , 30 1236 ); 1237 1238INSERT INTO employees VALUES 1239 ( 120 1240 , 'Matthew' 1241 , 'Weiss' 1242 , 'MWEISS' 1243 , '650.123.1234' 1244 , TO_DATE('18-JUL-1996', 'dd-MON-yyyy') 1245 , 'ST_MAN' 1246 , 8000 1247 , NULL 1248 , 100 1249 , 50 1250 ); 1251 1252INSERT INTO employees VALUES 1253 ( 121 1254 , 'Adam' 1255 , 'Fripp' 1256 , 'AFRIPP' 1257 , '650.123.2234' 1258 , TO_DATE('10-APR-1997', 'dd-MON-yyyy') 1259 , 'ST_MAN' 1260 , 8200 1261 , NULL 1262 , 100 1263 , 50 1264 ); 1265 1266INSERT INTO employees VALUES 1267 ( 122 1268 , 'Payam' 1269 , 'Kaufling' 1270 , 'PKAUFLIN' 1271 , '650.123.3234' 1272 , TO_DATE('01-MAY-1995', 'dd-MON-yyyy') 1273 , 'ST_MAN' 1274 , 7900 1275 , NULL 1276 , 100 1277 , 50 1278 ); 1279 1280INSERT INTO employees VALUES 1281 ( 123 1282 , 'Shanta' 1283 , 'Vollman' 1284 , 'SVOLLMAN' 1285 , '650.123.4234' 1286 , TO_DATE('10-OCT-1997', 'dd-MON-yyyy') 1287 , 'ST_MAN' 1288 , 6500 1289 , NULL 1290 , 100 1291 , 50 1292 ); 1293 1294INSERT INTO employees VALUES 1295 ( 124 1296 , 'Kevin' 1297 , 'Mourgos' 1298 , 'KMOURGOS' 1299 , '650.123.5234' 1300 , TO_DATE('16-NOV-1999', 'dd-MON-yyyy') 1301 , 'ST_MAN' 1302 , 5800 1303 , NULL 1304 , 100 1305 , 50 1306 ); 1307 1308INSERT INTO employees VALUES 1309 ( 125 1310 , 'Julia' 1311 , 'Nayer' 1312 , 'JNAYER' 1313 , '650.124.1214' 1314 , TO_DATE('16-JUL-1997', 'dd-MON-yyyy') 1315 , 'ST_CLERK' 1316 , 3200 1317 , NULL 1318 , 120 1319 , 50 1320 ); 1321 1322INSERT INTO employees VALUES 1323 ( 126 1324 , 'Irene' 1325 , 'Mikkilineni' 1326 , 'IMIKKILI' 1327 , '650.124.1224' 1328 , TO_DATE('28-SEP-1998', 'dd-MON-yyyy') 1329 , 'ST_CLERK' 1330 , 2700 1331 , NULL 1332 , 120 1333 , 50 1334 ); 1335 1336INSERT INTO employees VALUES 1337 ( 127 1338 , 'James' 1339 , 'Landry' 1340 , 'JLANDRY' 1341 , '650.124.1334' 1342 , TO_DATE('14-JAN-1999', 'dd-MON-yyyy') 1343 , 'ST_CLERK' 1344 , 2400 1345 , NULL 1346 , 120 1347 , 50 1348 ); 1349 1350INSERT INTO employees VALUES 1351 ( 128 1352 , 'Steven' 1353 , 'Markle' 1354 , 'SMARKLE' 1355 , '650.124.1434' 1356 , TO_DATE('08-MAR-2000', 'dd-MON-yyyy') 1357 , 'ST_CLERK' 1358 , 2200 1359 , NULL 1360 , 120 1361 , 50 1362 ); 1363 1364INSERT INTO employees VALUES 1365 ( 129 1366 , 'Laura' 1367 , 'Bissot' 1368 , 'LBISSOT' 1369 , '650.124.5234' 1370 , TO_DATE('20-AUG-1997', 'dd-MON-yyyy') 1371 , 'ST_CLERK' 1372 , 3300 1373 , NULL 1374 , 121 1375 , 50 1376 ); 1377 1378INSERT INTO employees VALUES 1379 ( 130 1380 , 'Mozhe' 1381 , 'Atkinson' 1382 , 'MATKINSO' 1383 , '650.124.6234' 1384 , TO_DATE('30-OCT-1997', 'dd-MON-yyyy') 1385 , 'ST_CLERK' 1386 , 2800 1387 , NULL 1388 , 121 1389 , 50 1390 ); 1391 1392INSERT INTO employees VALUES 1393 ( 131 1394 , 'James' 1395 , 'Marlow' 1396 , 'JAMRLOW' 1397 , '650.124.7234' 1398 , TO_DATE('16-FEB-1997', 'dd-MON-yyyy') 1399 , 'ST_CLERK' 1400 , 2500 1401 , NULL 1402 , 121 1403 , 50 1404 ); 1405 1406INSERT INTO employees VALUES 1407 ( 132 1408 , 'TJ' 1409 , 'Olson' 1410 , 'TJOLSON' 1411 , '650.124.8234' 1412 , TO_DATE('10-APR-1999', 'dd-MON-yyyy') 1413 , 'ST_CLERK' 1414 , 2100 1415 , NULL 1416 , 121 1417 , 50 1418 ); 1419 1420INSERT INTO employees VALUES 1421 ( 133 1422 , 'Jason' 1423 , 'Mallin' 1424 , 'JMALLIN' 1425 , '650.127.1934' 1426 , TO_DATE('14-JUN-1996', 'dd-MON-yyyy') 1427 , 'ST_CLERK' 1428 , 3300 1429 , NULL 1430 , 122 1431 , 50 1432 ); 1433 1434INSERT INTO employees VALUES 1435 ( 134 1436 , 'Michael' 1437 , 'Rogers' 1438 , 'MROGERS' 1439 , '650.127.1834' 1440 , TO_DATE('26-AUG-1998', 'dd-MON-yyyy') 1441 , 'ST_CLERK' 1442 , 2900 1443 , NULL 1444 , 122 1445 , 50 1446 ); 1447 1448INSERT INTO employees VALUES 1449 ( 135 1450 , 'Ki' 1451 , 'Gee' 1452 , 'KGEE' 1453 , '650.127.1734' 1454 , TO_DATE('12-DEC-1999', 'dd-MON-yyyy') 1455 , 'ST_CLERK' 1456 , 2400 1457 , NULL 1458 , 122 1459 , 50 1460 ); 1461 1462INSERT INTO employees VALUES 1463 ( 136 1464 , 'Hazel' 1465 , 'Philtanker' 1466 , 'HPHILTAN' 1467 , '650.127.1634' 1468 , TO_DATE('06-FEB-2000', 'dd-MON-yyyy') 1469 , 'ST_CLERK' 1470 , 2200 1471 , NULL 1472 , 122 1473 , 50 1474 ); 1475 1476INSERT INTO employees VALUES 1477 ( 137 1478 , 'Renske' 1479 , 'Ladwig' 1480 , 'RLADWIG' 1481 , '650.121.1234' 1482 , TO_DATE('14-JUL-1995', 'dd-MON-yyyy') 1483 , 'ST_CLERK' 1484 , 3600 1485 , NULL 1486 , 123 1487 , 50 1488 ); 1489 1490INSERT INTO employees VALUES 1491 ( 138 1492 , 'Stephen' 1493 , 'Stiles' 1494 , 'SSTILES' 1495 , '650.121.2034' 1496 , TO_DATE('26-OCT-1997', 'dd-MON-yyyy') 1497 , 'ST_CLERK' 1498 , 3200 1499 , NULL 1500 , 123 1501 , 50 1502 ); 1503 1504INSERT INTO employees VALUES 1505 ( 139 1506 , 'John' 1507 , 'Seo' 1508 , 'JSEO' 1509 , '650.121.2019' 1510 , TO_DATE('12-FEB-1998', 'dd-MON-yyyy') 1511 , 'ST_CLERK' 1512 , 2700 1513 , NULL 1514 , 123 1515 , 50 1516 ); 1517 1518INSERT INTO employees VALUES 1519 ( 140 1520 , 'Joshua' 1521 , 'Patel' 1522 , 'JPATEL' 1523 , '650.121.1834' 1524 , TO_DATE('06-APR-1998', 'dd-MON-yyyy') 1525 , 'ST_CLERK' 1526 , 2500 1527 , NULL 1528 , 123 1529 , 50 1530 ); 1531 1532INSERT INTO employees VALUES 1533 ( 141 1534 , 'Trenna' 1535 , 'Rajs' 1536 , 'TRAJS' 1537 , '650.121.8009' 1538 , TO_DATE('17-OCT-1995', 'dd-MON-yyyy') 1539 , 'ST_CLERK' 1540 , 3500 1541 , NULL 1542 , 124 1543 , 50 1544 ); 1545 1546INSERT INTO employees VALUES 1547 ( 142 1548 , 'Curtis' 1549 , 'Davies' 1550 , 'CDAVIES' 1551 , '650.121.2994' 1552 , TO_DATE('29-JAN-1997', 'dd-MON-yyyy') 1553 , 'ST_CLERK' 1554 , 3100 1555 , NULL 1556 , 124 1557 , 50 1558 ); 1559 1560INSERT INTO employees VALUES 1561 ( 143 1562 , 'Randall' 1563 , 'Matos' 1564 , 'RMATOS' 1565 , '650.121.2874' 1566 , TO_DATE('15-MAR-1998', 'dd-MON-yyyy') 1567 , 'ST_CLERK' 1568 , 2600 1569 , NULL 1570 , 124 1571 , 50 1572 ); 1573 1574INSERT INTO employees VALUES 1575 ( 144 1576 , 'Peter' 1577 , 'Vargas' 1578 , 'PVARGAS' 1579 , '650.121.2004' 1580 , TO_DATE('09-JUL-1998', 'dd-MON-yyyy') 1581 , 'ST_CLERK' 1582 , 2500 1583 , NULL 1584 , 124 1585 , 50 1586 ); 1587 1588INSERT INTO employees VALUES 1589 ( 145 1590 , 'John' 1591 , 'Russell' 1592 , 'JRUSSEL' 1593 , '011.44.1344.429268' 1594 , TO_DATE('01-OCT-1996', 'dd-MON-yyyy') 1595 , 'SA_MAN' 1596 , 14000 1597 , .4 1598 , 100 1599 , 80 1600 ); 1601 1602INSERT INTO employees VALUES 1603 ( 146 1604 , 'Karen' 1605 , 'Partners' 1606 , 'KPARTNER' 1607 , '011.44.1344.467268' 1608 , TO_DATE('05-JAN-1997', 'dd-MON-yyyy') 1609 , 'SA_MAN' 1610 , 13500 1611 , .3 1612 , 100 1613 , 80 1614 ); 1615 1616INSERT INTO employees VALUES 1617 ( 147 1618 , 'Alberto' 1619 , 'Errazuriz' 1620 , 'AERRAZUR' 1621 , '011.44.1344.429278' 1622 , TO_DATE('10-MAR-1997', 'dd-MON-yyyy') 1623 , 'SA_MAN' 1624 , 12000 1625 , .3 1626 , 100 1627 , 80 1628 ); 1629 1630INSERT INTO employees VALUES 1631 ( 148 1632 , 'Gerald' 1633 , 'Cambrault' 1634 , 'GCAMBRAU' 1635 , '011.44.1344.619268' 1636 , TO_DATE('15-OCT-1999', 'dd-MON-yyyy') 1637 , 'SA_MAN' 1638 , 11000 1639 , .3 1640 , 100 1641 , 80 1642 ); 1643 1644INSERT INTO employees VALUES 1645 ( 149 1646 , 'Eleni' 1647 , 'Zlotkey' 1648 , 'EZLOTKEY' 1649 , '011.44.1344.429018' 1650 , TO_DATE('29-JAN-2000', 'dd-MON-yyyy') 1651 , 'SA_MAN' 1652 , 10500 1653 , .2 1654 , 100 1655 , 80 1656 ); 1657 1658INSERT INTO employees VALUES 1659 ( 150 1660 , 'Peter' 1661 , 'Tucker' 1662 , 'PTUCKER' 1663 , '011.44.1344.129268' 1664 , TO_DATE('30-JAN-1997', 'dd-MON-yyyy') 1665 , 'SA_REP' 1666 , 10000 1667 , .3 1668 , 145 1669 , 80 1670 ); 1671 1672INSERT INTO employees VALUES 1673 ( 151 1674 , 'David' 1675 , 'Bernstein' 1676 , 'DBERNSTE' 1677 , '011.44.1344.345268' 1678 , TO_DATE('24-MAR-1997', 'dd-MON-yyyy') 1679 , 'SA_REP' 1680 , 9500 1681 , .25 1682 , 145 1683 , 80 1684 ); 1685 1686INSERT INTO employees VALUES 1687 ( 152 1688 , 'Peter' 1689 , 'Hall' 1690 , 'PHALL' 1691 , '011.44.1344.478968' 1692 , TO_DATE('20-AUG-1997', 'dd-MON-yyyy') 1693 , 'SA_REP' 1694 , 9000 1695 , .25 1696 , 145 1697 , 80 1698 ); 1699 1700INSERT INTO employees VALUES 1701 ( 153 1702 , 'Christopher' 1703 , 'Olsen' 1704 , 'COLSEN' 1705 , '011.44.1344.498718' 1706 , TO_DATE('30-MAR-1998', 'dd-MON-yyyy') 1707 , 'SA_REP' 1708 , 8000 1709 , .2 1710 , 145 1711 , 80 1712 ); 1713 1714INSERT INTO employees VALUES 1715 ( 154 1716 , 'Nanette' 1717 , 'Cambrault' 1718 , 'NCAMBRAU' 1719 , '011.44.1344.987668' 1720 , TO_DATE('09-DEC-1998', 'dd-MON-yyyy') 1721 , 'SA_REP' 1722 , 7500 1723 , .2 1724 , 145 1725 , 80 1726 ); 1727 1728INSERT INTO employees VALUES 1729 ( 155 1730 , 'Oliver' 1731 , 'Tuvault' 1732 , 'OTUVAULT' 1733 , '011.44.1344.486508' 1734 , TO_DATE('23-NOV-1999', 'dd-MON-yyyy') 1735 , 'SA_REP' 1736 , 7000 1737 , .15 1738 , 145 1739 , 80 1740 ); 1741 1742INSERT INTO employees VALUES 1743 ( 156 1744 , 'Janette' 1745 , 'King' 1746 , 'JKING' 1747 , '011.44.1345.429268' 1748 , TO_DATE('30-JAN-1996', 'dd-MON-yyyy') 1749 , 'SA_REP' 1750 , 10000 1751 , .35 1752 , 146 1753 , 80 1754 ); 1755 1756INSERT INTO employees VALUES 1757 ( 157 1758 , 'Patrick' 1759 , 'Sully' 1760 , 'PSULLY' 1761 , '011.44.1345.929268' 1762 , TO_DATE('04-MAR-1996', 'dd-MON-yyyy') 1763 , 'SA_REP' 1764 , 9500 1765 , .35 1766 , 146 1767 , 80 1768 ); 1769 1770INSERT INTO employees VALUES 1771 ( 158 1772 , 'Allan' 1773 , 'McEwen' 1774 , 'AMCEWEN' 1775 , '011.44.1345.829268' 1776 , TO_DATE('01-AUG-1996', 'dd-MON-yyyy') 1777 , 'SA_REP' 1778 , 9000 1779 , .35 1780 , 146 1781 , 80 1782 ); 1783 1784INSERT INTO employees VALUES 1785 ( 159 1786 , 'Lindsey' 1787 , 'Smith' 1788 , 'LSMITH' 1789 , '011.44.1345.729268' 1790 , TO_DATE('10-MAR-1997', 'dd-MON-yyyy') 1791 , 'SA_REP' 1792 , 8000 1793 , .3 1794 , 146 1795 , 80 1796 ); 1797 1798INSERT INTO employees VALUES 1799 ( 160 1800 , 'Louise' 1801 , 'Doran' 1802 , 'LDORAN' 1803 , '011.44.1345.629268' 1804 , TO_DATE('15-DEC-1997', 'dd-MON-yyyy') 1805 , 'SA_REP' 1806 , 7500 1807 , .3 1808 , 146 1809 , 80 1810 ); 1811 1812INSERT INTO employees VALUES 1813 ( 161 1814 , 'Sarath' 1815 , 'Sewall' 1816 , 'SSEWALL' 1817 , '011.44.1345.529268' 1818 , TO_DATE('03-NOV-1998', 'dd-MON-yyyy') 1819 , 'SA_REP' 1820 , 7000 1821 , .25 1822 , 146 1823 , 80 1824 ); 1825 1826INSERT INTO employees VALUES 1827 ( 162 1828 , 'Clara' 1829 , 'Vishney' 1830 , 'CVISHNEY' 1831 , '011.44.1346.129268' 1832 , TO_DATE('11-NOV-1997', 'dd-MON-yyyy') 1833 , 'SA_REP' 1834 , 10500 1835 , .25 1836 , 147 1837 , 80 1838 ); 1839 1840INSERT INTO employees VALUES 1841 ( 163 1842 , 'Danielle' 1843 , 'Greene' 1844 , 'DGREENE' 1845 , '011.44.1346.229268' 1846 , TO_DATE('19-MAR-1999', 'dd-MON-yyyy') 1847 , 'SA_REP' 1848 , 9500 1849 , .15 1850 , 147 1851 , 80 1852 ); 1853 1854INSERT INTO employees VALUES 1855 ( 164 1856 , 'Mattea' 1857 , 'Marvins' 1858 , 'MMARVINS' 1859 , '011.44.1346.329268' 1860 , TO_DATE('24-JAN-2000', 'dd-MON-yyyy') 1861 , 'SA_REP' 1862 , 7200 1863 , .10 1864 , 147 1865 , 80 1866 ); 1867 1868INSERT INTO employees VALUES 1869 ( 165 1870 , 'David' 1871 , 'Lee' 1872 , 'DLEE' 1873 , '011.44.1346.529268' 1874 , TO_DATE('23-FEB-2000', 'dd-MON-yyyy') 1875 , 'SA_REP' 1876 , 6800 1877 , .1 1878 , 147 1879 , 80 1880 ); 1881 1882INSERT INTO employees VALUES 1883 ( 166 1884 , 'Sundar' 1885 , 'Ande' 1886 , 'SANDE' 1887 , '011.44.1346.629268' 1888 , TO_DATE('24-MAR-2000', 'dd-MON-yyyy') 1889 , 'SA_REP' 1890 , 6400 1891 , .10 1892 , 147 1893 , 80 1894 ); 1895 1896INSERT INTO employees VALUES 1897 ( 167 1898 , 'Amit' 1899 , 'Banda' 1900 , 'ABANDA' 1901 , '011.44.1346.729268' 1902 , TO_DATE('21-APR-2000', 'dd-MON-yyyy') 1903 , 'SA_REP' 1904 , 6200 1905 , .10 1906 , 147 1907 , 80 1908 ); 1909 1910INSERT INTO employees VALUES 1911 ( 168 1912 , 'Lisa' 1913 , 'Ozer' 1914 , 'LOZER' 1915 , '011.44.1343.929268' 1916 , TO_DATE('11-MAR-1997', 'dd-MON-yyyy') 1917 , 'SA_REP' 1918 , 11500 1919 , .25 1920 , 148 1921 , 80 1922 ); 1923 1924INSERT INTO employees VALUES 1925 ( 169 1926 , 'Harrison' 1927 , 'Bloom' 1928 , 'HBLOOM' 1929 , '011.44.1343.829268' 1930 , TO_DATE('23-MAR-1998', 'dd-MON-yyyy') 1931 , 'SA_REP' 1932 , 10000 1933 , .20 1934 , 148 1935 , 80 1936 ); 1937 1938INSERT INTO employees VALUES 1939 ( 170 1940 , 'Tayler' 1941 , 'Fox' 1942 , 'TFOX' 1943 , '011.44.1343.729268' 1944 , TO_DATE('24-JAN-1998', 'dd-MON-yyyy') 1945 , 'SA_REP' 1946 , 9600 1947 , .20 1948 , 148 1949 , 80 1950 ); 1951 1952INSERT INTO employees VALUES 1953 ( 171 1954 , 'William' 1955 , 'Smith' 1956 , 'WSMITH' 1957 , '011.44.1343.629268' 1958 , TO_DATE('23-FEB-1999', 'dd-MON-yyyy') 1959 , 'SA_REP' 1960 , 7400 1961 , .15 1962 , 148 1963 , 80 1964 ); 1965 1966INSERT INTO employees VALUES 1967 ( 172 1968 , 'Elizabeth' 1969 , 'Bates' 1970 , 'EBATES' 1971 , '011.44.1343.529268' 1972 , TO_DATE('24-MAR-1999', 'dd-MON-yyyy') 1973 , 'SA_REP' 1974 , 7300 1975 , .15 1976 , 148 1977 , 80 1978 ); 1979 1980INSERT INTO employees VALUES 1981 ( 173 1982 , 'Sundita' 1983 , 'Kumar' 1984 , 'SKUMAR' 1985 , '011.44.1343.329268' 1986 , TO_DATE('21-APR-2000', 'dd-MON-yyyy') 1987 , 'SA_REP' 1988 , 6100 1989 , .10 1990 , 148 1991 , 80 1992 ); 1993 1994INSERT INTO employees VALUES 1995 ( 174 1996 , 'Ellen' 1997 , 'Abel' 1998 , 'EABEL' 1999 , '011.44.1644.429267' 2000 , TO_DATE('11-MAY-1996', 'dd-MON-yyyy') 2001 , 'SA_REP' 2002 , 11000 2003 , .30 2004 , 149 2005 , 80 2006 ); 2007 2008INSERT INTO employees VALUES 2009 ( 175 2010 , 'Alyssa' 2011 , 'Hutton' 2012 , 'AHUTTON' 2013 , '011.44.1644.429266' 2014 , TO_DATE('19-MAR-1997', 'dd-MON-yyyy') 2015 , 'SA_REP' 2016 , 8800 2017 , .25 2018 , 149 2019 , 80 2020 ); 2021 2022INSERT INTO employees VALUES 2023 ( 176 2024 , 'Jonathon' 2025 , 'Taylor' 2026 , 'JTAYLOR' 2027 , '011.44.1644.429265' 2028 , TO_DATE('24-MAR-1998', 'dd-MON-yyyy') 2029 , 'SA_REP' 2030 , 8600 2031 , .20 2032 , 149 2033 , 80 2034 ); 2035 2036INSERT INTO employees VALUES 2037 ( 177 2038 , 'Jack' 2039 , 'Livingston' 2040 , 'JLIVINGS' 2041 , '011.44.1644.429264' 2042 , TO_DATE('23-APR-1998', 'dd-MON-yyyy') 2043 , 'SA_REP' 2044 , 8400 2045 , .20 2046 , 149 2047 , 80 2048 ); 2049 2050INSERT INTO employees VALUES 2051 ( 178 2052 , 'Kimberely' 2053 , 'Grant' 2054 , 'KGRANT' 2055 , '011.44.1644.429263' 2056 , TO_DATE('24-MAY-1999', 'dd-MON-yyyy') 2057 , 'SA_REP' 2058 , 7000 2059 , .15 2060 , 149 2061 , NULL 2062 ); 2063 2064INSERT INTO employees VALUES 2065 ( 179 2066 , 'Charles' 2067 , 'Johnson' 2068 , 'CJOHNSON' 2069 , '011.44.1644.429262' 2070 , TO_DATE('04-JAN-2000', 'dd-MON-yyyy') 2071 , 'SA_REP' 2072 , 6200 2073 , .10 2074 , 149 2075 , 80 2076 ); 2077 2078INSERT INTO employees VALUES 2079 ( 180 2080 , 'Winston' 2081 , 'Taylor' 2082 , 'WTAYLOR' 2083 , '650.507.9876' 2084 , TO_DATE('24-JAN-1998', 'dd-MON-yyyy') 2085 , 'SH_CLERK' 2086 , 3200 2087 , NULL 2088 , 120 2089 , 50 2090 ); 2091 2092INSERT INTO employees VALUES 2093 ( 181 2094 , 'Jean' 2095 , 'Fleaur' 2096 , 'JFLEAUR' 2097 , '650.507.9877' 2098 , TO_DATE('23-FEB-1998', 'dd-MON-yyyy') 2099 , 'SH_CLERK' 2100 , 3100 2101 , NULL 2102 , 120 2103 , 50 2104 ); 2105 2106INSERT INTO employees VALUES 2107 ( 182 2108 , 'Martha' 2109 , 'Sullivan' 2110 , 'MSULLIVA' 2111 , '650.507.9878' 2112 , TO_DATE('21-JUN-1999', 'dd-MON-yyyy') 2113 , 'SH_CLERK' 2114 , 2500 2115 , NULL 2116 , 120 2117 , 50 2118 ); 2119 2120INSERT INTO employees VALUES 2121 ( 183 2122 , 'Girard' 2123 , 'Geoni' 2124 , 'GGEONI' 2125 , '650.507.9879' 2126 , TO_DATE('03-FEB-2000', 'dd-MON-yyyy') 2127 , 'SH_CLERK' 2128 , 2800 2129 , NULL 2130 , 120 2131 , 50 2132 ); 2133 2134INSERT INTO employees VALUES 2135 ( 184 2136 , 'Nandita' 2137 , 'Sarchand' 2138 , 'NSARCHAN' 2139 , '650.509.1876' 2140 , TO_DATE('27-JAN-1996', 'dd-MON-yyyy') 2141 , 'SH_CLERK' 2142 , 4200 2143 , NULL 2144 , 121 2145 , 50 2146 ); 2147 2148INSERT INTO employees VALUES 2149 ( 185 2150 , 'Alexis' 2151 , 'Bull' 2152 , 'ABULL' 2153 , '650.509.2876' 2154 , TO_DATE('20-FEB-1997', 'dd-MON-yyyy') 2155 , 'SH_CLERK' 2156 , 4100 2157 , NULL 2158 , 121 2159 , 50 2160 ); 2161 2162INSERT INTO employees VALUES 2163 ( 186 2164 , 'Julia' 2165 , 'Dellinger' 2166 , 'JDELLING' 2167 , '650.509.3876' 2168 , TO_DATE('24-JUN-1998', 'dd-MON-yyyy') 2169 , 'SH_CLERK' 2170 , 3400 2171 , NULL 2172 , 121 2173 , 50 2174 ); 2175 2176INSERT INTO employees VALUES 2177 ( 187 2178 , 'Anthony' 2179 , 'Cabrio' 2180 , 'ACABRIO' 2181 , '650.509.4876' 2182 , TO_DATE('07-FEB-1999', 'dd-MON-yyyy') 2183 , 'SH_CLERK' 2184 , 3000 2185 , NULL 2186 , 121 2187 , 50 2188 ); 2189 2190INSERT INTO employees VALUES 2191 ( 188 2192 , 'Kelly' 2193 , 'Chung' 2194 , 'KCHUNG' 2195 , '650.505.1876' 2196 , TO_DATE('14-JUN-1997', 'dd-MON-yyyy') 2197 , 'SH_CLERK' 2198 , 3800 2199 , NULL 2200 , 122 2201 , 50 2202 ); 2203 2204INSERT INTO employees VALUES 2205 ( 189 2206 , 'Jennifer' 2207 , 'Dilly' 2208 , 'JDILLY' 2209 , '650.505.2876' 2210 , TO_DATE('13-AUG-1997', 'dd-MON-yyyy') 2211 , 'SH_CLERK' 2212 , 3600 2213 , NULL 2214 , 122 2215 , 50 2216 ); 2217 2218INSERT INTO employees VALUES 2219 ( 190 2220 , 'Timothy' 2221 , 'Gates' 2222 , 'TGATES' 2223 , '650.505.3876' 2224 , TO_DATE('11-JUL-1998', 'dd-MON-yyyy') 2225 , 'SH_CLERK' 2226 , 2900 2227 , NULL 2228 , 122 2229 , 50 2230 ); 2231 2232INSERT INTO employees VALUES 2233 ( 191 2234 , 'Randall' 2235 , 'Perkins' 2236 , 'RPERKINS' 2237 , '650.505.4876' 2238 , TO_DATE('19-DEC-1999', 'dd-MON-yyyy') 2239 , 'SH_CLERK' 2240 , 2500 2241 , NULL 2242 , 122 2243 , 50 2244 ); 2245 2246INSERT INTO employees VALUES 2247 ( 192 2248 , 'Sarah' 2249 , 'Bell' 2250 , 'SBELL' 2251 , '650.501.1876' 2252 , TO_DATE('04-FEB-1996', 'dd-MON-yyyy') 2253 , 'SH_CLERK' 2254 , 4000 2255 , NULL 2256 , 123 2257 , 50 2258 ); 2259 2260INSERT INTO employees VALUES 2261 ( 193 2262 , 'Britney' 2263 , 'Everett' 2264 , 'BEVERETT' 2265 , '650.501.2876' 2266 , TO_DATE('03-MAR-1997', 'dd-MON-yyyy') 2267 , 'SH_CLERK' 2268 , 3900 2269 , NULL 2270 , 123 2271 , 50 2272 ); 2273 2274INSERT INTO employees VALUES 2275 ( 194 2276 , 'Samuel' 2277 , 'McCain' 2278 , 'SMCCAIN' 2279 , '650.501.3876' 2280 , TO_DATE('01-JUL-1998', 'dd-MON-yyyy') 2281 , 'SH_CLERK' 2282 , 3200 2283 , NULL 2284 , 123 2285 , 50 2286 ); 2287 2288INSERT INTO employees VALUES 2289 ( 195 2290 , 'Vance' 2291 , 'Jones' 2292 , 'VJONES' 2293 , '650.501.4876' 2294 , TO_DATE('17-MAR-1999', 'dd-MON-yyyy') 2295 , 'SH_CLERK' 2296 , 2800 2297 , NULL 2298 , 123 2299 , 50 2300 ); 2301 2302INSERT INTO employees VALUES 2303 ( 196 2304 , 'Alana' 2305 , 'Walsh' 2306 , 'AWALSH' 2307 , '650.507.9811' 2308 , TO_DATE('24-APR-1998', 'dd-MON-yyyy') 2309 , 'SH_CLERK' 2310 , 3100 2311 , NULL 2312 , 124 2313 , 50 2314 ); 2315 2316INSERT INTO employees VALUES 2317 ( 197 2318 , 'Kevin' 2319 , 'Feeney' 2320 , 'KFEENEY' 2321 , '650.507.9822' 2322 , TO_DATE('23-MAY-1998', 'dd-MON-yyyy') 2323 , 'SH_CLERK' 2324 , 3000 2325 , NULL 2326 , 124 2327 , 50 2328 ); 2329 2330INSERT INTO employees VALUES 2331 ( 198 2332 , 'Donald' 2333 , 'OConnell' 2334 , 'DOCONNEL' 2335 , '650.507.9833' 2336 , TO_DATE('21-JUN-1999', 'dd-MON-yyyy') 2337 , 'SH_CLERK' 2338 , 2600 2339 , NULL 2340 , 124 2341 , 50 2342 ); 2343 2344INSERT INTO employees VALUES 2345 ( 199 2346 , 'Douglas' 2347 , 'Grant' 2348 , 'DGRANT' 2349 , '650.507.9844' 2350 , TO_DATE('13-JAN-2000', 'dd-MON-yyyy') 2351 , 'SH_CLERK' 2352 , 2600 2353 , NULL 2354 , 124 2355 , 50 2356 ); 2357 2358INSERT INTO employees VALUES 2359 ( 200 2360 , 'Jennifer' 2361 , 'Whalen' 2362 , 'JWHALEN' 2363 , '515.123.4444' 2364 , TO_DATE('17-SEP-1987', 'dd-MON-yyyy') 2365 , 'AD_ASST' 2366 , 4400 2367 , NULL 2368 , 101 2369 , 10 2370 ); 2371 2372INSERT INTO employees VALUES 2373 ( 201 2374 , 'Michael' 2375 , 'Hartstein' 2376 , 'MHARTSTE' 2377 , '515.123.5555' 2378 , TO_DATE('17-FEB-1996', 'dd-MON-yyyy') 2379 , 'MK_MAN' 2380 , 13000 2381 , NULL 2382 , 100 2383 , 20 2384 ); 2385 2386INSERT INTO employees VALUES 2387 ( 202 2388 , 'Pat' 2389 , 'Fay' 2390 , 'PFAY' 2391 , '603.123.6666' 2392 , TO_DATE('17-AUG-1997', 'dd-MON-yyyy') 2393 , 'MK_REP' 2394 , 6000 2395 , NULL 2396 , 201 2397 , 20 2398 ); 2399 2400INSERT INTO employees VALUES 2401 ( 203 2402 , 'Susan' 2403 , 'Mavris' 2404 , 'SMAVRIS' 2405 , '515.123.7777' 2406 , TO_DATE('07-JUN-1994', 'dd-MON-yyyy') 2407 , 'HR_REP' 2408 , 6500 2409 , NULL 2410 , 101 2411 , 40 2412 ); 2413 2414INSERT INTO employees VALUES 2415 ( 204 2416 , 'Hermann' 2417 , 'Baer' 2418 , 'HBAER' 2419 , '515.123.8888' 2420 , TO_DATE('07-JUN-1994', 'dd-MON-yyyy') 2421 , 'PR_REP' 2422 , 10000 2423 , NULL 2424 , 101 2425 , 70 2426 ); 2427 2428INSERT INTO employees VALUES 2429 ( 205 2430 , 'Shelley' 2431 , 'Higgins' 2432 , 'SHIGGINS' 2433 , '515.123.8080' 2434 , TO_DATE('07-JUN-1994', 'dd-MON-yyyy') 2435 , 'AC_MGR' 2436 , 12000 2437 , NULL 2438 , 101 2439 , 110 2440 ); 2441 2442INSERT INTO employees VALUES 2443 ( 206 2444 , 'William' 2445 , 'Gietz' 2446 , 'WGIETZ' 2447 , '515.123.8181' 2448 , TO_DATE('07-JUN-1994', 'dd-MON-yyyy') 2449 , 'AC_ACCOUNT' 2450 , 8300 2451 , NULL 2452 , 205 2453 , 110 2454 ); 2455 2456 2457INSERT INTO job_history 2458VALUES (102 2459 , TO_DATE('13-JAN-1993', 'dd-MON-yyyy') 2460 , TO_DATE('24-JUL-1998', 'dd-MON-yyyy') 2461 , 'IT_PROG' 2462 , 60); 2463 2464INSERT INTO job_history 2465VALUES (101 2466 , TO_DATE('21-SEP-1989', 'dd-MON-yyyy') 2467 , TO_DATE('27-OCT-1993', 'dd-MON-yyyy') 2468 , 'AC_ACCOUNT' 2469 , 110); 2470 2471INSERT INTO job_history 2472VALUES (101 2473 , TO_DATE('28-OCT-1993', 'dd-MON-yyyy') 2474 , TO_DATE('15-MAR-1997', 'dd-MON-yyyy') 2475 , 'AC_MGR' 2476 , 110); 2477 2478INSERT INTO job_history 2479VALUES (201 2480 , TO_DATE('17-FEB-1996', 'dd-MON-yyyy') 2481 , TO_DATE('19-DEC-1999', 'dd-MON-yyyy') 2482 , 'MK_REP' 2483 , 20); 2484 2485INSERT INTO job_history 2486VALUES (114 2487 , TO_DATE('24-MAR-1998', 'dd-MON-yyyy') 2488 , TO_DATE('31-DEC-1999', 'dd-MON-yyyy') 2489 , 'ST_CLERK' 2490 , 50 2491 ); 2492 2493INSERT INTO job_history 2494VALUES (122 2495 , TO_DATE('01-JAN-1999', 'dd-MON-yyyy') 2496 , TO_DATE('31-DEC-1999', 'dd-MON-yyyy') 2497 , 'ST_CLERK' 2498 , 50 2499 ); 2500 2501INSERT INTO job_history 2502VALUES (200 2503 , TO_DATE('17-SEP-1987', 'dd-MON-yyyy') 2504 , TO_DATE('17-JUN-1993', 'dd-MON-yyyy') 2505 , 'AD_ASST' 2506 , 90 2507 ); 2508 2509INSERT INTO job_history 2510VALUES (176 2511 , TO_DATE('24-MAR-1998', 'dd-MON-yyyy') 2512 , TO_DATE('31-DEC-1998', 'dd-MON-yyyy') 2513 , 'SA_REP' 2514 , 80 2515 ); 2516 2517INSERT INTO job_history 2518VALUES (176 2519 , TO_DATE('01-JAN-1999', 'dd-MON-yyyy') 2520 , TO_DATE('31-DEC-1999', 'dd-MON-yyyy') 2521 , 'SA_MAN' 2522 , 80 2523 ); 2524 2525INSERT INTO job_history 2526VALUES (200 2527 , TO_DATE('01-JUL-1994', 'dd-MON-yyyy') 2528 , TO_DATE('31-DEC-1998', 'dd-MON-yyyy') 2529 , 'AC_ACCOUNT' 2530 , 90 2531 ); 2532 2533 2534ALTER TABLE departments 2535 ENABLE CONSTRAINT dept_mgr_fk; 2536 2537COMMIT; 2538 2539CREATE INDEX emp_department_ix 2540 ON employees (department_id); 2541 2542CREATE INDEX emp_job_ix 2543 ON employees (job_id); 2544 2545CREATE INDEX emp_manager_ix 2546 ON employees (manager_id); 2547 2548CREATE INDEX emp_name_ix 2549 ON employees (last_name, first_name); 2550 2551CREATE INDEX dept_location_ix 2552 ON departments (location_id); 2553 2554CREATE INDEX jhist_job_ix 2555 ON job_history (job_id); 2556 2557CREATE INDEX jhist_employee_ix 2558 ON job_history (employee_id); 2559 2560CREATE INDEX jhist_department_ix 2561 ON job_history (department_id); 2562 2563CREATE INDEX loc_city_ix 2564 ON locations (city); 2565 2566CREATE INDEX loc_state_province_ix 2567 ON locations (state_province); 2568 2569CREATE INDEX loc_country_ix 2570 ON locations (country_id); 2571 2572COMMIT; 2573 2574CREATE OR REPLACE PROCEDURE secure_dml 2575IS 2576BEGIN 2577 IF TO_CHAR (SYSDATE, 'HH24:MI') NOT BETWEEN '08:00' AND '18:00' 2578 OR TO_CHAR (SYSDATE, 'DY') IN ('SAT', 'SUN') THEN 2579 RAISE_APPLICATION_ERROR (-20205, 2580 'You may only make changes during normal office hours'); 2581 END IF; 2582END secure_dml; 2583/ 2584 2585CREATE OR REPLACE TRIGGER secure_employees 2586 BEFORE INSERT OR UPDATE OR DELETE ON employees 2587BEGIN 2588 secure_dml; 2589END secure_employees; 2590/ 2591 2592 2593CREATE OR REPLACE PROCEDURE add_job_history 2594 ( p_emp_id job_history.employee_id%type 2595 , p_start_date job_history.start_date%type 2596 , p_end_date job_history.end_date%type 2597 , p_job_id job_history.job_id%type 2598 , p_department_id job_history.department_id%type 2599 ) 2600IS 2601BEGIN 2602 INSERT INTO job_history (employee_id, start_date, end_date, 2603 job_id, department_id) 2604 VALUES(p_emp_id, p_start_date, p_end_date, p_job_id, p_department_id); 2605END add_job_history; 2606/ 2607 2608CREATE OR REPLACE TRIGGER update_job_history 2609 AFTER UPDATE OF job_id, department_id ON employees 2610 FOR EACH ROW 2611BEGIN 2612 add_job_history(:old.employee_id, :old.hire_date, sysdate, 2613 :old.job_id, :old.department_id); 2614END; 2615/ 2616 2617COMMIT; 2618 2619COMMENT ON TABLE regions 2620IS 'Regions table that contains region numbers and names. Contains 4 rows; references with the Countries table.' 2621 2622COMMENT ON COLUMN regions.region_id 2623IS 'Primary key of regions table.' 2624 2625COMMENT ON COLUMN regions.region_name 2626IS 'Names of regions. Locations are in the countries of these regions.' 2627 2628COMMENT ON TABLE locations 2629IS 'Locations table that contains specific address of a specific office, 2630warehouse, and/or production site of a company. Does not store addresses / 2631locations of customers. Contains 23 rows; references with the 2632departments and countries tables. '; 2633 2634COMMENT ON COLUMN locations.location_id 2635IS 'Primary key of locations table'; 2636 2637COMMENT ON COLUMN locations.street_address 2638IS 'Street address of an office, warehouse, or production site of a company. 2639Contains building number and street name'; 2640 2641COMMENT ON COLUMN locations.postal_code 2642IS 'Postal code of the location of an office, warehouse, or production site 2643of a company. '; 2644 2645COMMENT ON COLUMN locations.city 2646IS 'A not null column that shows city where an office, warehouse, or 2647production site of a company is located. '; 2648 2649COMMENT ON COLUMN locations.state_province 2650IS 'State or Province where an office, warehouse, or production site of a 2651company is located.'; 2652 2653COMMENT ON COLUMN locations.country_id 2654IS 'Country where an office, warehouse, or production site of a company is 2655located. Foreign key to country_id column of the countries table.'; 2656 2657 2658COMMENT ON TABLE departments 2659IS 'Departments table that shows details of departments where employees 2660work. Contains 27 rows; references with locations, employees, and job_history tables.'; 2661 2662COMMENT ON COLUMN departments.department_id 2663IS 'Primary key column of departments table.'; 2664 2665COMMENT ON COLUMN departments.department_name 2666IS 'A not null column that shows name of a department. Administration, 2667Marketing, Purchasing, Human Resources, Shipping, IT, Executive, Public 2668Relations, Sales, Finance, and Accounting. '; 2669 2670COMMENT ON COLUMN departments.manager_id 2671IS 'Manager_id of a department. Foreign key to employee_id column of employees table. The manager_id column of the employee table references this column.'; 2672 2673COMMENT ON COLUMN departments.location_id 2674IS 'Location id where a department is located. Foreign key to location_id column of locations table.'; 2675 2676 2677COMMENT ON TABLE job_history 2678IS 'Table that stores job history of the employees. If an employee 2679changes departments within the job or changes jobs within the department, 2680new rows get inserted into this table with old job information of the 2681employee. Contains a complex primary key: employee_id+start_date. 2682Contains 25 rows. References with jobs, employees, and departments tables.'; 2683 2684COMMENT ON COLUMN job_history.employee_id 2685IS 'A not null column in the complex primary key employee_id+start_date. 2686Foreign key to employee_id column of the employee table'; 2687 2688COMMENT ON COLUMN job_history.start_date 2689IS 'A not null column in the complex primary key employee_id+start_date. 2690Must be less than the end_date of the job_history table. (enforced by 2691constraint jhist_date_interval)'; 2692 2693COMMENT ON COLUMN job_history.end_date 2694IS 'Last day of the employee in this job role. A not null column. Must be 2695greater than the start_date of the job_history table. 2696(enforced by constraint jhist_date_interval)'; 2697 2698COMMENT ON COLUMN job_history.job_id 2699IS 'Job role in which the employee worked in the past; foreign key to 2700job_id column in the jobs table. A not null column.'; 2701 2702COMMENT ON COLUMN job_history.department_id 2703IS 'Department id in which the employee worked in the past; foreign key to deparment_id column in the departments table'; 2704 2705 2706COMMENT ON TABLE countries 2707IS 'country table. Contains 25 rows. References with locations table.'; 2708 2709COMMENT ON COLUMN countries.country_id 2710IS 'Primary key of countries table.'; 2711 2712COMMENT ON COLUMN countries.country_name 2713IS 'Country name'; 2714 2715COMMENT ON COLUMN countries.region_id 2716IS 'Region ID for the country. Foreign key to region_id column in the departments table.'; 2717 2718COMMENT ON TABLE jobs 2719IS 'jobs table with job titles and salary ranges. Contains 19 rows. 2720References with employees and job_history table.'; 2721 2722COMMENT ON COLUMN jobs.job_id 2723IS 'Primary key of jobs table.'; 2724 2725COMMENT ON COLUMN jobs.job_title 2726IS 'A not null column that shows job title, e.g. AD_VP, FI_ACCOUNTANT'; 2727 2728COMMENT ON COLUMN jobs.min_salary 2729IS 'Minimum salary for a job title.'; 2730 2731COMMENT ON COLUMN jobs.max_salary 2732IS 'Maximum salary for a job title'; 2733 2734COMMENT ON TABLE employees 2735IS 'employees table. Contains 107 rows. References with departments, 2736jobs, job_history tables. Contains a self reference.'; 2737 2738COMMENT ON COLUMN employees.employee_id 2739IS 'Primary key of employees table.'; 2740 2741COMMENT ON COLUMN employees.first_name 2742IS 'First name of the employee. A not null column.'; 2743 2744COMMENT ON COLUMN employees.last_name 2745IS 'Last name of the employee. A not null column.'; 2746 2747COMMENT ON COLUMN employees.email 2748IS 'Email id of the employee'; 2749 2750COMMENT ON COLUMN employees.phone_number 2751IS 'Phone number of the employee; includes country code and area code'; 2752 2753COMMENT ON COLUMN employees.hire_date 2754IS 'Date when the employee started on this job. A not null column.'; 2755 2756COMMENT ON COLUMN employees.job_id 2757IS 'Current job of the employee; foreign key to job_id column of the 2758jobs table. A not null column.'; 2759 2760COMMENT ON COLUMN employees.salary 2761IS 'Monthly salary of the employee. Must be greater 2762than zero (enforced by constraint emp_salary_min)'; 2763 2764COMMENT ON COLUMN employees.commission_pct 2765IS 'Commission percentage of the employee; Only employees in sales 2766department elgible for commission percentage'; 2767 2768COMMENT ON COLUMN employees.manager_id 2769IS 'Manager id of the employee; has same domain as manager_id in 2770departments table. Foreign key to employee_id column of employees table. 2771(useful for reflexive joins and CONNECT BY query)'; 2772 2773COMMENT ON COLUMN employees.department_id 2774IS 'Department id where employee works; foreign key to department_id 2775column of the departments table'; 2776 2777COMMIT;
hr.sql
登陆查询
1[oracle@henry ~]$ sqlplus hr/hr@pdb1 2 3SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jun 7 23:56:11 2019 4Version 19.3.0.0.0 5 6Copyright (c) 1982, 2019, Oracle. All rights reserved. 7 8Last Successful login time: Fri Jun 07 2019 23:52:41 +08:00 9 10Connected to: 11Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production 12Version 19.3.0.0.0 13 14SQL> select table_name from user_tables; 15 16TABLE_NAME 17------------ 18REGIONS 19LOCATIONS 20DEPARTMENTS 21JOBS 22EMPLOYEES 23JOB_HISTORY 24COUNTRIES 25 267 rows selected. 27 28SQL> select count(*) from employees; 29 30 COUNT(*) 31---------- 32 107