Announcements Last Post
Announcement SoC Curricula 09/30/2017 01:08PM
Announcement Demarcation or scoping of examinations and assessment 02/13/2017 07:59AM
Announcement School of Computing Short Learning Programmes 11/24/2014 08:37AM
Announcement Unisa contact information 07/28/2011 01:28PM
Assignment 2 Question 5 d
June 22, 2009 10:32PM
re: Assignment 2 Question 5 d

what are they asking of us in this question? I'm not exactly sure what to do.
avatar Re: Assignment 2 Question 5 d
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_viewswinking smiley
- SEQUENCES
(select sequence_name, min_value, increment_by from user_sequenceswinking smiley
- CONSTRAINTS
(select constraint_name, constraint_type from user_constraints where owner =
'STUDENT'winking smiley

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
Re: Assignment 2 Question 5 d
June 23, 2009 02:16PM
What do they mean by:
"Submit a printout of the report - refer back to the lesson dealing with Spooling of information to the printer"

I can't find any info in the textbook about spooling to the printer so I'm not sure how to submit the printout. Can I just copy and paste the info from the screen in SQL*Plus to Word?

Thanks!
Re: Assignment 2 Question 5 d
June 23, 2009 03:23PM
Cobus, thats exactly what I thought but was skeptical because it sounded so simple.
avatar Re: Assignment 2 Question 5 d
June 23, 2009 08:02PM
If I recall correctly, the previous questions where about schema changes, printing the results is a way to verify that you did it correctly.

Angela, I'm expect it will be fine if you copy and paste. But here is a few links that explain how to spool. Basically, the command is "SPOOL filename.log;" followed by your queries. To end the spooling, "SPOOL OFF;"

http://answers.yahoo.com/question/index?qid=20070326064727AAmeZ29
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14357/ch6.htm#sthref1443
http://www.dbapool.com/forumthread/topic_12599.html
http://answers.yahoo.com/question/index?qid=20070326064727AAmeZ29

Cobus Neethling
Sorry, only registered users may post in this forum.

Click here to login