Re: export the result to a text file

From: Vincent Ventrone <vav_at_brandeis.edu>
Date: Tue, 25 Sep 2001 13:13:05 -0400
Message-ID: <9oqduo$iet$1@new-news.cc.brandeis.edu>

"WKC" <wkchen_at_bigfoot.com> wrote in message news:vC2s7.1961$n5.193455_at_typhoon.nyc.rr.com...
> In sqlplus, how can i export the result to a text file from a sql
statment?

In a UNIX shell script try this (connects to an externally-identified Oracle ID):

#
sqlplus -s / <<+EOF+
set feedback off
set verify off
set heading off
set echo off
set timing off
set showmode off
set pagesize 0
set newpage none
set linesize 200
set trim on
set trimspool on
set termout on
spool foo.lst
select value from v\$parameter where upper(name)='LOG_ARCHIVE_DEST'; spool off
exit
+EOF+ Received on Tue Sep 25 2001 - 12:13:05 CDT