Answer to Question #268393 in Databases | SQL | Oracle | MS Access for tumi

Question

Question 1                                                                                                                                                         [20]

Write a PL/SQL anonymous block that will prompt the user to enter a particular student number and the displays the student’s registration information. Refer to the sample output below

Enter value for studentno: 97003455

Student: SMUTS, JH

DOB / age: 12-JAN-70(51)

No. of Subject enrolled: 6

Total Fees payable: 7900

Registration date: 10-JAN-97

 

Enter value for studentno: 94001111

Student: PETOORS, WHY

DOB / age: 03-DEC-75(45)

No. of Subject enrolled: 1

Total Fees payable: 500

Registration date: Date Unknown

Answer 1

CREATE OR REPLACE PROCEDURE cust_spent (
    reg_num      IN    info.stud_num%TYPE,
    name_output    OUT   info.stud_nume%TYPE,
    age_output     OUT   info.stud_age%TYPE,
    subjects_output   OUT   info.subj_num%TYPE
    fees_output   OUT   info.stud_fees%TYPE
    regdate_output   OUT   info.reg_date%TYPE
) AS