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
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.

What Are Subprograms? The Subprograms are named PL/SQL blocks which can take parameters and be invoked. The PL/SQL has 2 types of subprograms known as the procedure s and func

Other monadic - SQL In 2VL there are just 4 (2 2 ) monadic operators, of which negation is really the only "useful" one. When a third truth value is introduced we have 27 (3 3

Parameter and Keyword Description: package_name: This construct identifies the package. AUTHID Clause: This determine whether all the packaged subprograms impleme

%TYPE Attribute The %TYPE attribute gives the datatype of a record, field, nested table, database column, or the variable. You can use the %TYPE attribute as the datatype speci

EXIT Statement   You can use the EXIT statement to exit a loop. The EXIT statement has 2 forms: the conditional EXIT WHEN and the unconditional EXIT. With the either form, you

1. a. Write a trigger that fires when a part's price is updated. The trigger will write a record into a table called PriceUpdates. The record should contain the information of

Use the MASCOT tables CREDITRS, PORDS and PAYMENTS to write SQL queries to solve the following business problems. These tables / data are available to you via the USQ Oracle server

%ROWCOUNT When its cursor or cursor variable is opened, the %ROWCOUNT is zeroed. Before the first fetch, the %ROWCOUNT yields 0. Afterward, it yields the number of rows fetche

Keys in SQL SQL support for keys in the following respects: SQL does not require at least one key for every base table. If no key is explicitly declared, then KEY {ALL B