Home » SQL & PL/SQL » 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
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: 25858
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/
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/
Previous Topic: insufficient privileges error while using copy command
Next Topic: temperature symbol required
Goto Forum:
  


Current Time: Sun Feb 25 05:37:16 CST 2018

Total time taken to generate the page: 0.25158 seconds