Re: Automate a few steps with TOAD
Date: Mon, 17 Dec 2007 22:27:31 -0800
> Here is what I am trying to do:
> I have a simple SQL string, select * from dre.tool_master
> I need to automate the running of this command and the creation of an
> excel or text file to a specific network folder.
> Not sure where to start because I have not used TOAD for anything
> other than running queries.
> Thanks in advance.
You may need to automate something but this isn't going to be it.
So lets start with basics ... in what version?
You are going to need to either spool the output to your local drive or use UTL_FILE. Choose wisely.
Docs are at http://tahiti.oracle.com.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue Dec 18 2007 - 07:27:31 CET