Re: Spool filename Extension URGENT

From: <le_fort_at_my-deja.com>
Date: Wed, 10 Jan 2001 16:28:49 GMT
Message-ID: <93i2jh$9k$1@nnrp1.deja.com>

try
spool /voyager/data1/NEW/detail_prof_in_&territoryid..txt (sic !)

you probably tried &territoryid.txt and received as spool file f.i. territoryidtxt.lst (replace territoryid with any valid value). the reason is, that "." is the default concatenation character in sqlplus (someone had a really good laugh thinking that up, and most certainly still has), so the resulting filename has no extension and sqlplus therefore uses the default .lis (or .lst)

HTH,
le_fort

In article <93hudp$s1r$1_at_nnrp1.deja.com>, sanjayraj6844_at_my-deja.com wrote:
> URGENT. Can anybody help
>
> I have created the following script to spool the results to a file. I
> want the extension of the spool filename to be .TXT or something other
> than .LST. Is it possible & How?
>
> set pages 0 linesize 200
> accept territoryid char format 'A10'-
> prompt'Enter territoryid :'
> spool /voyager/data1/NEW/detail_prof_in_&territoryid
> select
> ACCTID,
> Territoryid,
> LastNm,
> FirstNm,
> Addr1,
> Addr2,
> City,
> Stprovcode,
> Zippc
> from prof
> where territoryid='&territoryid'
> order by lastnm
> /
> spool off
>
> Thanks
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 10 2001 - 10:28:49 CST