The question reads:
(d) Use the correct Data Dictionary View to display the following information regarding your
database (submit a printout of the report – refer back to the lesson dealing with Spooling of
information to the printer).
Display information regarding the following objects created by the user STUDENT:
- VIEWS
(select view_name from user_views
- SEQUENCES
(select sequence_name, min_value, increment_by from user_sequences
- CONSTRAINTS
(select constraint_name, constraint_type from user_constraints where owner =
'STUDENT'
Basically, you need to run three queries and submit the printouts (paste into assignment):
select view_name from user_views;
select sequence_name, min_value, increment_by from user_sequences;
select constraint_name, constraint_type from user_constraints where owner =
'STUDENT';
Well, at least, that is how I did it.
Cobus Neethling