Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Please Help to solve this problem

Re: Please Help to solve this problem

From: senthil <senthilkumarjs_at_gmail.com>
Date: 20 Feb 2006 21:26:26 -0800
Message-ID: <1140499586.256220.198160@o13g2000cwo.googlegroups.com>


The output of the sql file is spooled in a delimited format to txt file in our server. so even though the server is down from where we are retrieving the data, the spool file in our server contains data.

set heading off;
set pagesize 0;
set verify off;
set linesize 9999;
set trimspool on;
set feedback off;
set termout off;
set trimspoll on;

spool /apps/rptm/crons/temp/test.new;

SELECT column_name1, column_name2 from table_name;

spool off;
exit;

/ Received on Mon Feb 20 2006 - 23:26:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US