Re: Spooling

From: Roger Stapley <rstapley_at_uk.oracle.com>
Date: Fri, 21 Jan 2000 17:00:06 +0000
Message-ID: <38889096.65BA499@uk.oracle.com>

COL column_name NEW_VALUE column_name

SELECT 'bbb' column_name
FROM dual;

SPOOL &&column_name.txt

Will spool a file called bbb.txt

HTH. "Ste C." wrote:
>
> Is there any way that I can select a column from a table and then use
> the selected as a filename for spooling to?
>
> Thanks
>
> Stephen
> --
> Arrgh
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Jan 21 2000 - 11:00:06 CST