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

Which of the following is the correct 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);