getscore.sql

一个挺好的招生管理系统

CREATE OR REPLACE FUNCTION GET_SCORE (P_BH NUMBER)
		RETURN NUMBER
		AS
	V_SCORE NUMBER(3);
		BEGIN
		  SELECT 总分 INTO V_SCORE FROM SCORE WHERE 编号=P_BH;
  		RETURN (V_SCORE);
		EXCEPTION 
		 WHEN OTHERS THEN
 		 RETURN(-1);
		END;