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
Passing Cursor Parameters You use the OPEN statement to pass the parameters to a cursor. Unless you want to accept the default values, each proper parameter in the cursor decl

Iteration Schemes The bounds of a loop range can be variables, literals, variables, or expressions but must compute to integers. Below are some of the examples. As you can see t

Name Resolution In potentially uncertain SQL statements, the names of the database columns take precedence over the names of the local variables and formal parameters. For e.g.

Using ROLLBACK The ROLLBACK statements end the present transaction and undo any change made during the transaction. The Rolling back is helpful for two reasons. Firstly, if yo

UNION and OR - SQL SQL supports UNION explicitly but differently from the way it supports JOIN explicitly. As we have seen, JOIN is used exclusively within the FROM clause, su

Using Aggregation on Nested Tables Example is the most direct translation of its counterpart in the theory book that can be obtained in SQL but it is so over-elaborate that no

I want to implement heap sort algorithm in pl sql please share the source code for guidance

Control Structures The Control structures are the most important PL/SQL extension to the SQL. Not only does PL/SQL let you manipulate Oracle data, it lets you process the data

Components of an Object Type: An object type encapsulates the operations and data. Therefore, you can declare the methods and attributes in an object type specification, but no

Example of Cast Operator So long as CAST is used as shown, we could obtain the total marks for each exam in similar fashion, using SUM (Mark) AS TotalMarks. However, this giv