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

Practice

1:	. Select the department names and employee names from the database. The department name should be lowercase, the last name should be uppercase, and only the first character of the first name should be capitalized.
2:	Select the department names and employee last names. The department name should be 20 characters, and the names should be preceded by the number sign (#). The last names should be 25 characters, and the minus sign (−) should follow the value.
3:	Concatenate the first and last names of the employees. Determine the length of the new values.
4:	Extract two characters from the employee’s first name. The extraction should begin at the second position.