i'm exporting data from a table to a txt file
but in the top of the file is written the sql statement
i need that in the file are written only data
have u any suggestion?
tnx
(sorry for the english ...)

"CogitoErgoDigito" <XSAMUELE (AT) HOTMAIL (DOT) COM> wrote

Do you have any parameters in you SELECT. i.e, &variables?

This may cause the SQL to appear again when running (or parts of it anyway).

Can't reproduce a SQL statement appearing from a script that reads

SELECT *
FROM user_taboles
/

Remember, though, that if you only want data from SQL*Plus to remove
headings and stuff with

SET PAGES 0
SET FEEDBACK OFF
SET VERIFY OFF

as well.