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: 7880
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 message
Littlefoot
Messages: 20896
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.
Previous Topic: A DB Trigger calling a Oracle Procedure Which in Turn Calls a Java Function
Next Topic: Different order in oracle 8i and 10g
Goto Forum:
  


Current Time: Tue Dec 06 02:43:54 CST 2016

Total time taken to generate the page: 0.14284 seconds