oracel sql script
CREATE OR REPLACE PROCEDURE SelectSchool(paramSchoolId IN char,p_cursor OUT SYS_REFCURSOR
) AS
BEGINOPEN p_cursor FORSELECT *FROM SchoolWHERE SchoolId paramSchoolId;
END SelectSchool;
/-- 查询所有
CREATE OR REPLACE PROCEDURE SelectScho…