Toad World® Forums

TOAD newbie


#1

Hi All,

I’m a new TOAD Oracle & SQL user and trying to learn as fast as I can :slight_smile:

I inherited some queries that need to run and save as a pipe | delimited .txt file daily, I’m wondering if there’s a way to automate the ‘save as’ and file location process?

for example…is there a set command or statement i can insert in my sql that I can just run and it would save as the same file name and location?

Thank you for any advice.


#2

that I can just run and it would save as the same file name and location?

Greetings;

You’re magic command is… SPOOL

In Oracle, the format is pretty basic, a windows client example:

Spool c:\example\working\path\file_name.txt

Roger S.