text: CREATE VIEW emp_view AS 
     SELECT last_name, salary*12 annual_salary
     FROM employees 
     WHERE department_id = 20;
  
  CREATE EDITIONING VIEW ed_orders_view (o_id, o_date, o_status)
    AS SELECT order_id, order_date, order_status FROM orders
    WITH READ ONLY;
  
  CREATE VIEW emp_sal (emp_id, last_name, 
        email UNIQUE RELY DISABLE NOVALIDATE,
     CONSTRAINT id_pk PRIMARY KEY (emp_id) RELY DISABLE NOVALIDATE)
     AS SELECT employee_id, last_name, email FROM employees;
  
  CREATE VIEW clerk AS
     SELECT employee_id, last_name, department_id, job_id
     FROM employees
     WHERE job_id = 'PU_CLERK'
        or job_id = 'SH_CLERK'
        or job_id = 'STA_CLERK';
  
  CREATE VIEW clerk AS
     SELECT employee_id, last_name, department_id, job_id
     FROM employees
     WHERE job_id = 'PU_CLERK'
        or job_id = 'SH_CLERK'
        or job_id = 'ST_CLERK'
     WITH CHECK OPTION;
  
  CREATE VIEW locations_view AS
     SELECT d.department_id, d.department_name, l.location_id, l.city
     FROM departments d, locations l
     WHERE d.location_id = l.location_id;
  
  CREATE VIEW customer_ro (name, language, credit)
        AS SELECT cust_last_name, nls_language, credit_limit
        FROM customers
        WITH READ ONLY;
  
  CREATE OR REPLACE VIEW oc_inventories OF inventory_typ
   WITH OBJECT OID (product_id)
   AS SELECT i.product_id,
             warehouse_typ(w.warehouse_id, w.warehouse_name, w.location_id),
             i.quantity_on_hand
      FROM inventories i, warehouses w
      WHERE i.warehouse_id=w.warehouse_id;
  
  CREATE EDITIONABLE VIEW TEST (A, B, C)
        AS SELECT 'A', 'B', 'C'
        FROM DUAL;
  
  CREATE VIEW TEST (A, B, C)
        AS 
        WITH TESTCTE AS (
          SELECT 1 ONE FROM DUAL
        )
        SELECT 'A', 'B', 'C'
        FROM DUAL
        JOIN TESTCTE;
  