create or replace procedure p_cnt(p_time in varchar2,—查询的条件p_cur out SYS_REFCURSOR)—游标返回ISv_sql varchar2(1000) :=\
;v_date varchar2(20)
;BEGIN v_date := replace(p_time, -, \);—时间的格式转换 v_sql := select * from dapartment d where d.d_time =\|| v_date||\\
;END; OPEN p_cur FOR v_sql;END p_cnt;