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
Initializing Records The illustration below shows that you can initialize a record in its type definition. Whenever you declare a record of the type TimeRec, its 3 fields supp

Mixed Notation The fourth procedure call shows that you can mix the positional and named notation. In this situation, the first parameter uses the positional notation, & the s

Object Types An object type is a user-defined complex datatype which encapsulates the data structure along with the functions and procedures required to manipulate the data. Th

Creating and Destroying Base Tables: Example shows an SQL command to create the base table counterpart of the ENROLMENT variable Example  Creating a base table. CREATE T

At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean’s wants to create a trigger that automatically updates the stock level of all pr

Transaction Control The Oracle is transaction oriented; that is, Oracle uses the transactions to make sure the data integrity. The transaction is a sequence of SQL data manip

Predefined Exceptions The internal exception is raised implicitly whenever your PL/SQL program exceeds a system-dependent limit or violates an Oracle rule. Each & every Oracle

Short-Circuit Evaluation When computing a logical expression, the PL/SQL uses short-circuit evaluation. That is, the PL/SQL stops computing the expression as soon as the result

Complete the following steps to create a procedure to calculate the tax on an order. The BB_TAX table contains the states that require taxes to be submitted for Internet sales. If

SQL Operators The PL/SQL uses all the SQL set, comparison, and row operators in the SQL statements. This part briefly describes some of these operators.  1. Comparison Opera