Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Spool filename Extension URGENT

Spool filename Extension URGENT

From: <sanjayraj6844_at_my-deja.com>
Date: Wed, 10 Jan 2001 15:17:25 GMT
Message-ID: <93hudp$s1r$1@nnrp1.deja.com> 






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/
Received on Wed Jan 10 2001 - 09:17:25 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US