Home » SQL & PL/SQL » SQL & PL/SQL » How to generate a spool file without an extension name (.lst,.txt etc...) (SQL)
icon4.gif  How to generate a spool file without an extension name (.lst,.txt etc...) [message #297675] Sat, 02 February 2008 05:47 Go to next message
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 #297683 is a reply to message #297675] Sat, 02 February 2008 07:22 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Cool eh, searching..
Found this link within a single minute..

Next time things are so "urgent", don't rely on forums. If you do, don't mention that it is urgent, it tends to put people off.
Re: How to generate a spool file without an extension name (.lst,.txt etc...) [message #297815 is a reply to message #297675] Sun, 03 February 2008 22:10 Go to previous messageGo to next message
senaubi_me
Messages: 24
Registered: February 2008
Junior Member
I am the one who posted that on oracle forums. I am user618088.
And yes i already got the answer.

Thanks,
Jen
Re: How to generate a spool file without an extension name (.lst,.txt etc...) [message #297842 is a reply to message #297815] Sun, 03 February 2008 23:25 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
senaubi_me wrote on Mon, 04 February 2008 05:10
I am user618088.

And I'm Mrs Margaret Thatcher (in disguise).

Just kidding; however, how is anyone supposed to know that senaubi_me = user618088. Besides, once you get the answer, it would be nice to post the solution so that other form members might learn something from it.
Re: How to generate a spool file without an extension name (.lst,.txt etc...) [message #682326 is a reply to message #297815] Fri, 16 October 2020 03:17 Go to previous messageGo to next message
chikurde@gmail.com
Messages: 1
Registered: October 2020
Junior Member
Please let me know how to remove default extension while creating file using spool utility.
Re: How to generate a spool file without an extension name (.lst,.txt etc...) [message #682327 is a reply to message #682326] Fri, 16 October 2020 04:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Afaik, there is no way.

[Updated on: Fri, 16 October 2020 04:31]

Report message to a moderator

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 Go to previous message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
chikurde@gmail.com wrote on Fri, 16 October 2020 03:17
Please 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:

spool myspool.log
or

spool myspool.txt
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
Previous Topic: Pivot using SQL in Oracle
Next Topic: Tree order, Sum of valid values
Goto Forum:
  


Current Time: Thu Mar 28 16:09:31 CDT 2024