Normal Assignment Points: 40 Using the procedures and Functions you created in t

Question

Normal Assignment Points: 40 Using the procedures and Functions you created in the Create Procedure/Functions assignment(s), create a package that will house those procedures and Functions. After you have done that then create another package that will delete, update, insert into another table within the same database as well. You will then have two packages that will m?nage 2 different tables in the same database. RESULTS Package the procedures and function you have already created in assignment #6. Create a second package which does the same functionality on another table. Run your procedures and functions from within your package against the Test database to ensure there are no errors. Include the SQL statement to create the package as well as statements to run the content within it in 1 file. Include SQL statements to test that the procedure worked correctly after it is executed Submit your file to Black Board I. 2. 3. 4. 5. Focus ? ords English (United States)

Explanation / Answer

First create a package with definition only. syntax: CREATE OR REPLACE PACKAGE pkg AS BEGIN ?ALL PRODCEDURES AND FUNCTION DEFINITION ONLY? END Second create package body with below syntax: CREATE OR REPLACE PACKAGE BODY pkg AS PROCEDURE ?Procedure name? (?parameteres?) IS BEGIN ?PROCEDURE BODY? END FUNCTION addressLabel(customer_name in VARCHAR(2)) RETURN VARCHAR2 AS v_customer_name VARCHAR(50) BEGIN customer_name(v_customer_name) END addressLabel; . . . ?add all functions and procedures here? END pkg; /

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.