getcollegename.sql

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

CREATE OR REPLACE FUNCTION GET_COLLEGE_NAME (P_BH NUMBER)
		RETURN VARCHAR2  
				AS
  		V_NAME VARCHAR2(30);
		BEGIN
  		SELECT 院校名称 INTO V_NAME FROM COLLEGE WHERE 院校编号=P_BH;
  		RETURN (V_NAME);
		EXCEPTION 
		 WHEN OTHERS THEN
 		 RETURN('无');
		END;