Hi, everyone …
I created this function,
CREATE or REPLACE function ReportaCC(pfcorte IN DATE)
RETURN SYS_REFCURSOR
AS
lcursor SYS_REFCURSOR;
BEGIN
OPEN lcursor FOR
select c1, c3, c3 from table1 where hdate = pfcorte;
RETURN lcursor ;
END;
/
And execute as
select ReportaCC(sysdate) from dual
Then i double click “cursor” in datagrid to see the results.
And opens a windows with data… how can i save/export that to excel?
Thanks…