oracle version details:
=========================
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 0
PL/SQL Release 12.2.0.1.0 - Production 0
"CORE 12.2.0.1.0 Production" 0
TNS for Linux: Version 12.2.0.1.0 - Production 0
NLSRTL Version 12.2.0.1.0 - Production 0
I have a sample plsql code like below. Trying to write data to a file.
The spool file is generated data with plsql code as well.
How can we supress the code, so that i can i write only data to the file.
spool c:\test.txt;
declare
begin
dbms_output.put_line('data written to file');
end;
/
spool off;