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

-- Обновление и удаление данных в таблице
-- https://www.youtube.com/watch?v=xPYxWoj8cuw

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


SELECT * FROM KMV_CUSTOMERS;


CREATE TABLE KMV_CUSTOMERS AS
SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, HIRE_DATE
FROM HR.EMPLOYEES
WHERE EMPLOYEE_ID IN (100, 105, 110, 115, 120);
commit;


UPDATE KMV_CUSTOMERS
SET HIRE_DATE = '01.01.1999'
WHERE EMPLOYEE_ID = 105;
commit;


UPDATE KMV_CUSTOMERS
SET FIRST_NAME = 'Иван',
    LAST_NAME = 'Иванов'
WHERE EMPLOYEE_ID = 105;
commit;


UPDATE KMV_CUSTOMERS
SET FIRST_NAME = 'Иван',
    LAST_NAME = 'Иванов'
WHERE EMPLOYEE_ID IS NOT NULL;
commit;


DELETE FROM KMV_CUSTOMERS
WHERE EMPLOYEE_ID = 105;
commit;


DELETE FROM KMV_CUSTOMERS
WHERE EMPLOYEE_ID IS NOT NULL;
commit;