getstudentname.sql

来自「一个挺好的招生管理系统」· SQL 代码 · 共 12 行

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;