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: How to export from Oracle to text using Perl

Re: How to export from Oracle to text using Perl

From: Tim X <timx_at_spamto.devnul.com>
Date: 12 Jun 2003 19:34:31 +1000
Message-ID: <878ys7bpw8.fsf@tiger.rapttech.com.au>


>>>>> "Brian" == Brian Peasland <oracle_dba_at_remove_spam.peasland.com> writes:

 Brian> The biggest downside in using SQL*Plus is that SQL*Plus will
 Brian> render the output to the screen. This can be overcome with
 Brian> redirection in a Unix environment though.

 Brian> Cheers, Brian

Or simply put

set term off
spool output_file_name

and then you don't get screen output.

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!
Received on Thu Jun 12 2003 - 04:34:31 CDT

Original text of this message

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