can you expand this procedure to save it to a file?
declare
siddate varchar2(20);
begin
select 'FILE=SID_'||to_char(sysdate,'YYMMDD')||'.DMP' INTO SIDDATE FROM DUAL;
DBMS_OUTPUT.PUT_LINE(SIDDATE);
DBMS_OUTPUT.PUT_LINE('GRANTS=Y');
DBMS_OUTPUT.PUT_LINE('FULL=Y');
DBMS_OUTPUT.PUT_LINE('ROWS=Y');
END;
/




Reply With Quote