Assignment 2 Question 5 d
Posted by migamildien
| Announcements | Last Post | |
|---|---|---|
 |
SoC Curricula | 09/30/2017 01:08PM |
|
Demarcation or scoping of examinations and assessment | 02/13/2017 07:59AM |
|
School of Computing Short Learning Programmes | 11/24/2014 08:37AM |
|
Unisa contact information | 07/28/2011 01:28PM |
|
June 23, 2009 08:27AM |
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
(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
|
June 23, 2009 08:02PM |
Sorry, only registered users may post in this forum.