Example

CREATE VIEW STAFF_VIEW (Employee_id, Employee_name, Employee_dept) 
            AS SELECT ID,NAME,DEPT FROM STAFF