Re: SQL*PLUS from text file?

From: Dagoberto Navea Alfaro <dago_at_cec.unap.cl>
Date: Thu, 9 Sep 1999 09:29:47 -0300
Message-ID: <7r8fld$51$1_at_manutara.inf.utfsm.cl>

Next script sql spool to file text(textfile.dat), I hope help you. --- Begin script sql
set newpage 0
set linesize 79
set pagesize 0
set echo off
set feedback off
set heading off
set flu off
spool textfile.dat
set space 0
select ltrim(to_char(ma.fieldnumber1,'09999999'))||ma.onechar||

       rpad(substr(so.fieldchar60,1,50),50)||
       rpad(substr(co.fieldchar15,1,20),20)

from tablema ma
where ma.kcodcarr >= 2302
/
spool off
---- End scrip sql

Mitch escribió en mensaje <7q3bvm$k5o$1_at_nnrp1.deja.com>...
>Could someone please point me in the right direction to information
>regarding running text scripts in SQL*PLUS. In particular, I am having
>difficulty with overlapping delimited fields when I spool to a text
>file. Like the LINESIZE is too few or something? Any assistance would
>be greatly appreciated.
>
>Paul
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Sep 09 1999 - 14:29:47 CEST