SQL Plus Formatting 1

[marjac]

I am creating a CSV file and am using an input value in SQL Plus to select data.

(AND SCHYEAR = SUBSTR('&SCHYEAR',6,4)
selects the end of a school year input like ‘2003-2004’

I have
set echo off
set serveroutput on size 1000000
set linesize 300
set heading off
set feedback off

but I still get
Enter value for schyear: 2003-2004
old 21: AND SCHYEAR = SUBSTR('&SCHYEAR' 6 4);
new 21: AND SCHYEAR = SUBSTR('2003-2004' 6 4);
in the first 3 lines of the CSV file.

Does anyone know how I format SQL Plus so these 3 lines do not show up in the CSV file?

 

[lewisp]

I assume from this you still want to prompt the user for a value for SCHYEAR? Try this:

[tt]set echo off
set serveroutput on size 1000000
set linesize 300
set heading off
set feedback off

ACCEPT SCHYEAR PROMPT "Enter the SCHYEAR "

spool yourfile

SELECT yoursql
FROM yourtable
WHERE something = '&SCHYEAR';

spool off[/tt]

 

[marjac]

Thanks for responding so quickly lewisp...it worked, Yay!