do you know anyone that can do this type of coding or not?, PL-SQL Programming

Task 2 [12 marks]
Write the package body for the following package specification (the detailed description of each function and procedure is provided in the appendix below). Place the package specification (as is) and the package body in your SQL script. The marks for each function and procedure are of equal value (3 marks).

create or replace package assignment3
is
procedure open_class(Class_Info in Tut_Prac%ROWTYPE);

procedure enrol_student(SID in enrol.StudentID%TYPE, CID in enrol.ClassID%TYPE);

function compute_wam(SID in AcademicRec.StudentID%TYPE) return number;

procedure unit_dependencies(CNo in Course_Prerequisite.CourseNo%TYPE);

end assignment3;
/
Posted Date: 11/4/2012 1:22:29 AM | Location : Australia







Related Discussions:- do you know anyone that can do this type of coding or not?, Assignment Help, Ask Question on do you know anyone that can do this type of coding or not?, Get Answer, Expert's Help, do you know anyone that can do this type of coding or not? Discussions

Write discussion on do you know anyone that can do this type of coding or not?
Your posts are moderated
Related Questions
Scoping Within the similar scope, all the declared identifiers should be unique. So, even if their datatypes differ, the variables and parameters cannot share the similar name.

Set Operators The Set operators combine the results of the two queries into one result. The INTERSECT returns all the distinct rows selected by both queries. The MINUS returns

Rollback Behavior When a FORALL statement fails, the database changes are rolled back to an implicit savepoint marked before each of the SQL statement execution. The Changes t

Use the NOCOPY Compiler Hint By default, the OUT and IN OUT parameters are passed by the value i.e. the value of an IN OUT actual parameter is copied into the corresponding fo

Transaction Visibility As the figure shows, the changes made by an autonomous transaction become visible to another transaction whenever the autonomous transaction commits. Th

Using DEFAULT You can use the keyword DEFAULT rather than that of the assignment operator to initialize the variables. For e.g. the declaration blood_type CHAR := ’O’; it can b

Cursor Variables As Parameters You can declare the cursor variables as the formal parameters of the functions and procedures. In the illustration below, you define the REF CUR

Running the PL/SQL Wrapper To run the PL/SQL Wrapper, go through the wrap command at your operating system prompt by using the syntax as shown: wrap iname=input_file [oname=

Relational Operators and Logical Operators It prepares the ground for subsequent sections in which each specific relational operator is paired with its logical counterpart, su

Collection Methods:   The collection method is a built-in function or procedure which operates on the collections and is called using the dot notation. The methods like the C