CREATE OR REPLACE PACKAGE ordering_pkg IS
Pv_total_num NUMBER(3,2);
PROCEDURE order_total_pp
(p_bsktid IN NUMBER,
P_sub OUT NUMBER);
FUNCTION ship_calc_pf
(p_qty IN NUMBER)
RETURN NUMBER;
END;
The code fragment above is an example of a(n) ____.
A) anonymous block
B) package body
C) package specification
D) package scope

Question

Quizplus · Accepted Answer

The code fragment is a package specification, as it starts with the keyword "CREATE OR REPLACE PACKAGE" and contains PROCEDURE and FUNCTION declarations. A package body would follow with the keyword "CREATE OR REPLACE PACKAGE BODY" and implement the functions and procedures declared in the specification. The package scope refers to the visibility of variables and objects declared within a package, which is not relevant to this code fragment. An anonymous block would start with the keyword "BEGIN" and end with the keyword "END;" and is used for procedural code execution outside of a packaged procedure or function.

CREATE OR REPLACE PACKAGE Ordering_pkg IS