ORACLE Consultas HR Views

/* ACTIVIDADES LABORATORIO  */
/* NOMBRE: VICTOR H. MORALES M.

 /* PREGUNTA 1 */
CREATE OR REPLACE VIEW EMP1_VIEW (NOMBRE, APELLIDO, SUELDO)
AS  SELECT FIRST_NAME, LAST_NAME
FROM EMPLOYEES
WITH READ ONLY
/*CONSULTAS*/
DESCRIBE EMP1_VIEW
/*CONSULTAS*/
SELECT *
FROM EMP1_VIEW

/* PREGUNTA 2 */
CREATE OR REPLACE VIEW EMP2_VIEW (NOMBRE, APELLIDO, SUELDO, CARGO, NOMBRE_DEPARTAMENTO)
AS
SELECT EMPLOYEES.FIRST_NAME, EMPLOYEES.LAST_NAME, EMPLOYEES.SALARY, JOBS.JOB_TITLE, DEPARTMENTS.DEPARTMENT_NAME
FROM EMPLOYEES, JOBS, DEPARTMENTS
WHERE (JOBS.JOB_ID = EMPLOYEES.JOB_ID) AND (DEPARTMENTS.DEPARTMENT_ID = EMPLOYEES.DEPARTMENT_ID)
WITH CHECK OPTION
/*CONSULTAS*/
DESCRIBE EMP2_VIEW
/*CONSULTAS*/
SELECT *
FROM EMP2_VIEW

/* PREGUNTA 3 */
CREATE MATERIALIZED VIEW EMP3_VIEW (NOMBRE, APELLIDO, SUELDO, CARGO, NOMBRE_DEPARTAMENTO)
BUILD IMMEDIATE
USING INDEX
REFRESH FORCE ON DEMAND
DISABLE QUERY REWRITE
AS
    SELECT EMPLOYEES.FIRST_NAME, EMPLOYEES.LAST_NAME, EMPLOYEES.SALARY, JOBS.JOB_TITLE, DEPARTMENTS.DEPARTMENT_NAME
FROM EMPLOYEES, JOBS, DEPARTMENTS
WHERE (JOBS.JOB_ID = EMPLOYEES.JOB_ID) AND (DEPARTMENTS.DEPARTMENT_ID = EMPLOYEES.DEPARTMENT_ID)
/*CONSULTAS*/
DESCRIBE EMP3_VIEW
/*CONSULTAS*/
SELECT *
FROM EMP3_VIEW

/* PREGUNTA 3 */
DROP VIEW EMP1_VIEW
DROP VIEW EMP2_VIEW
DROP VIEW EMP3_VIEW