Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts

Practice

1:	A user you support is in need of a mailing list. The names of the employees on the list must be formatted with each employee’s title. Precede female-employee names with Ms. Precede male-employee names with Mr. This type of data does not exist in the database. You have been asked to create a database view that contains this feature.
2:	Create a view that displays employee records and wages for the WEL department. Put a check option on the view. Using the view, change the department number to INT for employees living in plains. (You should not be able to update the record.)