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
Expression: This is a randomly complex combination of constants, variables, literals, operators, & function calls. The simplest expression consists of a single variable. If th

Challenge 1 You are required to do the project and write a test plan for it. Demo 4 is a check writer program for employees. In it, the user enters all information about the

Using SAVEPOINT The SAVEPOINT names and marks the present point in the processing of a transaction. Used with the ROLLBACK TO statement, the savepoints undo parts of a transac

CHECK Constraints in SQL A CHECK constraint is a table constraint defined using the key word CHECK, as already illustrated in several examples in this chapter. In particular,

Example of WRAP Operator - SQL The effect of Example can be obtained in SQL but note that one needs to write down not only the names of the columns being wrapped but also the

UPDATE Statement   The UPDATE statement transforms the values of the specified columns in one or more rows in the table or view. Syntax:

I would like to have a custom MS Access database designed and coded that would help me schedule my customer's orders and that would help me track my employees production output and

The Package Body The package specification is implemented by the package body. That is, the package body has the definition of every cursor and the subprogram declared in the p

Initial thought process: Design a script which was simple and user friendly. Integrate procedures/functions to extract data under the hood. I focused on giving the user the opt

Use External Routines The PL/SQL is particular for the SQL transaction processing. Therefore, several tasks are more quickly completed in a lower-level language like C that is