Oracle

Denying DML Operations & Removing a View

Figo Kim 2006. 11. 24. 17:08
CREATE OR REPLACE VIEW empvu10
            (employee_number, employee_name, job_title)
AS
SELECT employee_id, last_name,job_id
FROM    employees
WHERE   department_id = 10
WITH READ ONLY;


DROP VIEW view_name;