This preview shows page 1. Sign up to view the full content.
Unformatted text preview: 4. Modify the EMPLOYEE table to allow for longer employee last names. Confirm your modification. 5. Confirm that both the DEPARTMENT and EMPLOYEE tables are stored in the data dictionary. ( Hint : USER_TABLES) 6. Create the EMPLOYEE2 table based on the structure of the EMP table, include only the EMPNO, ENAME and DEPTNO columns. Name the columns in your new table ID, LAST_NAME and DEPT_ID, respectively. 7. Drop the EMPLOYEE table. 8. Rename the EMPLOYEE2 table to EMPLOYEE. 9. Add a comment to the DEPARTMENT and EMPLOYEE table definitions describing the tables. Confirm your additions in the data dictionary....
View Full Document
- Summer '10