CLONAR TABLAS , UNION INTERSECCION Y MINUS

--Como clonar tablas
CREATE TABLE EMPLOYEES_2 AS
(
SELECT *
FROM EMPLOYEES
);

CREATE TABLE EMPLOYEES_3 AS
(
SELECT EMPLOYEE_ID AS ID_EMPLEADO,
       FIRST_NAME || ' ' || LAST_NAME AS NOMBRE_COMPLETO
FROM EMPLOYEES
WHERE JOB_ID = 'IT_PROG'
);

CREATE TABLE EMPLOYEES_4 AS
(
SELECT * FROM EMPLOYEES
WHERE 1 = 2
);

CREATE TABLE EMPDPTO30 AS
(
SELECT * FROM EMPLOYEES
WHERE DEPARTMENT_ID = 30
);

CREATE TABLE EMPDPTO20 AS
(
SELECT * FROM EMPLOYEES
WHERE DEPARTMENT_ID = 20
);

CREATE TABLE EMPLEADOS AS
(
SELECT * FROM EMPLOYEES
WHERE DEPARTMENT_ID IN (20,30,70,90)
);

SELECT * FROM EMPDPTO30;
SELECT * FROM EMPDPTO20;
SELECT * FROM EMPLEADOS;

DROP TABLE EMPDPTO30;
-----------------------------------------------------
--INSERTAR DOS VALORES NUEVOS

INSERT INTO EMPDPTO30
VALUES ('201','Michael','Hartstein','MHARTSTE','515.123.5555','17/02/04','MK_MAN',13000,NULL,100,20);

INSERT INTO EMPDPTO30
VALUES ('202','Pat','Fay','PFAY','603.123.6666','17/08/05','MK_REP',6000,NULL,201,20);
----------------------------------------------
--UNION
SELECT E.FIRST_NAME || ' ' ||E.LAST_NAME AS NOMBRE_COMPLETO,
       D.DEPARTMENT_ID,
       D.DEPARTMENT_NAME
FROM EMPDPTO20 E
INNER JOIN DEPARTMENTS D ON(E.DEPARTMENT_ID=D.DEPARTMENT_ID)
UNION
SELECT E.FIRST_NAME || ' ' ||E.LAST_NAME AS NOMBRE_COMPLETO,
       D.DEPARTMENT_ID,
       D.DEPARTMENT_NAME
FROM EMPDPTO30 E
INNER JOIN DEPARTMENTS D ON(E.DEPARTMENT_ID=D.DEPARTMENT_ID);

--VER PPT 27 PARA MAS INFORMACION