dbTalk Databases Forums  

Automate a few steps with TOAD

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss Automate a few steps with TOAD in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AP
 
Posts: n/a

Default Automate a few steps with TOAD - 12-17-2007 , 04:43 PM






Hello
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.

Reply With Quote
  #2  
Old   
DA Morgan
 
Posts: n/a

Default Re: Automate a few steps with TOAD - 12-18-2007 , 12:27 AM






AP wrote:
Quote:
Hello
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.