336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
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;
'Oracle' 카테고리의 다른 글
Sequence (0) | 2006.11.25 |
---|---|
Denying DML Operations & Removing a View (0) | 2006.11.24 |
Using the WITH CHECK OPTION Clause (0) | 2006.11.24 |
Using the WITH CHECK OPTION Clause (0) | 2006.11.24 |
Rules for Performing DML Operations on a View (0) | 2006.11.24 |