Notes

/*
Name=Sudeep Rai
Id:18406505
Week:15
Date:22nd Feb, 2019
*/
--@E:cdp_databaseFuncPrac_18406505.txt



CREATE OR REPLACE FUNCTION func_instructor_ct RETURN NUMBER IS vn_instructor_ct NUMBER(3);
BEGIN
SLECET COUNT(*) INTO vn_instructor_ct FROM instructors;
RETURN vn_instructor_ct;
END func_instructor_ct;
/

CREATE OR REPLACE PROCEDURE proc_using_func IS
BEGIN
DBMS_OUTPUT.LINE('The nuumber of instructors is' || func_instructor_ct);
END proc_using_func;
/

CREATE OR REPLACE FUNCTION func_param_ct(in_salary instructors.salary%TYPE) RETURN NUMBER IS
vn_instructor_ct NUMBER(3);
BEGIN
SELECT COUNT(*) INTO vn_instructor_ct FROM instructors
WHERE salary > in_salary;
RETURN vn_instructor_ct;
END func_param_ct;
/

SET SERVEROUTPUT ON;
CREATE OR REPLACE PROCEDURE proc_param_using_func(in_salary instructors.salary%TYPE) IS
BEGIN
DBMS_OUTPUT.LINE('The nuumber of instructors is' || func_param_ct(in_salary));
END proc_param_using_func;