Re: sql plus setting

From: Alan Mills <Alan.Mills_at_xservices.pants.fujitsu.com>
Date: Wed, 16 Jul 2003 15:45:38 +0100
Message-ID: <bf3ohs$fvd$1@news.icl.se>

"CogitoErgoDigito" <XSAMUELE_at_HOTMAIL.COM> wrote in message news:f29ca887.0307160618.1ab9cd4a_at_posting.google.com...
> 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 ...)

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. Received on Wed Jul 16 2003 - 09:45:38 CDT