Xref: alice comp.databases.oracle.tools:31639
Path: alice!news-feed.fnsi.net!enews.sgi.com!logbridge.uoregon.edu!cyclone-east.rr.com!news.rr.com!news-east.rr.com!news-out.cwix.com!newsfeed.cwix.com!maule!utfsm!not-for-mail
From: "Dagoberto Navea Alfaro" <dago@cec.unap.cl>
Newsgroups: comp.databases.oracle.tools
Subject: Re: SQL*PLUS from text file?
Date: Thu, 9 Sep 1999 09:29:47 -0300
Organization: Universidad Tecnica Federico Santa Maria
Lines: 35
Message-ID: <7r8fld$51$1@manutara.inf.utfsm.cl>
References: <7q3bvm$k5o$1@nnrp1.deja.com>
X-Trace: manutara.inf.utfsm.cl 936886765 161 146.83.152.18 (9 Sep 1999 14:19:25 GMT)
X-Complaints-To: napoli@inf.utfsm.cl,molguin@inf.utfsm.cl
NNTP-Posting-Date: 9 Sep 1999 14:19:25 GMT
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3

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@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.