Примеры команд SQL в рамках урока #15

-- Вставка данных в таблицу
-- https://www.youtube.com/watch?v=rd4ULZdOTzw

-------------------------------------------
-- Примеры команд SQL в рамках урока #15


SELECT * FROM KMV_CUSTOMERS;


CREATE TABLE KMV_CUSTOMERS
    (
        customer_id         NUMBER,
        customer_name   varchar2(50),
        city            varchar2(50)
    )
;


INSERT INTO KMV_CUSTOMERS
     (customer_id, customer_name, city)
VALUES
     (991, 'Иванов Иван Иванович', 'Москва');
commit;


INSERT INTO KMV_CUSTOMERS (customer_id, customer_name, city) VALUES (992, 'Петров Иван Иванович', 'Пермь');
INSERT INTO KMV_CUSTOMERS (customer_id, customer_name, city) VALUES (993, 'Сидоров Иван Иванович', 'Краснодар');
INSERT INTO KMV_CUSTOMERS (customer_id, customer_name, city) VALUES (994, 'Скворцов Иван Иванович', 'Уфа');
commit;


INSERT ALL
  INTO KMV_CUSTOMERS (customer_id, customer_name, city) VALUES (995, 'Петров Иван Иванович', 'Мурманск')
  INTO KMV_CUSTOMERS (customer_id, customer_name, city) VALUES (996, 'Петров Иван Иванович', 'Омск')
  INTO KMV_CUSTOMERS (customer_id, customer_name, city) VALUES (997, 'Петров Иван Иванович', 'Волгоград')
SELECT * FROM dual;
commit;


SELECT
    EMPLOYEE_ID,
    FIRST_NAME ||' '|| LAST_NAME AS CUSTOMER_NAME,
    'n/a' AS CITY
FROM HR.EMPLOYEES
WHERE EMPLOYEE_ID IN (100, 105, 110, 115, 120)
ORDER BY EMPLOYEE_ID;


INSERT INTO KMV_CUSTOMERS (CUSTOMER_ID, CUSTOMER_NAME, CITY)
SELECT
    EMPLOYEE_ID,
    FIRST_NAME ||' '|| LAST_NAME AS CUSTOMER_NAME,
    'n/a' AS CITY
FROM HR.EMPLOYEES
WHERE EMPLOYEE_ID IN (100, 105, 110, 115, 120)
ORDER BY EMPLOYEE_ID;
commit;


INSERT INTO KMV_CUSTOMERS (CITY, CUSTOMER_NAME, CUSTOMER_ID)
VALUES ('Уфа', 'Скворцов Иван Иванович', 994);
commit;


INSERT INTO KMV_CUSTOMERS (CITY, CUSTOMER_ID)
VALUES ('Уфа', 994);
commit;


INSERT INTO KMV_CUSTOMERS
VALUES  (997, 'Петров Иван Иванович', 'Волгоград');
commit;


DROP TABLE KMV_CUSTOMERS_NEW purge;
CREATE TABLE KMV_CUSTOMERS_NEW
AS
SELECT
    EMPLOYEE_ID,
    FIRST_NAME ||' '|| LAST_NAME AS CUSTOMER_NAME,
    'n/a' AS CITY
FROM HR.EMPLOYEES
WHERE EMPLOYEE_ID IN (100, 105, 110, 115, 120)
ORDER BY EMPLOYEE_ID;
commit;


SELECT * FROM KMV_CUSTOMERS_NEW;