Assignment #8
Data Dictionary
1. Describe the data dictionary view called DICTIONARY.
DESCRIBE dictionary
2. List the names of all the users whose objects you have access to in the database.
3. List the comments on the columns for the STUDENT table along with their column names.
SELECT column_name, comments
4. Show the source text, the name of the owner, and the view name for a view of your choosing. You may
choose one of the Data dictionary views if you wish or you may create a view.
5. Show the columns for the Primary Key constraints in tables owned by STUDENT (Note: Constraint Type is
‘P’ for Primary Key constraint).
SELECT column_name, a.table_name