Home » Other » Client Tools » SQL for saving the query result in a txt file (2 Merged) (Oracle 11g)
SQL for saving the query result in a txt file (2 Merged) [message #554808] Thu, 17 May 2012 10:22 Go to next message
dineshtgs
Messages: 1
Registered: May 2012
Location: Hyderabad
Junior Member
Hi,

I want to execute a query which automatically saves the result of a set of queries in a text file and have to send that as an attachment thru a mail (using UTL_MAIL or UTL_SMTP) thru a stored procedure
Please help me in saving the result in a text file in Toad.

Thx in advance
Dinesh

Report message to a moderator

Re: SQL - Saving query result in a txt file [message #554812 is a reply to message #554808] Thu, 17 May 2012 10:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: SQL - Saving query result in a txt file [message #554822 is a reply to message #554812] Thu, 17 May 2012 12:38 Go to previous message
muralikri
Messages: 638
Registered: August 2011
Location: chennai
Senior Member
Go to this URL...get some clue..

www.orafaq.com/forum/t/170034/0/

Report message to a moderator

Previous Topic: insufficient privileges error while using copy command
Next Topic: temperature symbol required
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 24 21:39:00 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.