CREATE OR REPLACE PROCEDURE PRO_POINT (v_date1in
varchar2,v_date2in
varchar2)iscursor c_dataisselect a.name,a.sex,a.address,b.point point1,c.point point2 from table1 a,table2 b,table2 cwhere a.name=b.nameand a.name=c.nameand b."date"=to_date(v_date1,'yyyy-mm-dd')and c."date"=to_date(v_date2,'yyyy-... |
