I am using the sql statement listed below in my spool sql script, and I am executing this script from sqlplus. But in terminal query output is still coming and I am using sqlplus in command prompt. But when I tried, directly launching sqlplus.exe and using this script I am not getting query output in terminal.
Can someone please help on how to stop terminal output when I launch sqlplus from command prompt?
SET ECHO OFF SET TERMOUT OFF SET FEEDBACK OFF SET PAGESIZE 0 SET LINESIZE 83 SET TRIMSPOOL ON SET WRAP ON SET RECSEP OFF SPOOL '&1' SELECT DATA_OUT_DATA FROM STAGE.DATA_TABLE ORDER BY DATA_UNIQ_ID,DATA_INV_ID, DATA_SEQ_NO; SPOOL OFF SET PAGESIZE 24 SET LINESIZE 80 SET FEEDBACK ON SET TERMOUT ON