getstudentname.sql

一个挺好的招生管理系统

CREATE OR REPLACE FUNCTION GET_STUDENT_NAME(P_BH NUMBER)
		RETURN VARCHAR2
			AS
 		 V_NAME VARCHAR2(10);
		BEGIN
 		 SELECT 姓名 INTO V_NAME FROM STUDENT WHERE 编号=P_BH;
  		RETURN(V_NAME);
		EXCEPTION
		WHEN OTHERS THEN
  		 RETURN('无');
		END;