---- Function created.Code:CREATE OR REPLACE FUNCTION F_subj(code_semester number) RETURN number IS code_sub NUMBER BEGIN SELECT count(codesub) INTO code_sub FROM Subjects where Semester=code_semester RETURN code_sub; END
--- Function altered.Code:alter function f_subj compile
--- Output:Code:select f_subj(5) from dual
F_SUBJ(5)
----------
4
Last edited by Bloo_uni; 26-11-2012 at 03:46 PM.