User HR altered.

SP2-0556: Invalid file name.
SQL> -- The SQL*Plus script store_schema.sql performs the following:
SQL> --   1. Creates store user
SQL> --   2. Creates the database tables, PL/SQL packages, etc.
SQL> --   3. Populates the database tables with example data
SQL>
SQL> -- This script should be run by the system user (or the DBA)
SQL> CONNECT system/manager;
Error starting at line : 9 File @ D:\sql_book_11g\SQL\store_schema.sql
In command -
  connect ...
Error report -
Connection Failed
  USER          = system
  URL           = jdbc:oracle:thin:@localhost:1521:xe
  Error Message = ORA-01017: invalid username/password; logon denied
Commit
SQL>
SQL> -- drop store user
SQL> DROP USER store CASCADE;
SP2-0640: Not connected
SQL>
SQL> -- create store user
SQL> CREATE USER store IDENTIFIED BY store_password;
SP2-0640: Not connected
SQL>
SQL> -- allow store user to connect and create database objects
SQL> GRANT connect, resource TO store;
SP2-0640: Not connected
SQL>
SQL> -- connect as store user
SQL> CONNECT store/store_password;
Error starting at line : 21 File @ D:\sql_book_11g\SQL\store_schema.sql
In command -
  connect ...
Error report -
Connection Failed
  USER          = store
  URL           = jdbc:oracle:thin:@localhost:1521:xe
  Error Message = ORA-01017: invalid username/password; logon denied
SQL>
SQL>
SQL> -- create the tables
SQL> CREATE TABLE customers (
  2    customer_id INTEGER
  3      CONSTRAINT customers_pk PRIMARY KEY,
  4    first_name VARCHAR2(10) NOT NULL,
  5    last_name VARCHAR2(10) NOT NULL,
  6    dob DATE,
  7    phone VARCHAR2(12)
  8  );
SP2-0640: Not connected
SQL>
SQL> CREATE TABLE product_types (
  2    product_type_id INTEGER
  3      CONSTRAINT product_types_pk PRIMARY KEY,
  4    name VARCHAR2(10) NOT NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> CREATE TABLE products (
  2    product_id INTEGER
  3      CONSTRAINT products_pk PRIMARY KEY,
  4    product_type_id INTEGER
  5      CONSTRAINT products_fk_product_types
  6      REFERENCES product_types(product_type_id),
  7    name VARCHAR2(30) NOT NULL,
  8    description VARCHAR2(50),
  9    price NUMBER(5, 2)
 10  );
SP2-0640: Not connected
SQL>
SQL> CREATE TABLE purchases (
  2    product_id INTEGER
  3      CONSTRAINT purchases_fk_products
  4      REFERENCES products(product_id),
  5    customer_id INTEGER
  6      CONSTRAINT purchases_fk_customers
  7      REFERENCES customers(customer_id),
  8    quantity INTEGER NOT NULL,
  9    CONSTRAINT purchases_pk PRIMARY KEY (product_id, customer_id)
 10  );
SP2-0640: Not connected
SQL>
SQL> CREATE TABLE employees (
  2    employee_id INTEGER
  3      CONSTRAINT employees_pk PRIMARY KEY,
  4    manager_id INTEGER,
  5    first_name VARCHAR2(10) NOT NULL,
  6    last_name VARCHAR2(10) NOT NULL,
  7    title VARCHAR2(20),
  8    salary NUMBER(6, 0)
  9  );
SP2-0640: Not connected
SQL>
SQL> CREATE TABLE salary_grades (
  2    salary_grade_id INTEGER
  3      CONSTRAINT salary_grade_pk PRIMARY KEY,
  4    low_salary NUMBER(6, 0),
  5    high_salary NUMBER(6, 0)
  6  );
SP2-0640: Not connected
SQL>
SQL> CREATE TABLE purchases_with_timestamp (
  2    product_id INTEGER REFERENCES products(product_id),
  3    customer_id INTEGER REFERENCES customers(customer_id),
  4    made_on TIMESTAMP(4)
  5  );
SP2-0640: Not connected
SQL>
SQL> CREATE TABLE purchases_timestamp_with_tz (
  2    product_id INTEGER REFERENCES products(product_id),
  3    customer_id INTEGER REFERENCES customers(customer_id),
  4    made_on TIMESTAMP(4) WITH TIME ZONE
  5  );
SP2-0640: Not connected
SQL>
SQL> CREATE TABLE purchases_with_local_tz (
  2    product_id INTEGER REFERENCES products(product_id),
  3    customer_id INTEGER REFERENCES customers(customer_id),
  4    made_on TIMESTAMP(4) WITH LOCAL TIME ZONE
  5  );
SP2-0640: Not connected
SQL>
SQL> CREATE TABLE coupons (
  2    coupon_id INTEGER CONSTRAINT coupons_pk PRIMARY KEY,
  3    name VARCHAR2(32) NOT NULL,
  4    duration INTERVAL YEAR(3) TO MONTH
  5  );
SP2-0640: Not connected
SQL>
SQL> CREATE TABLE promotions (
  2    promotion_id INTEGER CONSTRAINT promotions_pk PRIMARY KEY,
  3    name VARCHAR2(30) NOT NULL,
  4    duration INTERVAL DAY(3) TO SECOND (4)
  5  );
SP2-0640: Not connected
SQL>
SQL> CREATE TABLE order_status (
  2    order_status_id INTEGER
  3      CONSTRAINT default_example_pk PRIMARY KEY,
  4    status VARCHAR2(20) DEFAULT 'Zam˘wienie z�oľone' NOT NULL,
  5    last_modified DATE DEFAULT SYSDATE
  6  );
SP2-0640: Not connected
SQL>
SQL> CREATE TABLE product_changes (
  2    product_id INTEGER
  3      CONSTRAINT prod_changes_pk PRIMARY KEY,
  4    product_type_id INTEGER
  5      CONSTRAINT prod_changes_fk_product_types
  6      REFERENCES product_types(product_type_id),
  7    name VARCHAR2(30) NOT NULL,
  8    description VARCHAR2(50),
  9    price NUMBER(5, 2)
 10  );
SP2-0640: Not connected
SQL>
SQL> CREATE TABLE more_products (
  2    prd_id INTEGER
  3      CONSTRAINT more_products_pk PRIMARY KEY,
  4    prd_type_id INTEGER
  5      CONSTRAINT more_products_fk_product_types
  6      REFERENCES product_types(product_type_id),
  7    name VARCHAR2(30) NOT NULL,
  8    available CHAR(1)
  9  );
SP2-0640: Not connected
SQL>
SQL> CREATE TABLE more_employees (
  2    employee_id INTEGER
  3      CONSTRAINT more_employees_pk PRIMARY KEY,
  4    manager_id INTEGER
  5      CONSTRAINT more_empl_fk_fk_more_empl
  6      REFERENCES more_employees(employee_id),
  7    first_name VARCHAR2(10) NOT NULL,
  8    last_name VARCHAR2(10) NOT NULL,
  9    title VARCHAR2(20),
 10    salary NUMBER(6, 0)
 11  );
SP2-0640: Not connected
SQL>
SQL> CREATE TABLE divisions (
  2    division_id CHAR(4)
  3      CONSTRAINT divisions_pk PRIMARY KEY,
  4    name VARCHAR2(15) NOT NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> CREATE TABLE jobs (
  2    job_id CHAR(4)
  3      CONSTRAINT jobs_pk PRIMARY KEY,
  4    name VARCHAR2(20) NOT NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> CREATE TABLE employees2 (
  2    employee_id INTEGER
  3      CONSTRAINT employees2_pk PRIMARY KEY,
  4    division_id CHAR(4)
  5      CONSTRAINT employees2_fk_divisions
  6      REFERENCES divisions(division_id),
  7    job_id CHAR(4) REFERENCES jobs(job_id),
  8    first_name NVARCHAR2(11) NOT NULL,
  9    last_name NVARCHAR2(11) NOT NULL,
 10    salary NUMBER(6, 0)
 11  );
SP2-0640: Not connected
SQL>
SQL> CREATE TABLE all_sales (
  2    year INTEGER NOT NULL,
  3    month INTEGER NOT NULL,
  4    prd_type_id INTEGER
  5      CONSTRAINT all_sales_fk_product_types
  6      REFERENCES product_types(product_type_id),
  7    emp_id INTEGER
  8      CONSTRAINT all_sales_fk_employees2
  9      REFERENCES employees2(employee_id),
 10    amount NUMBER(8, 2),
 11    CONSTRAINT all_sales_pk PRIMARY KEY (
 12      year, month, prd_type_id, emp_id
 13    )
 14  );
SP2-0640: Not connected
SQL>
SQL> CREATE TABLE product_price_audit (
  2    product_id INTEGER
  3      CONSTRAINT price_audit_fk_products
  4      REFERENCES products(product_id),
  5    old_price  NUMBER(5, 2),
  6    new_price  NUMBER(5, 2)
  7  );
SP2-0640: Not connected
SQL>
SQL> CREATE TABLE reg_exps (
  2    id NUMBER
  3      CONSTRAINT reg_exps_pk PRIMARY KEY,
  4    text VARCHAR2(512) NOT NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> -- create the PL/SQL functions, procedures, packages and triggers
SQL>
SQL> CREATE OR REPLACE PROCEDURE update_product_price(
  2    p_product_id IN products.product_id%TYPE,
  3    p_factor     IN NUMBER
  4  ) AS
  5    v_product_count INTEGER;
  6  BEGIN
  7    -- zlicza produkty z przes�anym
  8    -- product_id (powinno by† 1, jeľeli produkt istnieje)
  9    SELECT COUNT(*)
 10    INTO v_product_count
 11    FROM products
 12    WHERE product_id = p_product_id;
 13
 14    -- jeľeli produkt istnieje (v_product_count = 1),
 15    -- aktualizuje jego cen©
 16    IF v_product_count = 1 THEN
 17      UPDATE products
 18      SET price = price * p_factor
 19      WHERE product_id = p_product_id;
 20      COMMIT;
 21    END IF;
 22  EXCEPTION
 23    WHEN OTHERS THEN
 24      ROLLBACK;
 25  END update_product_price;
 26  /
SP2-0640: Not connected
SQL>
SQL> CREATE OR REPLACE FUNCTION circle_area (
  2    p_radius IN NUMBER
  3  ) RETURN NUMBER AS
  4    v_pi   NUMBER := 3.1415926;
  5    v_area NUMBER;
  6  BEGIN
  7    v_area := v_pi * POWER(p_radius, 2);
  8    RETURN v_area;
  9  END circle_area;
 10  /
SP2-0640: Not connected
SQL>
SQL> CREATE OR REPLACE FUNCTION average_product_price (
  2    p_product_type_id IN INTEGER
  3  ) RETURN NUMBER AS
  4    v_average_product_price NUMBER;
  5  BEGIN
  6    SELECT AVG(price)
  7    INTO v_average_product_price
  8    FROM products
  9    WHERE product_type_id = p_product_type_id;
 10    RETURN v_average_product_price;
 11  END average_product_price;
 12  /
SP2-0640: Not connected
SQL>
SQL> CREATE OR REPLACE PACKAGE product_package AS
  2    TYPE t_ref_cursor IS REF CURSOR;
  3    FUNCTION get_products_ref_cursor RETURN t_ref_cursor;
  4    PROCEDURE update_product_price (
  5      p_product_id IN products.product_id%TYPE,
  6      p_factor     IN NUMBER
  7    );
  8  END product_package;
  9  /
SP2-0640: Not connected
SQL>
SQL> CREATE OR REPLACE PACKAGE BODY product_package AS
  2    FUNCTION get_products_ref_cursor
  3    RETURN t_ref_cursor IS
  4      products_ref_cursor t_ref_cursor;
  5    BEGIN
  6      -- pobierz REF CURSOR
  7      OPEN products_ref_cursor FOR
  8        SELECT product_id, name, price
  9        FROM products;
 10      -- zwraca REF CURSOR
 11      RETURN products_ref_cursor;
 12    END get_products_ref_cursor;
 13
 14    PROCEDURE update_product_price (
 15      p_product_id IN products.product_id%TYPE,
 16      p_factor     IN NUMBER
 17    ) AS
 18      v_product_count INTEGER;
 19    BEGIN
 20      -- zlicza produkty z przes�anym
 21      -- product_id (jeľeli produkt istnieje powinno by† 1)
 22      SELECT COUNT(*)
 23      INTO v_product_count
 24      FROM products
 25      WHERE product_id = p_product_id;
 26      -- jeľeli produkt istnieje (v_product_count = 1),
 27      -- aktualizuje jego cen©
 28      IF v_product_count = 1 THEN
 29        UPDATE products
 30        SET price = price * p_factor
 31        WHERE product_id = p_product_id;
 32        COMMIT;
 33      END IF;
 34    EXCEPTION
 35      WHEN OTHERS THEN
 36        -- jeľeli wystĄpi wyjĄtek, zmiany sĄ wycofywane
 37        ROLLBACK;
 38    END update_product_price;
 39  END product_package;
 40  /
SP2-0640: Not connected
SQL>
SQL> CREATE OR REPLACE TRIGGER before_product_price_update
  2  BEFORE UPDATE OF price
  3  ON products
  4  FOR EACH ROW WHEN (new.price < old.price * 0.75)
  5  BEGIN
  6    dbms_output.put_line('product_id = ' || :old.product_id);
  7    dbms_output.put_line('Stara cena = ' || :old.price);
  8    dbms_output.put_line('Nowa cena = ' || :new.price);
  9    dbms_output.put_line('Obniľono cen© o ponad 25%');
 10
 11    -- insert row into the product_price_audit table
 12    INSERT INTO product_price_audit (
 13      product_id, old_price, new_price
 14    ) VALUES (
 15      :old.product_id, :old.price, :new.price
 16    );
 17  END before_product_price_update;
 18  /
SP2-0640: Not connected
SQL>
SQL> -- insert sample data into customers table
SQL>
SQL> INSERT INTO customers (
  2    customer_id, first_name, last_name, dob, phone
  3  ) VALUES (
  4    1, 'Jan', 'Nikiel', '1965/01/01', '800-555-1211'
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO customers (
  2    customer_id, first_name, last_name, dob, phone
  3  ) VALUES (
  4    2, 'Lidia', 'Stal', '1968/02/05', '800-555-1212'
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO customers (
  2    customer_id, first_name, last_name, dob, phone
  3  ) VALUES (
  4    3, 'Stefan', 'BrĄz', '1971/03/16', '800-555-1213'
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO customers (
  2    customer_id, first_name, last_name, dob, phone
  3  ) VALUES (
  4    4, 'Graľyna', 'Cynk', NULL, '800-555-1214'
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO customers (
  2    customer_id, first_name, last_name, dob, phone
  3  ) VALUES (
  4    5, 'Jadwiga', 'MosiĄdz', '1970/05/20', NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> -- commit the transaction
SQL> COMMIT;
SP2-0640: Not connected
SQL>
SQL> -- insert sample data into product_types table
SQL>
SQL> INSERT INTO product_types (
  2    product_type_id, name
  3  ) VALUES (
  4    1, 'KsiĄľka'
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO product_types (
  2    product_type_id, name
  3  ) VALUES (
  4    2, 'VHS'
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO product_types (
  2    product_type_id, name
  3  ) VALUES (
  4    3, 'DVD'
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO product_types (
  2    product_type_id, name
  3  ) VALUES (
  4    4, 'CD'
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO product_types (
  2    product_type_id, name
  3  ) VALUES (
  4    5, 'Czasopismo'
  5  );
SP2-0640: Not connected
SQL>
SQL> -- commit the transaction
SQL> COMMIT;
SP2-0640: Not connected
SQL>
SQL> -- insert sample data into products table
SQL>
SQL> INSERT INTO products (
  2    product_id, product_type_id, name, description, price
  3  ) VALUES (
  4    1, 1, 'Nauka wsp˘�czesna', 'Opis wsp˘�czesnej nauki', 19.95
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO products (
  2    product_id, product_type_id, name, description, price
  3  ) VALUES (
  4    2, 1, 'Chemia', 'Wprowadzenie do chemii', 30.00
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO products (
  2    product_id, product_type_id, name, description, price
  3  ) VALUES (
  4    3, 2, 'Supernowa', 'Eksplozja gwiazdy', 25.99
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO products (
  2    product_id, product_type_id, name, description, price
  3  ) VALUES (
  4    4, 2, 'Wojny czo�g˘w', 'Film akcji o nadchodzĄcej wojnie', 13.95
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO products (
  2    product_id, product_type_id, name, description, price
  3  ) VALUES (
  4    5, 2, 'Z Files', 'Serial o tajemniczych zjawiskach', 49.99
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO products (
  2    product_id, product_type_id, name, description, price
  3  ) VALUES (
  4    6, 2, '2412: Powr˘t', 'Powr˘t obcych', 14.95
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO products (
  2    product_id, product_type_id, name, description, price
  3  )
  4  VALUES (
  5    7, 3, 'Space Force 9', 'Przygody bohater˘w', 13.49
  6  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO products (
  2    product_id, product_type_id, name, description, price
  3  ) VALUES (
  4    8, 3, 'Z innej planety', 'Obcy z innej planety lĄduje na Ziemi', 12.99
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO products (
  2    product_id, product_type_id, name, description, price
  3  ) VALUES (
  4    9, 4, 'Muzyka klasyczna', 'Nalepsze dzie�a muzyki klasycznej', 10.99
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO products (
  2    product_id, product_type_id, name, description, price
  3  ) VALUES (
  4    10, 4, 'Pop 3', 'Najlepsze utwory popowe', 15.99
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO products (
  2    product_id, product_type_id, name, description, price
  3  ) VALUES (
  4    11, 4, 'Tw˘rczy wrzask', 'Album debiutancki', 14.99
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO products (
  2    product_id, product_type_id, name, description, price
  3  ) VALUES (
  4    12, NULL, 'Pierwsza linia', 'Najwi©ksze hity', 13.49
  5  );
SP2-0640: Not connected
SQL>
SQL> -- commit the transaction
SQL> COMMIT;
SP2-0640: Not connected
SQL>
SQL> -- insert sample data into purchases table
SQL>
SQL> INSERT INTO purchases (
  2    product_id, customer_id, quantity
  3  ) VALUES (
  4    1, 1, 1
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO purchases (
  2    product_id, customer_id, quantity
  3  ) VALUES (
  4    2, 1, 3
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO purchases (
  2    product_id, customer_id, quantity
  3  ) VALUES (
  4    1, 4, 1
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO purchases (
  2    product_id, customer_id, quantity
  3  ) VALUES (
  4    2, 2, 1
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO purchases (
  2    product_id, customer_id, quantity
  3  ) VALUES (
  4    1, 3, 1
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO purchases (
  2    product_id, customer_id, quantity
  3  ) VALUES (
  4    1, 2, 2
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO purchases (
  2    product_id, customer_id, quantity
  3  ) VALUES (
  4    2, 3, 1
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO purchases (
  2    product_id, customer_id, quantity
  3  ) VALUES (
  4    2, 4, 1
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO purchases (
  2    product_id, customer_id, quantity
  3  ) VALUES (
  4    3, 3, 1
  5  );
SP2-0640: Not connected
SQL>
SQL> -- commit the transaction
SQL> COMMIT;
SP2-0640: Not connected
SQL>
SQL> -- insert sample data into employees table
SQL>
SQL> INSERT INTO employees (
  2    employee_id, manager_id, first_name, last_name, title, salary
  3  ) VALUES (
  4    1, NULL, 'Jan', 'Kowalski', 'CEO', 800000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees (
  2    employee_id, manager_id, first_name, last_name, title, salary
  3  ) VALUES (
  4    2, 1, 'Roman', 'Jo�wierz', 'Kierownik sprzedaľy', 600000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees (
  2    employee_id, manager_id, first_name, last_name, title, salary
  3  ) VALUES (
  4    3, 2, 'Fryderyk', 'Helc', 'Sprzedawca', 150000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees (
  2    employee_id, manager_id, first_name, last_name, title, salary
  3  ) VALUES (
  4    4, 2, 'Zofia', 'Nowak', 'Sprzedawca', 500000
  5  );
SP2-0640: Not connected
SQL>
SQL> -- commit the transaction
SQL> COMMIT;
SP2-0640: Not connected
SQL>
SQL> -- insert sample data into salary_grade table
SQL>
SQL> INSERT INTO salary_grades (
  2    salary_grade_id, low_salary, high_salary
  3  ) VALUES (
  4    1, 1, 250000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO salary_grades (
  2    salary_grade_id, low_salary, high_salary
  3  ) VALUES (
  4    2, 250001, 500000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO salary_grades (
  2    salary_grade_id, low_salary, high_salary
  3  ) VALUES (
  4    3, 500001, 750000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO salary_grades (
  2    salary_grade_id, low_salary, high_salary
  3  ) VALUES (
  4    4, 750001, 999999
  5  );
SP2-0640: Not connected
SQL>
SQL> -- commit the transaction
SQL> COMMIT;
SP2-0640: Not connected
SQL>
SQL> -- insert sample data into purchases_with_timestamp table
SQL>
SQL> INSERT INTO purchases_with_timestamp (
  2    product_id, customer_id, made_on
  3  ) VALUES (
  4    1, 1, TIMESTAMP '2005-05-13 07:15:31.1234'
  5  );
SP2-0640: Not connected
SQL>
SQL> -- commit the transaction
SQL> COMMIT;
SP2-0640: Not connected
SQL>
SQL> -- insert sample data into purchases_with_tz table
SQL>
SQL> INSERT INTO purchases_timestamp_with_tz (
  2    product_id, customer_id, made_on
  3  ) VALUES (
  4    1, 1, TIMESTAMP '2005-05-13 07:15:31.1234 -07:00'
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO purchases_timestamp_with_tz (
  2    product_id, customer_id, made_on
  3  ) VALUES (
  4    1, 2, TIMESTAMP '2005-05-13 07:15:31.1234 CET'
  5  );
SP2-0640: Not connected
SQL>
SQL> -- commit the transaction
SQL> COMMIT;
SP2-0640: Not connected
SQL>
SQL> -- insert sample data into purchases_with_local_tz table
SQL>
SQL> INSERT INTO purchases_with_local_tz (
  2    product_id, customer_id, made_on
  3  ) VALUES (
  4    1, 1, TIMESTAMP '2005-05-13 07:15:30 EST'
  5  );
SP2-0640: Not connected
SQL>
SQL> -- commit the transaction
SQL> COMMIT;
SP2-0640: Not connected
SQL>
SQL> -- insert sample data into coupons table
SQL>
SQL> INSERT INTO coupons (
  2    coupon_id, name, duration
  3  ) VALUES (
  4    1, 'Z Files 1 z� taniej', INTERVAL '1' YEAR
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO coupons (
  2    coupon_id, name, duration
  3  ) VALUES (
  4    2, 'Pop 2 z� taniej', INTERVAL '11' MONTH
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO coupons (
  2    coupon_id, name, duration
  3  ) VALUES (
  4    3, 'Nauka wsp˘�czesna 3 z� taniej', INTERVAL '14' MONTH
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO coupons (
  2    coupon_id, name, duration
  3  ) VALUES (
  4    4, 'Wojny czo�g˘w 2 z� taniej', INTERVAL '1-3' YEAR TO MONTH
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO coupons (
  2    coupon_id, name, duration
  3  ) VALUES (
  4    5, 'Chemia 1 z� taniej', INTERVAL '0-5' YEAR TO MONTH
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO coupons (
  2    coupon_id, name, duration
  3  ) VALUES (
  4    6, 'Tw˘rczy wrzask 2 z� taniej', INTERVAL '123' YEAR(3)
  5  );
SP2-0640: Not connected
SQL>
SQL> -- commit the transaction
SQL> COMMIT;
SP2-0640: Not connected
SQL>
SQL> -- insert sample data into promotions table
SQL>
SQL> INSERT INTO promotions (
  2    promotion_id, name, duration
  3  ) VALUES (
  4    1, '10% taniej Z Files', INTERVAL '3' DAY
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO promotions (
  2    promotion_id, name, duration
  3  ) VALUES (
  4    2, '20% taniej Pop 3', INTERVAL '2' HOUR
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO promotions (
  2    promotion_id, name, duration
  3  ) VALUES (
  4    3, '30% taniej Nauka wsp˘�czesna', INTERVAL '25' MINUTE
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO promotions (
  2    promotion_id, name, duration
  3  ) VALUES (
  4    4, '20% taniej Wojny czo�g˘w', INTERVAL '45' SECOND
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO promotions (
  2    promotion_id, name, duration
  3  ) VALUES (
  4    5, '10% taniej Chemia', INTERVAL '3 2:25' DAY TO MINUTE
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO promotions (
  2    promotion_id, name, duration
  3  ) VALUES (
  4    6, '20% taniej Tw˘rczy wrzask', INTERVAL '3 2:25:45' DAY TO SECOND
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO promotions (
  2    promotion_id, name, duration
  3  ) VALUES (
  4    7, '15% taniej Pierwsza linia', INTERVAL '123 2:25:45.12' DAY(3) TO SECOND(2)
  5  );
SP2-0640: Not connected
SQL>
SQL> -- commit the transaction
SQL> COMMIT;
SP2-0640: Not connected
SQL>
SQL> -- insert sample data into order_status table
SQL>
SQL> INSERT INTO order_status (
  2    order_status_id
  3  ) VALUES (
  4    1
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO order_status (
  2    order_status_id, status, last_modified
  3  ) VALUES (
  4    2, 'Zam˘wienie wys�ane', '04/06/10'
  5  );
SP2-0640: Not connected
SQL>
SQL> -- commit the transaction
SQL> COMMIT;
SP2-0640: Not connected
SQL>
SQL> -- insert sample data into product_changes table
SQL>
SQL> INSERT INTO product_changes (
  2    product_id, product_type_id, name, description, price
  3  ) VALUES (
  4    1, 1, 'Nauka wsp˘�czesna', 'Opis wsp˘�czesnej nauki', 40.00
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO product_changes (
  2    product_id, product_type_id, name, description, price
  3  ) VALUES (
  4    2, 1, 'Nowa Chemia', 'Wprowadzenie do chemii', 35.00
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO product_changes (
  2    product_id, product_type_id, name, description, price
  3  ) VALUES (
  4    3, 1, 'Supernowa', 'Wybuch gwiazdy', 25.99
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO product_changes (
  2    product_id, product_type_id, name, description, price
  3  ) VALUES (
  4    13, 2, 'LĄdowanie na Ksi©ľycu', 'Dokumentalny', 15.99
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO product_changes (
  2    product_id, product_type_id, name, description, price
  3  ) VALUES (
  4    14, 2, 'ť˘d« podwodna', 'Dokumentalny', 15.99
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO product_changes (
  2    product_id, product_type_id, name, description, price
  3  ) VALUES (
  4    15, 2, 'Samolot', 'Dokumentalny', 15.99
  5  );
SP2-0640: Not connected
SQL>
SQL> -- commit the transaction
SQL> COMMIT;
SP2-0640: Not connected
SQL>
SQL> -- insert sample data into more_products table
SQL>
SQL> INSERT INTO more_products (
  2    prd_id, prd_type_id, name, available
  3  ) VALUES (
  4    1, 1, 'Nauka wsp˘�czesna', 'Y'
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO more_products (
  2    prd_id, prd_type_id, name, available
  3  ) VALUES (
  4    2, 1, 'Chemia', 'Y'
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO more_products (
  2    prd_id, prd_type_id, name, available
  3  ) VALUES (
  4    3, NULL, 'Supernowa', 'N'
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO more_products (
  2    prd_id, prd_type_id, name, available
  3  ) VALUES (
  4    4, 2, 'LĄdowanie na Ksi©ľycu', 'N'
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO more_products (
  2    prd_id, prd_type_id, name, available
  3  ) VALUES (
  4    5, 2, 'ť˘d« podwodna', 'Y'
  5  );
SP2-0640: Not connected
SQL>
SQL> -- commit the transaction
SQL> COMMIT;
SP2-0640: Not connected
SQL>
SQL> -- insert sample data into more_employees table
SQL>
SQL> INSERT INTO more_employees (
  2    employee_id, manager_id, first_name, last_name, title, salary
  3  ) VALUES (
  4    1, NULL, 'Jan', 'Kowalski', 'Prezes zarzĄdu', 800000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO more_employees (
  2    employee_id, manager_id, first_name, last_name, title, salary
  3  ) VALUES (
  4    2, 1, 'Roman', 'Jo«wierz', 'Kierownik sprzedaľy', 600000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO more_employees (
  2    employee_id, manager_id, first_name, last_name, title, salary
  3  ) VALUES (
  4    3, 2, 'Fryderyk', 'Helc', 'Sprzedawca', 200000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO more_employees (
  2    employee_id, manager_id, first_name, last_name, title, salary
  3  ) VALUES (
  4    4, 1, 'Zuzanna', 'Nowak', 'Kierownik wsparcia', 500000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO more_employees (
  2    employee_id, manager_id, first_name, last_name, title, salary
  3  ) VALUES (
  4    5, 2, 'Robert', 'Zielony', 'Sprzedawca', 40000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO more_employees (
  2    employee_id, manager_id, first_name, last_name, title, salary
  3  ) VALUES (
  4    6, 4, 'Joanna', 'BrĄz', 'Pracownik wsparcia', 45000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO more_employees (
  2    employee_id, manager_id, first_name, last_name, title, salary
  3  ) VALUES (
  4    7, 4, 'Jan', 'Szary', 'Kierownik wsparcia', 30000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO more_employees (
  2    employee_id, manager_id, first_name, last_name, title, salary
  3  ) VALUES (
  4    8, 7, 'Jadwiga', 'Niebieska', 'Pracownik wsparcia', 29000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO more_employees (
  2    employee_id, manager_id, first_name, last_name, title, salary
  3  ) VALUES (
  4    9, 6, 'Henryk', 'Borny', 'Pracownik wsparcia', 30000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO more_employees (
  2    employee_id, manager_id, first_name, last_name, title, salary
  3  ) VALUES (
  4    10, 1, 'Kazimierz', 'Czarny', 'Kierownik obs�ugi', 100000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO more_employees (
  2    employee_id, manager_id, first_name, last_name, title, salary
  3  ) VALUES (
  4    11, 10, 'Kamil', 'D�ugi', 'Pracownik obs�ugi', 50000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO more_employees (
  2    employee_id, manager_id, first_name, last_name, title, salary
  3  ) VALUES (
  4    12, 10, 'Franciszek', 'S�aby', 'Pracownik obs�ugi', 45000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO more_employees (
  2    employee_id, manager_id, first_name, last_name, title, salary
  3  ) VALUES (
  4    13, 10, 'Dorota', 'Prewa�', 'Pracownik obs�ugi', 47000
  5  );
SP2-0640: Not connected
SQL>
SQL> -- commit the transaction
SQL> COMMIT;
SP2-0640: Not connected
SQL>
SQL> -- insert sample data into divisions table
SQL>
SQL> INSERT INTO divisions (
  2    division_id, name
  3  ) VALUES (
  4    'SPR', 'Sprzedaľ'
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO divisions (
  2    division_id, name
  3  ) VALUES (
  4    'OPE', 'Obs�uga'
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO divisions (
  2    division_id, name
  3  ) VALUES (
  4    'WSP', 'Wsparcie'
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO divisions (
  2    division_id, name
  3  ) VALUES (
  4    'BIZ', 'Biznes'
  5  );
SP2-0640: Not connected
SQL>
SQL> -- commit the transaction
SQL> COMMIT;
SP2-0640: Not connected
SQL>
SQL> -- insert sample data into jobs table
SQL>
SQL> INSERT INTO jobs (
  2    job_id, name
  3  ) VALUES (
  4    'PRA', 'Pracownik'
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO jobs (
  2    job_id, name
  3  ) VALUES (
  4    'KIE', 'Kierownik'
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO jobs (
  2    job_id, name
  3  ) VALUES (
  4    'IN˝', 'Inľynier'
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO jobs (
  2    job_id, name
  3  ) VALUES (
  4    'TEC', 'Technolog'
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO jobs (
  2    job_id, name
  3  ) VALUES (
  4    'PRE', 'Prezes'
  5  );
SP2-0640: Not connected
SQL>
SQL> -- commit the transaction
SQL> COMMIT;
SP2-0640: Not connected
SQL>
SQL> -- insert sample data into employees2 table
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    1, 'BIZ', 'PRE', 'Jan', 'Kowalski', 800000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3    ) VALUES (
  4      2, 'SPR', 'KIE', 'Roman', 'Jo«wierz', 350000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    3, 'SPR', 'PRA', 'Fryderyk', 'Helc', 140000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    4, 'WSP', 'KIE', 'Zuzanna', 'Nowak', 200000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    5, 'SPR', 'PRA', 'Robert', 'Zielony', 350000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    6, 'WSP', 'PRA', 'Joanna', 'BrĄz', 200000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    7, 'WSP', 'KIE', 'Jan', 'Szary', 265000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    8, 'WSP', 'PRA', 'Joanna', 'Niebieska', 110000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    9, 'WSP', 'PRA', 'Henryk', 'Borny', 125000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    10, 'OPE', 'KIE', 'Kazimierz', 'Czarny', 225000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    11, 'OPE', 'KIE', 'Kamil', 'D�ugi', 165000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    12, 'OPE', 'PRA', 'Franciszek', 'S�aby', 125000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    13, 'OPE', 'PRA', 'Dorota', 'Prewa�', 145000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    14, 'BIZ', 'KIE', 'Marek', 'Kowalski', 155000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    15, 'BIZ', 'KIE', 'Julia', 'Nowak', 175000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    16, 'OPE', 'IN˝', 'Michalina', 'Krzysztoä', 245000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    17, 'WSP', 'TEC', 'Mateusz', 'Branek', 115000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    18, 'OPE', 'KIE', 'Tomasz', 'Czuma', 200000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    19, 'BIZ', 'KIE', 'Tatiana', 'Zuch', 200000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    20, 'OPE', 'KIE', 'Grzegorz', 'Klif', 215000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    21, 'SPR', 'KIE', 'Stefan', 'Zielony', 275000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    22, 'SPR', 'KIE', 'W�odzimierz', 'Czerwony', 375000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    23, 'SPR', 'KIE', 'Lucyna', 'Kowalski', 335000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    24, 'SPR', 'KIE', 'Gabriela', 'Srebro', 225000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    25, 'SPR', 'KIE', 'Micha�', 'Z�oto', 245000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    26, 'SPR', 'KIE', 'Helena', 'Zar©ba', 235000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    27, 'SPR', 'KIE', 'Dorota', 'Zawadzka', 235000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    28, 'SPR', 'KIE', 'Jacek', 'Lepszy', 235000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    29, 'SPR', 'KIE', 'Pawe�', 'Wolski', 245000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    30, 'SPR', 'KIE', 'Magdalena', 'Wr©cka', 255000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    31, 'SPR', 'KIE', 'Barbara', '˝˘�ta', 225000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    32, 'SPR', 'KIE', 'Sabina', 'Biel', 235000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    33, 'SPR', 'KIE', 'Tadeusz', '˝elazo', 225000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    34, 'SPR', 'KIE', 'Krystyna', 'BrĄz', 247000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    35, 'SPR', 'KIE', 'Jan', 'BrĄz', 249000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    36, 'SPR', 'KIE', 'Kamil', 'Treworski', 255000
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO employees2 (
  2    employee_id, division_id, job_id, first_name, last_name, salary
  3  ) VALUES (
  4    37, 'BIZ', 'PRA', 'Grzegorz', 'Nowak', 280000
  5  );
SP2-0640: Not connected
SQL>
SQL> -- commit the transaction
SQL> COMMIT;
SP2-0640: Not connected
SQL>
SQL> -- insert sample data into all_sales table
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 1, 2003, 1, 10034.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 1, 2003, 2, 15144.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 1, 2003, 3, 20137.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 1, 2003, 4, 25057.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 1, 2003, 5, 17214.564
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 1, 2003, 6, 15564.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 1, 2003, 7, 12654.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 1, 2003, 8, 17434.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 1, 2003, 9, 19854.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 1, 2003, 10, 21754.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 1, 2003, 11, 13029.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 1, 2003, 12, 10034.84
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 2, 2003, 1, 1034.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 2, 2003, 2, 1544.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 2, 2003, 3, 2037.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 2, 2003, 4, 2557.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 2, 2003, 5, 1714.564
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 2, 2003, 6, 1564.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 2, 2003, 7, 1264.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 2, 2003, 8, 1734.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 2, 2003, 9, 1854.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 2, 2003, 10, 2754.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 2, 2003, 11, 1329.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 2, 2003, 12, 1034.84
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 3, 2003, 1, 6034.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 3, 2003, 2, 1944.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 3, 2003, 3, 2537.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 3, 2003, 4, 4557.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 3, 2003, 5, 3714.564
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 3, 2003, 6, 3564.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 3, 2003, 7, 21264.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 3, 2003, 8, 21734.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 3, 2003, 9, 12854.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 3, 2003, 10, 32754.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 3, 2003, 11, 15329.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 3, 2003, 12, 14034.84
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 4, 2003, 1, 3034.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 4, 2003, 2, 2944.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 4, 2003, 3, 5537.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 4, 2003, 4, 3557.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 4, 2003, 5, 2714.564
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 4, 2003, 6, 7564.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 4, 2003, 7, 1264.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 4, 2003, 8, 21734.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 4, 2003, 9, 14854.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 4, 2003, 10, 22754.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 4, 2003, 11, 11329.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 4, 2003, 12, 11034.84
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 1, 2003, 1, 11034.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 1, 2003, 2, 16144.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 1, 2003, 3, 24137.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 1, 2003, 4, 29057.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 1, 2003, 5, 19214.564
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 1, 2003, 6, 16564.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 1, 2003, 7, 13654.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 1, 2003, 8, 17834.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 1, 2003, 9, 21854.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 1, 2003, 10, 18754.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 1, 2003, 11, 16529.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 1, 2003, 12, 9434.84
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 2, 2003, 1, 1234.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 2, 2003, 2, 1044.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 2, 2003, 3, 2537.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 2, 2003, 4, 2657.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 2, 2003, 5, 1314.56
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 2, 2003, 6, 1264.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 2, 2003, 7, 1964.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 2, 2003, 8, 1234.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 2, 2003, 9, 1954.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 2, 2003, 10, 2254.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 2, 2003, 11, 1229.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 2, 2003, 12, 1134.84
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 3, 2003, 1, 6334.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 3, 2003, 2, 1544.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 3, 2003, 3, 2737.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 3, 2003, 4, 4657.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 3, 2003, 5, 3714.56
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 3, 2003, 6, 3864.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 3, 2003, 7, 27264.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 3, 2003, 8, 17734.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 3, 2003, 9, 10854.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 3, 2003, 10, 15754.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 3, 2003, 11, 10329.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 3, 2003, 12, 12034.84
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 4, 2003, 1, 3334.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 4, 2003, 2, 2344.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 4, 2003, 3, 5137.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 4, 2003, 4, 3157.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 4, 2003, 5, 2114.564
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 4, 2003, 6, 7064.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 4, 2003, 7, 1564.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 4, 2003, 8, 12734.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 4, 2003, 9, 10854.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 4, 2003, 10, 20754.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 4, 2003, 11, 10329.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 4, 2003, 12, 2034.84
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 1, 2003, 1, 4034.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 1, 2003, 2, 7144.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 1, 2003, 3, 12137.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 1, 2003, 4, 16057.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 1, 2003, 5, 13214.564
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 1, 2003, 6, 3564.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 1, 2003, 7, 7654.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 1, 2003, 8, 5834.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 1, 2003, 9, 6754.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 1, 2003, 10, 12534.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 1, 2003, 11, 2529.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 1, 2003, 12, 7434.84
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 2, 2003, 1, 1234.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 2, 2003, 2, 2244.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 2, 2003, 3, 2137.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 2, 2003, 4, 2357.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 2, 2003, 5, 1314.56
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 2, 2003, 6, 1364.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 2, 2003, 7, 1364.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 2, 2003, 8, 1334.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 2, 2003, 9, 1354.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 2, 2003, 10, 2354.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 2, 2003, 11, 1329.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 2, 2003, 12, 1334.84
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 3, 2003, 1, 6334.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 3, 2003, 2, 1344.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 3, 2003, 3, 2337.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 3, 2003, 4, 4357.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 3, 2003, 5, 3314.56
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 3, 2003, 6, 3364.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 3, 2003, 7, 23264.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 3, 2003, 8, 13734.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 3, 2003, 9, 13854.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 3, 2003, 10, 13754.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 3, 2003, 11, 13329.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 3, 2003, 12, 13034.84
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 4, 2003, 1, 3334.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 4, 2003, 2, 2344.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 4, 2003, 3, 5337.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 4, 2003, 4, 3357.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 4, 2003, 5, 2314.564
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 4, 2003, 6, 7364.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 4, 2003, 7, 1364.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 4, 2003, 8, 13734.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 4, 2003, 9, 13854.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 4, 2003, 10, 23754.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 4, 2003, 11, 13329.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 4, 2003, 12, 2334.84
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 1, 2003, 1, 7034.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 1, 2003, 2, 17144.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 1, 2003, 3, 22137.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 1, 2003, 4, 24057.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 1, 2003, 5, 25214.564
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 1, 2003, 6, 14564.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 1, 2003, 7, 17654.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 1, 2003, 8, 15834.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 1, 2003, 9, 15854.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 1, 2003, 10, 22754.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 1, 2003, 11, 14529.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 1, 2003, 12, 10434.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 2, 2003, 1, 1934.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 2, 2003, 2, 2844.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 2, 2003, 3, 2837.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 2, 2003, 4, 2697.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 2, 2003, 5, 7314.56
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 2, 2003, 6, 1864.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 2, 2003, 7, 2364.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 2, 2003, 8, 4334.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 2, 2003, 9, 6654.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 2, 2003, 10, 2254.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 2, 2003, 11, 5429.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 2, 2003, 12, 3334.84
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 3, 2003, 1, 2334.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 3, 2003, 2, 4544.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 3, 2003, 3, 6337.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 3, 2003, 4, 3357.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 3, 2003, 5, 2314.56
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 3, 2003, 6, 1364.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 3, 2003, 7, 5264.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 3, 2003, 8, 1734.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 3, 2003, 9, 1854.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 3, 2003, 10, 1354.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 3, 2003, 11, 1332.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 3, 2003, 12, 3034.84
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 4, 2003, 1, 3364.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 4, 2003, 2, 4344.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 4, 2003, 3, 4337.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 4, 2003, 4, 2357.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 4, 2003, 5, 6314.564
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 4, 2003, 6, 4364.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 4, 2003, 7, 2364.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 4, 2003, 8, 3734.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 4, 2003, 9, 3854.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 4, 2003, 10, 3754.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 4, 2003, 11, 1329.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 4, 2003, 12, 7334.84
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 1, 2003, 1, 1234.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 1, 2003, 2, 6144.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 1, 2003, 3, 8137.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 1, 2003, 4, 14057.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 1, 2003, 5, 12214.564
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 1, 2003, 6, 4564.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 1, 2003, 7, 5654.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 1, 2003, 8, 8834.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 1, 2003, 9, 10854.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 1, 2003, 10, 12754.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 1, 2003, 11, 3529.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 1, 2003, 12, 5434.84
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 2, 2003, 1, 3434.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 2, 2003, 2, 1844.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 2, 2003, 3, 2137.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 2, 2003, 4, 1697.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 2, 2003, 5, 4314.56
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 2, 2003, 6, 3264.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 2, 2003, 7, 5364.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 2, 2003, 8, 3334.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 2, 2003, 9, 2654.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 2, 2003, 10, 454.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 2, 2003, 11, 2429.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 2, 2003, 12, 1334.84
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 3, 2003, 1, 1434.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 3, 2003, 2, 3544.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 3, 2003, 3, 1337.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 3, 2003, 4, 1457.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 3, 2003, 5, 1314.56
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 3, 2003, 6, 4364.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 3, 2003, 7, 1264.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 3, 2003, 8, 2734.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 3, 2003, 9, 4354.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 3, 2003, 10, 2354.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 3, 2003, 11, 3432.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 3, 2003, 12, 1534.84
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 4, 2003, 1, 1164.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 4, 2003, 2, 2144.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 4, 2003, 3, 4337.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 4, 2003, 4, 1357.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 4, 2003, 5, 2314.564
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 4, 2003, 6, 2364.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 4, 2003, 7, 3264.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 4, 2003, 8, 2234.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 4, 2003, 9, 3454.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 4, 2003, 10, 2754.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 4, 2003, 11, 3429.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 4, 2003, 12, 4334.84
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 1, 2003, 1, 5534.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 1, 2003, 2, 8844.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 1, 2003, 3, 5137.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 1, 2003, 4, 12057.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 1, 2003, 5, 10214.564
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 1, 2003, 6, 2564.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 1, 2003, 7, 3654.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 1, 2003, 8, 9834.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 1, 2003, 9, 9854.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 1, 2003, 10, 16754.27
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 1, 2003, 11, 5529.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 1, 2003, 12, 3434.84
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 2, 2003, 1, 5434.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 2, 2003, 2, 3844.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 2, 2003, 3, 5137.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 2, 2003, 4, 3697.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 2, 2003, 5, 2314.56
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 2, 2003, 6, 5264.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 2, 2003, 7, 3364.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 2, 2003, 8, 4334.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 2, 2003, 9, 4654.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 2, 2003, 10, 3454.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 2, 2003, 11, 4429.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 2, 2003, 12, 4334.84
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 3, 2003, 1, 2434.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 3, 2003, 2, 2544.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 3, 2003, 3, 5337.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 3, 2003, 4, 5457.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 3, 2003, 5, 4314.56
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 3, 2003, 6, 3364.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 3, 2003, 7, 3264.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 3, 2003, 8, 4734.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 3, 2003, 9, 2354.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 3, 2003, 10, 4354.34
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 3, 2003, 11, 2432.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 3, 2003, 12, 4534.84
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 4, 2003, 1, 3164.23
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 4, 2003, 2, 3144.65
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 4, 2003, 3, 6337.83
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 4, 2003, 4, 2357.45
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 4, 2003, 5, 4314.564
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 4, 2003, 6, 4364.64
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 4, 2003, 7, 2264.84
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 4, 2003, 8, 4234.82
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 4, 2003, 9, 2454.57
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 4, 2003, 10, 1554.19
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 4, 2003, 11, 2429.73
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 4, 2003, 12, 3334.85
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 5, 2003, 1, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 5, 2003, 2, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 5, 2003, 3, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 5, 2003, 4, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 5, 2003, 5, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 5, 2003, 6, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 5, 2003, 7, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 5, 2003, 8, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 5, 2003, 9, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 5, 2003, 10, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 5, 2003, 11, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    21, 5, 2003, 12, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 5, 2003, 1, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 5, 2003, 2, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 5, 2003, 3, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 5, 2003, 4, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 5, 2003, 5, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 5, 2003, 6, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 5, 2003, 7, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 5, 2003, 8, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 5, 2003, 9, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 5, 2003, 10, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 5, 2003, 11, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    22, 5, 2003, 12, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 5, 2003, 1, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 5, 2003, 2, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 5, 2003, 3, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 5, 2003, 4, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 5, 2003, 5, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 5, 2003, 6, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 5, 2003, 7, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 5, 2003, 8, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 5, 2003, 9, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 5, 2003, 10, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 5, 2003, 11, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    23, 5, 2003, 12, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 5, 2003, 1, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 5, 2003, 2, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 5, 2003, 3, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 5, 2003, 4, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 5, 2003, 5, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 5, 2003, 6, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 5, 2003, 7, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 5, 2003, 8, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 5, 2003, 9, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 5, 2003, 10, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 5, 2003, 11, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    24, 5, 2003, 12, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 5, 2003, 1, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 5, 2003, 2, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 5, 2003, 3, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 5, 2003, 4, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 5, 2003, 5, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 5, 2003, 6, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 5, 2003, 7, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 5, 2003, 8, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 5, 2003, 9, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 5, 2003, 10, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 5, 2003, 11, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    25, 5, 2003, 12, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 5, 2003, 1, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 5, 2003, 2, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 5, 2003, 3, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 5, 2003, 4, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 5, 2003, 5, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 5, 2003, 6, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 5, 2003, 7, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 5, 2003, 8, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 5, 2003, 9, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 5, 2003, 10, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 5, 2003, 11, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> INSERT INTO all_sales (
  2    emp_id, prd_type_id, year, month, amount
  3  ) VALUES (
  4    26, 5, 2003, 12, NULL
  5  );
SP2-0640: Not connected
SQL>
SQL> -- commit the transaction
SQL> COMMIT;
SP2-0640: Not connected
SQL>
SQL>
SQL> -- insert sample data into reg_exps table
SQL>
SQL> INSERT INTO reg_exps (
  2    id, text
  3  ) VALUES (
  4    1,
  5   'But, soft! What light through yonder window breaks?
  6  It is the east, and Juliet is the sun.
  7  Arise, fair sun, and kill the envious moon,
  8  Who is already sick and pale with grief,
  9  That thou her maid art far more fair than she.'
 10  );
SP2-0640: Not connected
SQL>
SQL> CREATE TABLE pivot_sales_data AS
  2    SELECT *
  3    FROM (
  4     SELECT month, prd_type_id, amount
  5     FROM all_sales
  6     WHERE year = 2003
  7     AND prd_type_id IN (1, 2, 3)
  8    )
  9    PIVOT (
 10      SUM(amount) FOR month IN (1 AS STY, 2 AS LUT, 3 AS MAR, 4 AS KWI)
 11    )
 12    ORDER BY prd_type_id;
SP2-0640: Not connected
SQL>
SQL> -- commit the transaction
SQL> COMMIT;
SP2-0640: Not connected
SQL> spool off
not spooling currently