Re: SQL*PLUS from text file?

From: Marc Legardeur <mlegardeur_at_lc2m.fr>
Date: Tue, 31 Aug 1999 16:55:26 +0200
Message-ID: <7qgqa7$lo3$1_at_oceanite.cybercable.fr>


You will find herewith an example of some set parameters for sqlplus and a spool to a text file :



  • Début de Script SQL Plus

Set echo off;
Set feedback off;
Set tab off;
Set trim on;
Set embedded on;
Set flush off;
Set newpage 0;
Set space 0
Set headsep off;
Set heading off;
Set linesize 630;
Set Pagesize 0;
Set echo off;
Spool transweb.log;
Select
refbaph||','
||nbpiec||','
||commune||','
||codepart||','
||secgeo||','
||aptmais||','
||round(mtquit)||','
||To_char(datlie,'DD-MM-YYYY')||','
||anpfd||','
||mtpfd||','
||nbpers||','
||temapl||','
||templaf||','
||temrecent||','
||noeta||','
||surfhab||','
||rtrim(nocompta)||','
||modchauf||','
||modpark||','
||modtransp||','
||temasc||','
||tembal||','
||temdlpx||','
||temjarrz||','
||temlogi||','
||temter||','
||vraipiec

From lwb
Order by substr(refbaph,1,6);
Spool off;
exit;

Mitch <mitchell7468_at_my-deja.com> a écrit dans le message : 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 Tue Aug 31 1999 - 16:55:26 CEST

Original text of this message