SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
oracle script needed immediately

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
oracle script needed immediately
Author Message
deepak



Joined: 02 Nov 2000
Posts: 1

Post oracle script needed immediately Reply with quote

On January first of some year, a fungus in a large
Petri dish has a radius of 1mm, and every day
afterward grows 2mm in radius. Between any two dates
in that year, how much does the area of the fungus
change?
Write a script named fungus_script_ssss_nnnnnn.sql
(where ssss is your CS65 section number and nnnnnn is
your student ID).

(1) The script first drops, then creates a stored
procedure named fungus_procedure_ssss_nnnnnn (with two
input parameters and one output parameter):

l input: date_begin entered as a string in format
DD-MMM-YYYY.
l input: date_end in the same format and for the
same year as date_begin.
l output: area_change (which is the change in area of
the mold, the difference in the two areas of the
circular mold on the two dates). The two areas must
be found from the table, then the smaller (or same)
area for the earlier (or same date) subtracted from
the area for the second date.

(2) creates a table named fungus_table_ssss_nnnnnn
with columns named
A_Month, A_Day, A_Radius, and An_Area.

(3) enters records into the table by using loops,
where
l A_Month is the month of the year, spelled out fully
in capital letters, beginning with JANUARY and ending
with DECEMBER
l A_Day is the day of the month, beginning with 1 and
ending with the last day of the month (28, 29, 30, or
31 depending on the month). Leap years are based on
the Gregorian calendar (not Julian). The number of
days in February depends on the year YYYY
l A_Radius is the radius of mold growing in a big
Petri dish, beginning with radius 1 millimeter on
January 1 with radius increasing by 2 millimeters per
day. For example, on January 2, the radius is 3 mm;
on January 3, the radius is 5 mm, etc.
l An_Area is the area of the mold, pr2 where p =
3.1415926 and r is the radius of the mold on that day.

(4) In your script, following that stored procedure,
write an anonymous PL/SQL program that
(a) calls the procedure with actual dates entered as
literals
(b) outputs to the screen your name, student ID, CS65
section number, the two input dates, and the
area_change of the fungus.

Use many concise comments in your coding. Debug,
execute, and print your script. Copy your script
CS65_3_ssss_nnnnnn.sql to the folder on Server Zeus
named CS65 Project 3 Section sssss. If you must drop
a 2nd version of your script, name it
CS65_3_ssss_nnnnnnB.sql Please backup your files.
Correct file names and comments will be graded, along
with your code.

Thanks Regards
DEEPAK


Thu Nov 02, 2000 7:55 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: oracle script needed immediately Reply with quote

It looks like you have posted your message to the wrong message board. This forum is dedicated for for DB Tools and DB Mail product support issues.

: On January first of some year, a fungus in a large
: Petri dish has a radius of 1mm, and every day
: afterward grows 2mm in radius. Between any two dates
: in that year, how much does the area of the fungus
: change?
: Write a script named fungus_script_ssss_nnnnnn.sql
: (where ssss is your CS65 section number and nnnnnn is
: your student ID).

: (1) The script first drops, then creates a stored
: procedure named fungus_procedure_ssss_nnnnnn (with two
: input parameters and one output parameter): l input: date_begin entered as a
: string in format
: DD-MMM-YYYY.
: l input: date_end in the same format and for the
: same year as date_begin.
: l output: area_change (which is the change in area of
: the mold, the difference in the two areas of the
: circular mold on the two dates). The two areas must
: be found from the table, then the smaller (or same)
: area for the earlier (or same date) subtracted from
: the area for the second date.

: (2) creates a table named fungus_table_ssss_nnnnnn
: with columns named
: A_Month, A_Day, A_Radius, and An_Area.

: (3) enters records into the table by using loops,
: where
: l A_Month is the month of the year, spelled out fully
: in capital letters, beginning with JANUARY and ending
: with DECEMBER
: l A_Day is the day of the month, beginning with 1 and
: ending with the last day of the month (28, 29, 30, or
: 31 depending on the month). Leap years are based on
: the Gregorian calendar (not Julian). The number of
: days in February depends on the year YYYY
: l A_Radius is the radius of mold growing in a big
: Petri dish, beginning with radius 1 millimeter on
: January 1 with radius increasing by 2 millimeters per
: day. For example, on January 2, the radius is 3 mm;
: on January 3, the radius is 5 mm, etc.
: l An_Area is the area of the mold, pr2 where p =
: 3.1415926 and r is the radius of the mold on that day.

: (4) In your script, following that stored procedure,
: write an anonymous PL/SQL program that
: (a) calls the procedure with actual dates entered as
: literals
: (b) outputs to the screen your name, student ID, CS65
: section number, the two input dates, and the
: area_change of the fungus.

: Use many concise comments in your coding. Debug,
: execute, and print your script. Copy your script
: CS65_3_ssss_nnnnnn.sql to the folder on Server Zeus
: named CS65 Project 3 Section sssss. If you must drop
: a 2nd version of your script, name it
: CS65_3_ssss_nnnnnnB.sql Please backup your files.
: Correct file names and comments will be graded, along
: with your code.

: Thanks Regards
: DEEPAK

Thu Nov 02, 2000 11:00 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.