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;
(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;