#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

Which of the following is the example of modifying a view where salary manager_id is null?

Answer

CREATE OR REPLACE VIEW WORKERS (EMPLOYEE_ID, SURNAME,FIRSTNAME, MANAGER_ID)AS (EMPLOYEE_ID, LASTNAME, FIRSTNAME, MANAGER_ID)FROM EMPLOYEES WHERE MANAGER_ID IS NULL);