Re: Spool filename Extension URGENT

How silly of me. Thanks
In article <93i2jh$9k$1_at_nnrp1.deja.com>,   le_fort_at_my-deja.com wrote:
> 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/
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 10 2001 - 12:00:06 CST