Exporting results + SQL into Excel?


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?

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.


Select a from b;

Select ‘Select a from b’ from dual;


Thanks, it worked!