LAB 5:    System Tables

1. List the view name and view definition (the view definition is in the column TEXT) of all views you have created in the database.
   
   
2. List the number of tables you have created in the database.
   
   
3. Use USER_TAB_COLUMNS to list the column names of all columns in the HOLDING table.
   
   
4. Using USER_OBJECTS, display the object name and type of all objects you have created during the current month.  Don't hard code the current month in your query - use SYSDATE.  You can use the function to_char to extract the month and year.
   
   
5. Using USER_OBJECTS, for each object type, display the object type and total number of objects created of that type.
   
   
6. List the constraint name and constraint type of all constraints that have been given default names by Oracle (name starts with SYS).  Use USER_CONSTRAINTS.
   
   
7. List the number of unique indexes you have created (the column UNIQUENESS contains either the value UNIQUE or NONUNIQUE).