This preview shows page 1. Sign up to view the full content.
Unformatted text preview: Note the types and names of the constraints. Save your statement text in a file called p11q4.sql 5. Display the object names and types from the USER_OBJECTS data dictionary view EMPLOYEE and DEPARTMENT tables. You may want to format the columns for readability. Notice that the new tables and a new index were created. 6. Modify the EMPLOYEE table. Add a SALARY column of NUMBER data type, precision 7....
View Full Document
This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.
- Summer '10