Toad World® Forums

Exporting results + SQL into Excel?


#1

Hi,

Please help the n00b! In the past using Toad for Oracle I would export results including SQL simultaneously on a separate tab in Excel 2003. I’m trying to do the same in Toad for Data Analyst 2.5 and can’t figure it out…Any ideas?


#2

Currently including the SQL when exporting is an enhancement request (CR63,902).

You can try the following for now. In a script include the original sql followed by a sql that bounces the sql off of dual. This will put the sql in the second worksheet. It won’t be formatted but it will be included.

IE:

Select a from b;

Select ‘Select a from b’ from dual;

Debbie


#3

Thanks, it worked!