How to generate a spool file without an extension name (.lst,.txt etc...) [message #297675] |
Sat, 02 February 2008 05:47  |
senaubi_me
Messages: 24 Registered: February 2008
|
Junior Member |
|
|
Hello there!
I am in need of urgent help. i do believe that when you used the command SPOOLfilename without specifying an extension name, it automatically puts an .lst extension name. Can you help me identify if there is any way i can generate a file without an extension name? I am in need of help right now. I hope someone will answer my post as soon as possible. I really really appreciate it!
Thanks,
Jen
|
|
|
|
|
|
|
|
Re: How to generate a spool file without an extension name (.lst,.txt etc...) [message #682330 is a reply to message #682326] |
Fri, 16 October 2020 08:15  |
 |
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
chikurde@gmail.com wrote on Fri, 16 October 2020 03:17Please let me know how to remove default extension while creating file using spool utility.
My reaction to taht question is the same I had when I read the same from the OP, whose old thread you have hijacked.
And that reaction is "why would you want to?" You can _change_ the extenstion by simply specifying it:
or
or
spool myspool.myextension
So why would you want a file named 'myspool' -- with no extension at all? If you really, really, really need that (doubtful), rename it with the OS after you exit sqlplus, or even use sqlplus's 'host' command:
spool myspool.txt
select sysdate from dual;
spool off
host ren myspool.txt myspool
|
|
|